Anyone here good at SQL errors?

RickyG · 10-25-2007, 08:22 PM

I have a SQL and I keep getting an error. I dont know the first thing about SQL...

Here is error:
ERROR 1064 (42000) at line 1: 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 ''gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidt' at line 1

Here is the first couple of lines of code
INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (1,101,'f-218.swf','12 Holes of X-Mas',0,1,'f-218.png',525,400,"'Pick your putter and go out to putt a hole in one.Move the ball to where you want it then click,move your mouse according to the arrow then click to shoot the ball, and play all twelve holes'",0,'','',1,0,0,'',''),
INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',1,0,0,'',''),
INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (3,101,'2343.swf','2D Army Swat',0,1,'2343.png',610,465,"'Shoot the drunk terrorists, but watch out for them shooting back.'",0,'','',1,0,0,'',''),

ANY IDEAS???????

ArcadeSiteBuilder · 10-25-2007, 09:03 PM

Rickyg,

it looks like the sql you are using isn't lined up with database you are trying to insert it into. I will be glad to help you. grab my on MSN I will send you pm.

brendgard · 10-25-2007, 09:39 PM

Just a quick glance suggests a couple things.

1) most SQL databases want the queries terminated with a semicolon ( ; ) not a comma ( , ). Yours are terminated by a comma.

2) It's a bit had to read on my screen, but it looks like you have your single and double quotes swapped around for the gDescription field in both the 1st and 3rd insert query. The rest of the time the time the fields are contained in single quotes. Those 2 particulare places the double quotes are outside the singles( " ' description text ' " instead of ' " description text ' " ), and the database probably would choke on that.

Try this way

INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (1,101,'f-218.swf','12 Holes of X-Mas',0,1,'f-218.png',525,400,'Pick your putter and go out to putt a hole in one.Move the ball to where you want it then click,move your mouse according to the arrow then click to shoot the ball, and play all twelve holes',0,'','',1,0,0,'','');
INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',1,0,0,'','');
INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (3,101,'2343.swf','2D Army Swat',0,1,'2343.png',610,465,'Shoot the drunk terrorists, but watch out for them shooting back.',0,'','',1,0,0,'','');

10-25-2007, 08:22 PM	#1 (permalink)
RickyG Moderator Senior Member Join Date: Dec 2006 Location: Under Your Mouse! Posts: 1,208	Anyone here good at SQL errors? I have a SQL and I keep getting an error. I dont know the first thing about SQL... Here is error: ERROR 1064 (42000) at line 1: 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 ''gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidt' at line 1 Here is the first couple of lines of code INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (1,101,'f-218.swf','12 Holes of X-Mas',0,1,'f-218.png',525,400,"'Pick your putter and go out to putt a hole in one.Move the ball to where you want it then click,move your mouse according to the arrow then click to shoot the ball, and play all twelve holes'",0,'','',1,0,0,'',''), INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',1,0,0,'',''), INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (3,101,'2343.swf','2D Army Swat',0,1,'2343.png',610,465,"'Shoot the drunk terrorists, but watch out for them shooting back.'",0,'','',1,0,0,'',''), ANY IDEAS??????? __________________ Arcade Banner Exchange, game packs, top site, arcade script and forum for all of your arcade needs http://www.mibbi.com This site stinks!! www.farting.us Coming soon MibbiJr!

10-25-2007, 09:03 PM	#2 (permalink)
ArcadeSiteBuilder Senior Member Join Date: Oct 2007 Posts: 215	Rickyg, it looks like the sql you are using isn't lined up with database you are trying to insert it into. I will be glad to help you. grab my on MSN I will send you pm. __________________

10-25-2007, 09:39 PM	#3 (permalink)
brendgard Gamer FX Staff Senior Member Join Date: Oct 2006 Posts: 681	Just a quick glance suggests a couple things. 1) most SQL databases want the queries terminated with a semicolon ( ; ) not a comma ( , ). Yours are terminated by a comma. 2) It's a bit had to read on my screen, but it looks like you have your single and double quotes swapped around for the gDescription field in both the 1st and 3rd insert query. The rest of the time the time the fields are contained in single quotes. Those 2 particulare places the double quotes are outside the singles( " ' description text ' " instead of ' " description text ' " ), and the database probably would choke on that. Try this way INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (1,101,'f-218.swf','12 Holes of X-Mas',0,1,'f-218.png',525,400,'Pick your putter and go out to putt a hole in one.Move the ball to where you want it then click,move your mouse according to the arrow then click to shoot the ball, and play all twelve holes',0,'','',1,0,0,'',''); INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (2,101,'1221.swf','12 Many',0,1,'1221.png',480,360,'The screen flashes quickly and it ask you how many stars you seen. Can get quite challenging.',0,'','',1,0,0,'',''); INSERT INTO `games` ('gId', 'gIncategory', 'gSwFile', 'gName', 'gOrder', 'gVisible', 'gThumb', 'gWidth', 'gheight', 'gDescription', 'gplays', 'description2', 'desc2', 'filetype', 'score', 'points', 'comments', 'sender') VALUES (3,101,'2343.swf','2D Army Swat',0,1,'2343.png',610,465,'Shoot the drunk terrorists, but watch out for them shooting back.',0,'','',1,0,0,'',''); __________________ http://gamersgo.com A list of arcade related sites, add yours. http://auntiefondy.com Lists, add your site. http://kbsplace.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Guide to Running a Great Arcade Site.	messa	Webmastering	7	12-31-2008 05:13 AM