forum.coppermine-gallery.net

Support => Older/other versions => cpg1.3.x Support => Topic started by: mlrocks1 on November 06, 2005, 09:47:52 pm

Title: troubles creating table...
Post by: mlrocks1 on November 06, 2005, 09:47:52 pm

Hey! im having troubles to create de usersonline table!

can u help me?

CREATE TABLE cpg133_online (
  user_id int(11) NOT NULL default \\\'0\\\',
  user_ip tinytext NOT NULL,
  last_action datetime default NULL,
  PRIMARY KEY  (user_id,user_ip(15))
) TYPE=MyISAM;

MySQL said:


You have an error in your SQL syntax near '\\\'0\\\',
  user_ip tinytext NOT NULL,
  last_action datetime default NULL,
' at line 2

Title: Re: troubles creating table...
Post by: Nibbler on November 06, 2005, 10:07:51 pm

Remove all those backslashes. Questions about a mod belong on the thread dealing with that mod.