vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   problem with admin index file (https://vborg.vbsupport.ru/showthread.php?t=155553)

Ninth Dimension 08-18-2007 09:48 AM
problem with admin index file
 
Hi. I've just upgraded my forum from 3.5.3 to 3.6.8, it all appears to have worked as it should, but when I log into the admin section, the main panel on the right shows the following error message

Code:
Database error in vBulletin 3.6.8:

Invalid SQL:

        SELECT adminmessage.adminmessageid
        FROM vb3_adminmessage AS adminmessage
        INNER JOIN vb3_adminlog AS adminlog ON (adminlog.script = adminmessage.script AND adminlog.action = adminmessage.action)
        WHERE adminmessage.status = 'undone'
                AND adminmessage.script <> ''
                AND adminlog.dateline > adminmessage.dateline
        GROUP BY adminmessage.adminmessageid;

MySQL Error  : Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date        : Saturday, August 18th 2007 @ 11:45:53 AM
Script      : http://arathor.net/admincp/index.php?do=home
Referrer    : http://arathor.net/admincp/index.php?do=nav
IP Address  : 86.134.211.171
Username    : Deus
Classname    : vb_database
Does anyone have any ideas on how to fix this? Thank you :)

Dismounted 08-18-2007 09:51 AM
It seems that the upgrade has caused the table collations to reset, you should change them back to whichever one you had.

Ninth Dimension 08-18-2007 09:56 AM
I've noticed that most of the tables are set to latin1_general_ci, with a few here and there set to latin1_swedish_ci. Does it matter which they are?

I went into the one set to swedish and set all the fields within it to swedish (they were general before), and it seems to have fixed the problem, but as above, should they all be the same, all across the board?

Dismounted 08-18-2007 10:02 AM
Yes, they should be consistent across the database.

Ninth Dimension 08-18-2007 10:15 AM
Damn... Looks like I've got my work cut out for me changing them all then... I don't supose there is a quick and easy way of doing it automatically is there?

Marco van Herwaarden 08-18-2007 01:12 PM
1 Attachment(s)
You can use the attached file to ensure that all collations are the same. Upload to AdminCP and point your browser to the script.

Make sure to have a good backup before changing anything!!!!!

PS The reason you have different collations is probably that you moved servers at some time or upgrade MySQL. vBulletin always creates tables using the default collation as set in MySQL config.


All times are GMT. The time now is 12:45 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.01046 seconds
  • Memory Usage 1,717KB
  • 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
  • (6)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