Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > Premium Archives > ibProArcade Archive
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
MySQL Database Error. Please Help Details »»
MySQL Database Error. Please Help
Version: , by adamskiii adamskiii is offline
Developer Last Online: Feb 2013 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 03-07-2009 Last Update: Never Installs: 0
 
No support by the author.

I have installed the mod successfully on my forum v3.8.1 but once I enable it and then view a thread on my board I get this MySQL error:

Code:
Invalid SQL:

			SELECT t.champion, u.userid FROM tournaments AS t
			LEFT JOIN user AS u ON (t.champion = u.username)
			WHERE champion<>'';

MySQL Error   : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Saturday, March 7th 2009 @ 05:10:14 PM
Error Date    : Saturday, March 7th 2009 @ 05:10:14 PM
Script        : http://www.**********/showthread.php?t=9080
Referrer      : http://www.*********/forumdisplay.php?f=6
IP Address    : **.***.**.**
Username      : ********
Classname     : vB_Database
MySQL Version : 5.0.67-community
Do I need to perform the template edits that are in the Installation.txt file as well? This is my first time installing arcade. Please help

thank you

Show Your Support

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

Comments
  #2  
Old 03-07-2009, 05:09 PM
Gemma's Avatar
Gemma Gemma is offline
 
Join Date: Apr 2004
Location: Scotland
Posts: 1,229
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

https://vborg.vbsupport.ru/showthread.php?t=186628

See if that thread helps you
Reply With Quote
  #3  
Old 03-07-2009, 06:26 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Gemma View Post
Only 3 fields say latin1_general_ci in the Collation part, but when I go to the operations tab and change it it already has it selected but its not showing up under Collation. Is there anything wrong?

thanks

--------------- Added [DATE]1236470269[/DATE] at [TIME]1236470269[/TIME] ---------------

here are some pictures of what I am talking about:


-------------------------------------------------------------------------------------------------
Reply With Quote
  #4  
Old 03-09-2009, 08:19 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

can anyone please help me fix this??
Reply With Quote
  #5  
Old 03-31-2009, 02:02 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

can no one help me with this problem??
Reply With Quote
  #6  
Old 03-31-2009, 06:58 PM
Gemma's Avatar
Gemma Gemma is offline
 
Join Date: Apr 2004
Location: Scotland
Posts: 1,229
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can't you changed the collation to latin1_swedish_ci?
Reply With Quote
  #7  
Old 03-31-2009, 11:33 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I change it but nothing happens. still the same error. It constantly says this and does not change no matter what I change it to.



If I change it to latin1_swedish_ci then the bottom Row Statistics will say latin1_swedish_ci in the collation but it will always say latin1_general_ci in those three spots in the picture, no matter what it is
Reply With Quote
  #8  
Old 04-06-2009, 08:45 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

come on. No answer??
Reply With Quote
  #9  
Old 04-21-2009, 07:29 PM
adamskiii adamskiii is offline
 
Join Date: Oct 2008
Posts: 98
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

nobody knows why?
Reply With Quote
Reply


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 02:42 AM.


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.04396 seconds
  • Memory Usage 2,270KB
  • Queries Executed 24 (?)
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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (8)postbit
  • (9)postbit_onlinestatus
  • (9)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