![]() |
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: |
It seems that the upgrade has caused the table collations to reset, you should change them back to whichever one you had.
|
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? |
Yes, they should be consistent across the database.
|
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?
|
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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|