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

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

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.