List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:May 8 2007 10:51am
Subject:Re: problem with initdb script in lxr installation - newbie needs
help
View as plain text  
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@stripped> 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@stripped> 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=1
>> >
>> >
>>
>>
>> --
>>  - michael dykman
>>  - mdykman@stripped
>>
>>  - 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=1
>
>
> --
> 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.

Thread
problem with initdb script in lxr installation - newbie needs helpShahbaz Khan7 May
Re: problem with initdb script in lxr installation - newbie needs helpShahbaz Khan8 May
  • Re: problem with initdb script in lxr installation - newbie needs helpMogens Melander8 May