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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > -- - michael dykman - [EMAIL PROTECTED] - 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/[EMAIL PROTECTED]