PDA

View Full Version : Arcade Problem


atrljoe
02-20-2005, 10:52 PM
Can anyone help me this error message any user gets it once the game is completed, when the game is over it wants to load the next page but then this happens any ideas?

Database error in vBulletin 3.0.6:

Invalid SQL: UPDATE user) SET uttpoints)=uttpoints)+25 WHERE userid='1'
mysql 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 ') SET uttpoints)=uttpoints)+25 WHERE userid='1'' at line 1

mysql error number: 1064

Date: Sunday 20th of February 2005 07:49:27 PM
Script: http://www.theURLofmyforums.com/forums/arcade.php
Referer: http://www.theURLofmyforums/forums/arcade.php?do=play&gameid=6
Username: myuser
IP Address: xx.xx.xx.xx

Osterling
02-20-2005, 11:00 PM
this is not the area for support.. please read the title and description for this forum

atrljoe
02-20-2005, 11:09 PM
My mistake, made a mistake thought I was in another forum feel free to move this anyone.

Marco van Herwaarden
02-21-2005, 03:51 AM
Change your query to:
UPDATE user SET uttpoints=uttpoints+25 WHERE userid='1'

I don't know why you put all those ) in there

atrljoe
02-21-2005, 12:57 PM
Found the problem the program was for some reason placing those ) in there, I looked at the settings and for somereason the default values all ended with ) thanks again!

Marco van Herwaarden
02-21-2005, 03:59 PM
What "program" are you using then?

atrljoe
02-21-2005, 10:41 PM
what i meant was the install program place those values into there for some reason, it placed a ) after every value.