Jump to content

[SOLVED] Fatal Error: You have an error in your SQL syntax


sneamia

Recommended Posts

INSERT INTO `news` (origID, title, summary, fulltext, timestamp, timestamp2, author, ip) VALUES (3, 'title of it', 'summary of it', 'full text of it', 1194919992, 1194919992, 'loladmin', '68.193.xx.xx')

 

Fatal Error: 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 'fulltext, timestamp, timestamp2, author, ip) VALUES (3, 'title of it', 'summary ' at line 1

 

newsID - smallint(6) - auto_increment, primary key

origID - smallint(6)

title - varchar(50)

summary - text

fulltext - mediumtext

timestamp - int(10)

timestamp2 - int(10)

author - varchar(20)

ip - varchar(16)

 

What am I doing wrong?  I hate these cryptic MySQL errors.

fulltext is probably a reserved word in MySQL so enclose that column name in back tick marks i.e. `fulltext` You might just want to do that to all your column names anyway.

 

I stuck the tickmarks in later, but I didn't know about the fulltext part.  Thanks.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.