lists.netmrg.net lists.netmrg.net
NetMRG discussion and support
 
FAQ :: Search :: Memberlist :: Usergroups :: Register
Profile :: Log in to check your private messages :: Log in

MYSQL problem

 
Post new topic   Reply to topic    lists.netmrg.net Forum Index -> Support
Author Message
srinivassin
Beginner


Joined: 10 Feb 2005
Posts: 6

PostPosted: Mon Jan 15, 2007 1:42 pm    Post subject: MYSQL problem Reply with quote

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]#

OS:Fedora Core release 6 (Zod)
mysql-server-5.0.27-1.fc6

thanks
Back to top
silfreed
Site Admin


Joined: 19 Jan 2003
Posts: 394
Location: Shippensburg, PA, USA

PostPosted: Mon Jan 15, 2007 3:18 pm    Post subject: Reply with quote

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    lists.netmrg.net Forum Index -> Support All times are GMT
Page 1 of 1

 



smartBlue Style © 2002 Smartor
Powered by phpBB © 2001, 2002 phpBB Group