The Arcive of Official vBulletin Modifications Site.

[HELP] High Scores causes Database Error · **Released**: 06-29-2009

Hello,

I've been having the following issue with the arcade.

Quote:

I installed the arcade and checked that it was working, it was, I then ran the converter and uninstalled v3arcade. I then deleted the v3arcade files.

I now get this error when accessing the arcade:
Note: User 1824 was the current arcade champion.

Quote:

mySQL query error: SELECT user.userid, user.avatarid, user.avatarrevision, avatar.avatarpath, customavatar.filename, NOT ISNULL(filedata) AS hascustom, customavatar.dateline FROM (SELECT * FROM dbuser WHERE userid=1824) AS user LEFT JOIN dbavatar AS avatar ON avatar.avatarid = user.avatarid LEFT JOIN dbcustomavatar AS customavatar ON customavatar.userid = user.userid WHERE customavatar.userid=1824 OR user.userid=1824

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 'SELECT * FROM dbuser WHERE userid=1824) AS user LEFT JOIN dbava
mySQL error code:
Date: Friday 26th of June 2009 01:25:08 PM

Update:
I wasn't able to find a workaround for this unfortunately, so I have uninstalled everything and started over.
Installed v3, installed v3 games, installed ibpro, converted games to ibpro.
Being no scores, there was no issue this time.

However there is now the same error when scores are added, not sure where i've gone wrong here.

Vbulletin 3.8.0
V3arcade 1.1.1

Any help would be greatly appreciated as I can't seem to figure out whats causing the database error to appear once high scores have been registered.
Also, when I access different parts of the arcade it still works, however accesing the forumhome/arcade.php page the error occurs.

MrZeropage · #2 07-05-2009, 07:03 AM

I think your mySQL-Version is <4.1 ?

I already did a better solution for this for ibProArcade v2.6.9+ please contact me via PM and let me know where to send the updated php-file via mail ...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03558 seconds Memory Usage 2,200KB Queries Executed 15 (?)
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 (2)bbcode_quote (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_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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!