Re: problem with initdb script in lxr installation - newbie needs help

2007-05-08 Thread Mogens Melander
RELEASE is a reserved word, and if used as column-name, it must be quoted (back-tick) `release` char(255) . On Tue, May 8, 2007 12:09, Shahbaz Khan wrote: > This is the exact error that mySQL reported: > > ERROR 1064 (42000): You have an error in you sql syntax; check the > manual that corres

Re: problem with initdb script in lxr installation - newbie needs help

2007-05-08 Thread Shahbaz Khan
This is the exact error that mySQL reported: ERROR 1064 (42000): You have an error in you sql syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release char(255) bunary not null, primary key (fileid,relea' at line 3 MySQL server versi

problem with initdb script in lxr installation - newbie needs help

2007-05-07 Thread Shahbaz Khan
This portion of the script gives error. reate table lxr_releases (fileid int not null references lxr_files, release char(255) binary not null, primary key (fileid,release) The script is present as attachment if needed. I suspect this script is for mysql 4