Reply
 
Thread Tools
Old 24-08-2008, 12:40 PM   #1   [permalink]
bmn
Junior Member
 
Join Date: 3 Jun 2006
Posts: 7
Help - Error #1064- You have an error in your SQL syntax

Hi

Spec :
MySql 4.1 (I run this query on 5.x as well)
I am using Wamp on my own computer

I tried to run this query :
Code:
CREATE TABLE `phpbb_mps` (
`mps_id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`page_title` VARCHAR( 150 ) NOT NULL ,
`about` TEXT NOT NULL ,
`meet` TEXT NOT NULL ,
`self_title` VARCHAR( 255 ) NOT NULL ,
`sex` TINYINT( 1 ) NOT NULL ,
`mps_quiz_results` TEXT NOT NULL ,
`song` TEXT NOT NULL ,
`video` TEXT NOT NULL ,
`music_code` TEXT NOT NULL ,
`music_auto_start` TINYINT( 2 ) NOT NULL ,
`mps_views` INT( 11 ) NOT NULL DEFAULT '0' ,
`mps_home_page` TINYINT( 1 ) NOT NULL DEFAULT '0' ,
`myspace_url` VARCHAR( 50 ) NOT NULL ,
`mps_comments_display` TINYINT( 2 ) NOT NULL DEFAULT '10' ,
`mps_friends_display` TINYINT( 2 ) NOT NULL DEFAULT '8' ,
`private_profile` TINYINT( 1 ) NOT NULL DEFAULT '0' ,
`mps_report_profile` TINYINT( 1 ) NOT NULL DEFAULT '0' ,
`mps_profile_warnings` TINYINT( 4 ) NOT NULL DEFAULT '0' ,
`mps_short_comment_length` INT( 3 ) NOT NULL DEFAULT '150' ,
`header_option` INT( 2 ) NOT NULL DEFAULT '0' ,
  KEY  (`myspace_url`),
PRIMARY KEY ( `mps_id` )
then I would get this message error :
#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 '' at line 24

Could you help me?
thanks
bmn is offline   Reply With Quote
Old 15-09-2008, 04:10 AM   #2   [permalink]
DraniX
Forum Master
 
DraniX's Avatar
 
Join Date: 20 Apr 2001
Location: Destromath
Posts: 2,872
And together, combined, a synergic gestalt emerges.
__________________
"It has testicles, you know."
"It could scarcely do without them."
"And what I can only describe as a very small vagina."
"Disgusting."
DraniX is offline   Reply With Quote
Old 12-11-2008, 09:04 AM   #3   [permalink]
DraniX
Forum Master
 
DraniX's Avatar
 
Join Date: 20 Apr 2001
Location: Destromath
Posts: 2,872
Life isn't... like this...
__________________
"It has testicles, you know."
"It could scarcely do without them."
"And what I can only describe as a very small vagina."
"Disgusting."
DraniX is offline   Reply With Quote
Old 15-01-2009, 07:04 PM   #4   [permalink]
sniW
Junior Member
 
Join Date: 7 Jan 2009
Posts: 7
I was having this problem a few hours ago, and I finally realized it was because I was using one of MySQL's reserved words. Check this:
http://dev.mysql.com/doc/refman/5.1/...ved-words.html
sniW is offline   Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


New To Site? Need Help?

All times are GMT -4. The time now is 07:21 AM.


Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2018, vBulletin Solutions, Inc.