By webmestre@coll-vallcarca.net on

Hi,

I'm trying to import at my localhost with mysql 5.0, the install that I have on mysql 4.0 that is running on the web. The error that it gives is this:

ERROR 1064 (42000) at line 83820: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition text NOT NULL,
  cid int(10) unsigned default '0',
  object varchar(15' at line 4

This is the code on that line.

CREATE TABLE subscription_subscriptions (
  sid int(3) unsigned NOT NULL default '0',
  uid int(10) unsigned NOT NULL default '0',
  condition text NOT NULL,
  cid int(10) unsigned default '0',
  object varchar(15) NOT NULL default '',
  PRIMARY KEY  (sid)
) TYPE=MyISAM;

Could any one help me what should I do?
thanks.

⋅ Categories: Drupal 4.6.x

Comments

mdixoncm’s picture

mdixoncm commented

Mysql 5 introduced some new reserved words - such as "condition", which is clashing with one of the field names in that table. I'm afraid I dont know enough about the module that table relates to, but I would imagine that an updated version is available with that field name modified to work with Mysql5.

Cheers,

Mike

Like books? Check out booktribes the new (Drupal based) community for book lovers
from Computerminds

Mike,
Computerminds offer Drupal development, consulting and training

webmestre@coll-vallcarca.net’s picture

webmestre@coll-vallcarca.net commented

Yes, The solution I applied was executing the myslq server with the user and password. Once inside , I used the source instruction, and the database was builded rightly. I don't understand what is the difference between doing :

#mysql --user=root -p database < db.sql

and:

#mysql --user -p
mysql> use database;
mysql>source ./db.sql
mysql>quit

but it ran. Thanks for your help.

http://www.coll-vallcarca.net
Hosting at: http://unraco.net

offix’s picture

offix commented

im getting the same error here for
WHERE user='root';

i dont understand what should i do to fix this
helpfull tip will be very appriciated