troubles creating table... troubles creating table...
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Main Menu

troubles creating table...

Started by mlrocks1, November 06, 2005, 09:47:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

mlrocks1

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

Nibbler

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