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
> 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.