The Arcive of Official vBulletin Modifications Site.

Special Charechter Bug is Back?? · **Released**: 04-01-2007

Yesterday I moved my forums from public_html being the vbroot to /forums being the vbroot. The arcade was working fine. Now I seem to have a db error and it seems to be because of the special characters bug as far as I can see.

Quote:

mySQL query error: UPDATE tournaments SET champion='Rhymin' Greiman' WHERE tid='8' 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 'Greiman' WHERE tid='8' LIMIT 1' at line 1
mySQL error code:
Date: Sunday 01st of April 2007 05:57:30 PM

MrZeropage · #2 04-01-2007, 07:26 PM

which version of ibProArcade are you using ?

Did this player won any tournament before ?

Xplorer4x4 · #3 04-01-2007, 08:18 PM

2.6.1

Yes he has. He won it along time ago on 03-11-2007. The bug did not arise until moving my forums. However my index.php script is now the vb default index.php. I moves my vbadvanced portal to the index.php file of public_html, but why would that possibly be a problem? :S

Oh and the username in question had a ' in it, so i removed this and now the arcade is accessible.

MrZeropage · #4 04-02-2007, 06:12 AM

so before you had the index.php from the portal and manually added the code for the arcade to it, and it was working ?

Maybe check your PlugIn "ibProArcade: Integration in index.php" if this has actual content.

If not, I really have to investigate as I can't find any place in the code where the problem is not solved

If you want, you can provide AdminCP+FTP access via PM and I will try a direct search&fix

Xplorer4x4 · #5 04-06-2007, 05:56 PM

Ok never mind the vbadvanced issues for the time being but i can confirm that the special characters bug is still appearing in 2.6.1. A forum I work on had 2.5.9 installed and was receiving the special recharter error. I upgraded them to 2.6.1 and this did not fix the problem. The MySQL error remains the same.

PHP Code:


			
mySQL query error: UPDATE tournaments SET champion='casey's_angel27' WHERE tid='13' 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 's_angel27' WHERE tid='13' LIMIT 1' at line 1
mySQL error code: 
Date: Saturday 07th 2007f April 2007 04:51:37 AM

EDIT: Hmm i wonder if vbadvanced is conflicting. On both set ups the portal is in the public_html and and the forums are in public_html/forums. My arcade was working fine until after the vbadvanced install. I did not notice the bug straight after vbadvanced install but vBadvanced and vBookie are the only hacks both sites have in common.

I seem to have found a fix on one forum but not the other. I installed vBPlaza and the IPBArcade add on for vbPlaza and it fixed it on one site. However on the other site the IPB Add on for the Plaza is already installed.

Xplorer4x4 · #6 04-10-2007, 07:07 PM

Any ideas Zero?

MrZeropage · #7 04-11-2007, 07:48 AM

Still have to verify this, will come back here and let you know...

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05429 seconds Memory Usage 2,256KB Queries Executed 22 (?)
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_php (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 (7)post_thanks_box (7)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (7)post_thanks_postbit_info (6)postbit (7)postbit_onlinestatus (7)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
Messages:

The Arcive of Official vBulletin Modifications Site.

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