Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
Reload this Page SQL error - arcade down
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools
SQL error - arcade down Details »»
SQL error - arcade down
MOD Information
The Developer
 
Version: , by tpn87 tpn87 is offline
Developer Last Online: Apr 2014 Show Printable Version Email this Page
Version: Unknown Rating:
Released: 09-07-2007 Last Update: Never Installs: 0
 
No support by the author.

Suddenly when accessing my arcade tonight, users get the following error:

Quote:
mySQL query error: SELECT userid FROM user WHERE username='daddy's girl 132'

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 's girl 132'' at line 1
mySQL error code:
Date: Thursday 06th of September 2007 09:54:13 PM
The arcade is dead in the water. Please Help!

Show Your Support

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

Comments
  #2  
Old 09-07-2007, 11:51 AM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
rename the user and remove the special character ' from his name ...

when does this appear ? Are you running ibProArcade v2.6.3+ ?
Reply With Quote
  #3  
Old 09-07-2007, 12:15 PM
tpn87 tpn87 is offline
 
Join Date: May 2006
Location: Boston
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I changed the name but it is still happening. I am running 2.6.3 +a

It appears to everyone when they access arcade.php. The arcade is not operational anymore.

***EDIT: I ended up just uninstalling and reinstalling it to fix.
Reply With Quote
  #4  
Old 09-10-2007, 01:13 PM
MortysTW MortysTW is offline
 
Join Date: Mar 2005
Location: Southern CA, USA
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
If it happens again, try running through the UPDATE process at AdminCP>Arcade>Update User Names.

I'm guessing the "username" was still in the arcade's brain, even though you edited the name via the part of vbulletin "outside" of the arcade.
Reply With Quote
  #5  
Old 09-13-2007, 03:04 PM
stutefc stutefc is offline
 
Join Date: Feb 2004
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I am having the same problem and have updated names etc in admincp of the Arcade section. If I unistall and reinstall will I loose all my games, have over 2000 in it I built up over 3 years...worried man.
Reply With Quote
  #6  
Old 09-13-2007, 03:21 PM
MortysTW MortysTW is offline
 
Join Date: Mar 2005
Location: Southern CA, USA
Posts: 272
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Okay. If you are truely "fearing the loss", go in via FTP and delete all the PHP files ONLY that are within your forums/arcade/ directory. Then reupload the latest and greatest from here. Then run the Product again, making sure you ticked the OVERWRITE EXISTING option.

If that doesn't work, please list out all the mods you have installed on your vbulletin.
Reply With Quote
  #7  
Old 09-13-2007, 03:52 PM
stutefc stutefc is offline
 
Join Date: Feb 2004
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Reinstalled still no joy. Games are still all there.

When I search on the main admincp the main that had the ' in it has gone, but when I search in the Arcade admincp for that name that I changed it just throws up another SQL error, so need something to let the arcade know that member is now removed ... the tools under members has been run to clean it up but no joy. As for mods on my site, lets just say I have nearly most of them installed.
Reply With Quote
  #8  
Old 09-13-2007, 07:12 PM
MrZeropage's Avatar
MrZeropage MrZeropage is offline
 
Join Date: Nov 2003
Location: Munich, Germany
Posts: 3,012
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
provide FTP+AdminCP access via PM and I will fix this ...
Reply With Quote
  #9  
Old 09-14-2007, 12:22 PM
stutefc stutefc is offline
 
Join Date: Feb 2004
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks.
Reply With Quote
  #10  
Old 09-16-2007, 08:26 AM
stutefc stutefc is offline
 
Join Date: Feb 2004
Posts: 50
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Did you get my PM ok, my arcade is still down.

Thanks
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Next Thread »

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 04:19 PM.

Contact Us - Archive - Top

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.04744 seconds
  • Memory Usage 2,288KB
  • Queries Executed 23 (?)
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_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (9)postbit
  • (10)postbit_onlinestatus
  • (10)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
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete