Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
ibProArcade SQL Database Error Details »»
ibProArcade SQL Database Error
Version: , by Chris583 Chris583 is offline
Developer Last Online: Jan 2012 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 05-22-2008 Last Update: Never Installs: 0
 
No support by the author.

mySQL query error: UPDATE tournaments SET champion='Good Ol' Ramos' WHERE tid='1' LIMIT 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 'Ramos' WHERE tid='1' LIMIT 1' at line 1
mySQL error code:
Date: Thursday 22nd 2008f May 2008 04:22:51 PM

was working fine on my vb 3.7 boards. Many people using it, many highscores, etc. Today no one can use it anymore and there i that SQL error.

Any idea what caused this and how to fix it?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 06-15-2008, 03:50 PM
nhlnut nhlnut is offline
 
Join Date: Feb 2007
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm getting this SQL error when trying to update an Arcade setting in the ACP.

Code:
mySQL query error: UPDATE games_settings SET arcade_status='1',arcade_language='en',g_display_sort='position',g_display_order='ASC',scores_amount='10',score_type='top',log='0',skin='0',use_cats='1',crown_type='2',notification='pm',show_new='1',show_new_frame='86400',show_active='a:7:{s:5:\"glist\";s:1:\"0\";s:4:\"play\";s:1:\"0\";s:8:\"newscore\";s:1:\"0\";s:5:\"stats\";s:1:\"0\";s:15:\"viewtournaments\";s:1:\"0\";s:11:\"playtourney\";s:1:\"0\";s:11:\"viewtourney\";s:1:\"0\";}',auto_prune='0',auto_prune_time='0',auto_prune_time2='3600',games_pr='4',games_pp='40',user_choices='5,10,15,20,25',allow_user_skin='0',def_cat='1',cats_per_tr='4',show_crowns='1',show_t_won='1',score_sep=',',dec_amount='0',league_scores='10,9,8,7,6,5,4,3,2,1,0',use_announce='0',announcement='',announcement_parsed='',games_new='15',games_popular='15',scoretimeout='1'

mySQL error: Unknown column 'scoretimeout' in 'field list'
mySQL error code: 
Date: Saturday 14th 2008f June 2008 04:24:30 PM
Recently upgraded to the latest version of the Arcade. No problems prior to the upgrade. Any suggestions?
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


All times are GMT. The time now is 01:13 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03682 seconds
  • Memory Usage 2,195KB
  • Queries Executed 17 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (1)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete