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@...>
Hi Matt,
I have some good news regarding my database problems. It is a sql mode
issue.
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:=
ssZ
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:
sql-mode=3D"STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
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.
sql-mode=3D"NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
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=
r
"Recently Added Items". Before, due to the dates issue (I suppose), nothin=
g
was displayed there.
Best regards and thanks a lot for your help,
Leire
-----Message d'origine-----
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
Hi Matt,
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.
Best regards,
Leire
-----Message d'origine-----
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?
matt
> >
> > 2) Even if everything is working correctly, I have a lot of errors
related
> > to the date formats in the error_handler.log file. I give you an
example:
> >
> >
> >
> >
> > [txt] =3D> Array
> >
> > (
> >
> > [0] =3D> Array
> >
> > [1] =3D> (
> >
> > [2] =3D> [0] =3D> DB Error: unknown error
> >
> > [3] =3D> [1] =3D> INSERT INTO
> >
> > [4] =3D>
> > fezdev_1_3.fez_record_matching_field
> >
> > [5] =3D> (
> >
> > [6] =3D> rmf_rec_pid,
> >
> > [7] =3D> rmf_rec_pid_num,
> >
> > [8] =3D> rmf_dsid,
> >
> > [9] =3D> rmf_xsdmf_id,
> >
> >
> > [10] =3D> rmf_date
> >
> > [11] =3D> ) VALUES (
> >
> > [12] =3D> 'servaldev:1382',
> >
> > [13] =3D> 1382,
> >
> > [14] =3D> '',
> >
> > [15] =3D> 3678,'2006-12-08T17:48:08Z')
> > [nativecode=3D1292 ** Incorrect datetime value: '2006-12-08T17:48:08Z' =
for
> > column 'rmf_date' at row 1]
> >
> > [16] =3D> )
> >
> > [17] =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=
n
> DB:
> >
>
|