MYSQL problem

srinivassin

15-01-2007 08:42:18

Hi, when i try to configure. i got this error msg. I am not well in mysql. help plz.

[root@test1 init.d]# mysql -u root -p netmrg < /usr/local/share/netmrg/db/netmrg.mysql
Enter password
ERROR 1064 (42000) at line 11 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 'condition smallint(6) NOT NULL default '0',
logic_condition smallint(6) NOT NU' at line 5
[root@test1 init.d]#

OSFedora Core release 6 (Zod)
mysql-server-5.0.27-1.fc6

thanks

silfreed

15-01-2007 10:18:17

This is a problem that our database schema has with MySQL 5. MySQL 5 introduced a new keyword, "conditions," that we previously used.

We've addressed the issue on this forum before here
http//lists.netmrg.net/viewtopic.php?t=345

And fixed it in bug#448.

You can also checkout the latest SVN copy using the info at the bottom of the download page.

-Doug