This may be of interest to some of you. We'll try to get the queries
into a more sql compliant form as we go because we want Fez to work
with other DBs in the future.
---------- Forwarded message ----------
From: Leire Urcelay <Leire.Urcelay@...>
Date: Dec 14, 2006 9:22 PM
Subject: RE : RE : RE : [Fez-users] Fez 1.3 Test Version
To: Matthew Smith <yo.checkit@...>
I have some good news regarding my database problems. It is a sql mode
Regarding the log files, I've found that there were two different errors:
a) 1292: Incorrect datetime value =3D> with format format yyyy-mm-ddThh:mm:=
b) 1366: Incorrect integer value =3D> when trying to set '' value to an
integer column instead of a null value.
The way MySql is interpreting the SQL queries is configured by the SQL-MODE
attribute. In my case, the value of this attribute (default value, set
during installation) was the following:
It seems that the strict mode was causing my problems. In any case, if I
remove the "STRICT_TRANS_TABLES" value from the SQL-MODE attribute, both
problems described above are solved.
I don't know if it is the best or the correct way to solve this problem...
Note: Solving this problem, now, I'm able to see the created documents unde=
"Recently Added Items". Before, due to the dates issue (I suppose), nothin=
was displayed there.
Best regards and thanks a lot for your help,
De: Leire Urcelay [mailto:Leire.Urcelay@...]
Envoy=E9: jeudi, 14. d=E9cembre 2006 09:03
=C0: 'Matthew Smith'
Objet: RE : RE : RE : [Fez-users] Fez 1.3 Test Version
For the instance, I'm running My Sql 5.0 on windows xp.
We have fez 1.2 installed on Linux, but I cannot install there this new
version yet, since there are some other users using it.
De: Matthew Smith [mailto:yo.checkit@...]
Envoy=E9: jeudi, 14. d=E9cembre 2006 07:22
=C0: Leire Urcelay
Objet: Re: RE : RE : [Fez-users] Fez 1.3 Test Version
The datetime error that you had doesn't appear on our mysql server -
what version of mysql are you running- is it on windows too?
> > 2) Even if everything is working correctly, I have a lot of errors
> > to the date formats in the error_handler.log file. I give you an
> > [txt] =3D> Array
> > (
> >  =3D> Array
> >  =3D> (
> >  =3D>  =3D> DB Error: unknown error
> >  =3D>  =3D> INSERT INTO
> >  =3D>
> > fezdev_1_3.fez_record_matching_field
> >  =3D> (
> >  =3D> rmf_rec_pid,
> >  =3D> rmf_rec_pid_num,
> >  =3D> rmf_dsid,
> >  =3D> rmf_xsdmf_id,
> >  =3D> rmf_date
> >  =3D> ) VALUES (
> >  =3D> 'servaldev:1382',
> >  =3D> 1382,
> >  =3D> '',
> >  =3D> 3678,'2006-12-08T17:48:08Z')
> > [nativecode=3D1292 ** Incorrect datetime value: '2006-12-08T17:48:08Z' =
> > column 'rmf_date' at row 1]
> >  =3D> )
> >  =3D>
> > )
> > [script] =3D>
> > C:\ApacheGroup\Apache2\htdocs\fez_1.3_rc\include\class.record.php
> > [line] =3D> 722
> > This error is produced for almost all the entries in the
> > fez_record_matching_field table. I have executed the following query i=