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
Comment #1
(not verified) commentedI 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
Comment #2
asimmonds commentedRemove the line that starts with '//', it's a invalid comment in SQL
Comment #3
(not verified) commentedFixed. Gerhard
Comment #4
(not verified) commented