vb.org Archive - SQL error browsing posts after install

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- ibProArcade Archive (https://vborg.vbsupport.ru/forumdisplay.php?f=174)

- - SQL error browsing posts after install (https://vborg.vbsupport.ru/showthread.php?t=234965)

JonnyThunder

02-04-2010 07:25 AM

SQL error browsing posts after install

Hello,

I'm running VB 4.01 with no mods. When I install the arcade as per instructions, I get the following SQL error when I try to view any thread....

Code:

Database error in vBulletin 4.0.1:



Invalid SQL:



                        SELECT t.champion, u.userid FROM vb_tournaments AS t

                        LEFT JOIN vb_user AS u ON (t.champion = u.username)

                        WHERE champion<>'';



MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='

Error Number  : 1267

Request Date  : Thursday, February 4th 2010 @ 09:23:20 AM

Error Date    : Thursday, February 4th 2010 @ 09:23:20 AM

Classname     : vB_Database

MySQL Version : 5.0.85-community

Is anyone else getting this? The only way I can stop it happening is to uninstall the arcade software.

Digital Jedi

02-04-2010 09:35 PM

I'm not too familiar with this kind of error, but see if you can glean anything form this thread. Could be a MySQL issue, or could just be something unique to your installation: http://www.vbulletin.com/forum/showt...searching-FAQs

JonnyThunder

02-05-2010 07:58 AM

Thanks for that - it put me on the right track. For those of you having a similar issue, this was the quickest and easiest way I found to fix the issue.....

1. Log on to your PHPMyAdmin panel and find out what your VB database tables have as their Collation.

2. Go to Operations tab and change the default Collation to match the ones your tables have (from above)

3. UNINSTALL the arcade software

4. REINSTALL the arcade software. This will recreate all the tables with the new default Collation and should fix the problem.

Peace out homeys,

JT

All times are GMT. The time now is 10:51 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01681 seconds Memory Usage 1,711KB 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)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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
Messages: