Welcome to Geeklog, Anonymous Friday, March 29 2024 @ 03:23 am EDT

Geeklog Forums

#1064 - You have an error in your SQL syntax


Losille

Anonymous
I am getting this message. There is an x beside "added int".Could someone help me?
Error

SQL query:

------------------------------------------- --
--
-- Table structure for table `xtrm_adds`
--
CREATE TABLE IF NOT EXISTS `xtrm_adds` (
`id` int( 10 ) NOT NULL AUTO_INCREMENT ,
`fid` int( 15 ) default NULL ,
`added` int( 15 ) default NULL ,
PRIMARY KEY ( `id` ) ,
KEY `fid` ( `fid` )
) TYPE = MYISAM AUTO_INCREMENT =2058469;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '---------------------------------------------

--
-- Table structure for table `' at line 1
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
What are you trying to do? And does this have anything to do with Geeklog?

At a guess, I'd say you are trying to import an SQL dump. Lines starting with -- (two dashes) are comments, but you seem to have one long line of dashes there. Something's wrong with that SQL dump file, but you can probably fix it by removing all such lines.

bye, Dirk
 Quote

All times are EDT. The time is now 03:23 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content