SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:20 AM
| ||||
| ||||
 Re: problem with initdb script in lxr installation - newbie needs help 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 version is 5.0.22. The script requires 4.x. If Fedora core 6 allows without dependency issues I have no problem with 4.x. Anyways I think it would be better if the script can be corrected because it will be useful for the majority newbies like me. On 5/7/07, Michael Dykman <mdykman@gmail.com> wrote: > perhaps you might share with us what error you are getting and what > version of MyQSL you are using? The more context you can suply, the > better. > > > On 5/7/07, Shahbaz Khan <shaz.linux@gmail.com> wrote: > > 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.x version and if so what needs to be done? > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=mdykman@gmail.com > > > > > > > -- > - michael dykman > - mdykman@gmail.com > > - All models are wrong. Some models are useful. >      |
|
02-28-2008, 06:20 AM
| ||||
| ||||
| Re: problem with initdb script in lxr installation - newbie needshelp 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 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 version is 5.0.22. The script requires 4.x. If Fedora > core 6 allows without dependency issues I have no problem with 4.x. > Anyways I think it would be better if the script can be corrected > because it will be useful for the majority newbies like me. > > On 5/7/07, Michael Dykman <mdykman@gmail.com> wrote: >> perhaps you might share with us what error you are getting and what >> version of MyQSL you are using? The more context you can suply, the >> better. >> >> >> On 5/7/07, Shahbaz Khan <shaz.linux@gmail.com> wrote: >> > 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.x version and if so what needs to be done? >> > >> > >> > -- >> > MySQL General Mailing List >> > For list archives: http://lists.mysql.com/mysql >> > To unsubscribe: >> http://lists.mysql.com/mysql?unsub=mdykman@gmail.com >> > >> > >> >> >> -- >> - michael dykman >> - mdykman@gmail.com >> >> - All models are wrong. Some models are useful. >> > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=mogens@fumlersoft.dk > > > -- > This message has been scanned for viruses and > dangerous content by OpenProtect(http://www.openprotect.com), and is > believed to be clean. > -- Later Mogens Melander +45 40 85 71 38 +66 870 133 224 -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean. |
Linear Mode
