vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Arcade Problem (https://vborg.vbsupport.ru/showthread.php?t=76713)

atrljoe 02-20-2005 10:52 PM

Arcade Problem
 
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/a...=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:
[sql]UPDATE user SET uttpoints=uttpoints+25 WHERE userid='1'[/sql]

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.


All times are GMT. The time now is 01:47 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01082 seconds
  • Memory Usage 1,718KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete