[OA] MySQL 5

[Gordon Falk]

Is anyone else running MySQL 5 yet?

 

I updated my Debian system a few weeks ago, and the update included
migrating from 4.x to 5.x.  Open Admin *seems* to behave fine with it,
except for one issue that I need to resolve.  When editing assignments in
the grade book, the following error is logged.

 


The DBI error string is: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to
use near 'schema = '', weight = '79', grp = 'Assignments' where id = '1479''
at line 3 


I have had a similar issue with the CMS system Mambo.  There, it was just a
matter of changing the order of some LEFT JOIN statements in the SQL.  I
will be trying to figure this out today, if anyone has had this issue arise
and has a solution, it would save me some time.

 

While I did the Debian update a few weeks ago, it is amazing that no on
complains until this week.  Probably because report cards go out on
Wednesday.

 

Thanks for the help,

Gord

 

Gordon Falk,

IT Coordinator

Cornerstone Christian School

 

work: 306.693.2937

cell: 306.630.8491

fax:  306.694.1880

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.pananix.com/pipermail/openadmin/attachments/20060505/4f311959/attachment.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Gordon Falk.vcf
Type: text/x-vcard
Size: 129 bytes
Desc: not available
Url : http://www.pananix.com/pipermail/openadmin/attachments/20060505/4f311959/GordonFalk.vcf