This is the first time I got any error when loading a table (I use phpMyAdmin). I tried it twice - this is the error I get:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 1
STR: //
SQL: // $Id: im.mysql,v 1.1 2004/07/16 15:32:05 killes Exp $
CREATE TABLE im (
mid int(10) unsigned NOT NULL auto_increment,
sid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
message varchar(255) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
key (mid)
) TYPE=MyISAM

SQL-query:

// $Id: im.mysql,v 1.1 2004/07/16 15:32:05 killes Exp $ CREATE TABLE im ( mid int(10) unsigned NOT NULL auto_increment, sid int(10) unsigned NOT NULL default '0', rid int(10) unsigned NOT NULL default '0', message varchar(255) NOT NULL default '', timestamp int(11) NOT NULL default '0', key (mid) ) TYPE=MyISAM

MySQL said:
#1064 - You have an error in your SQL syntax near '// $Id: im.mysql,v 1.1 2004/07/16 15:32:05 killes Exp $
CREATE TABLE im (
  mid ' at line 1

Comments

Anonymous’s picture

I too have this error,
#mysql -u nobody -p drupal < im.mysql
Enter password:
ERROR 1064 at line 1: You have an error in your SQL syntax near '// $Id: im.mysql,v 1.1 2004/07/16 15:32:05 killes Exp $
CREATE TABLE im (
mid ' at line 1

# cat im.mysql
// $Id: im.mysql,v 1.1 2004/07/16 15:32:05 killes Exp $
CREATE TABLE im (
mid int(10) unsigned NOT NULL auto_increment,
sid int(10) unsigned NOT NULL default '0',
rid int(10) unsigned NOT NULL default '0',
message varchar(255) NOT NULL default '',
timestamp int(11) NOT NULL default '0',
key (mid)
) TYPE=MyISAM;

I'm using drupal 4.5.2
Hoping too get this resolved, it sound like a great module
Thanks
Tom

asimmonds’s picture

Remove the line that starts with '//', it's a invalid comment in SQL

Anonymous’s picture

Fixed. Gerhard

Anonymous’s picture