error on cerating new thread help please

P

PAKIS-RULEZ

New Member
i am getting this error when i create a new thread

but i send a pm its fine

i disabled all mods,
i have optimized tables,
i have repaired all tables,

please if any one know about this.

Code: 
Database error in vBulletin 3.8.2:

Invalid SQL:

			SELECT prefix.*, prefixpermission.usergroupid AS restriction
			FROM forumprefixset AS forumprefixset
			INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
			INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
			LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
			WHERE forumprefixset.forumid = 2
			ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Sunday, May 31st 2009 @ 06:40:56 PM
Error Date    : Sunday, May 31st 2009 @ 06:40:56 PM
Script
 
Wayne Luke said:
All tables and fields should be the same collation to prevent this error from occuring in the future. It can occur on other queries not just when upgrading if there are mixed collations. When vBulletin creates new tables and fields it will use the default of the database for the collation. This is usually latin1_general_ci unless you change it. You can see instructions on how to change a database's collation settings in the MySQL manual.
Click to expand...
........................
 
The easiest way to fix this is in phpMyAdmin. It lists all the collation settings about the middle of the page. I am guessing that your default is utf8_general_ci. The ones that are not are probably new tables that hacks have installed. Should only be a few. The way I do it is select the table that isn't the same as default, go to the OPERATIONS tab you will see a collation dropdown there, select the default collation and click on GO. Simple as that ...

Hacks that create table are notorious for adding the default collation from the system they came from to the tables they install on the system they are going to ... stupidly!
 
bluescorpion said:
The easiest way to fix this is in phpMyAdmin. It lists all the collation settings about the middle of the page. I am guessing that your default is utf8_general_ci. The ones that are not are probably new tables that hacks have installed. Should only be a few. The way I do it is select the table that isn't the same as default, go to the OPERATIONS tab you will see a collation dropdown there, select the default collation and click on GO. Simple as that ...

Hacks that create table are notorious for adding the default collation from the system they came from to the tables they install on the system they are going to ... stupidly!
Click to expand...

bro i change 28 tables to wat was "latin1_swedish_ci" to "latin1_general_ci"

i am still getting that same error

Code: 
Database error in vBulletin 3.8.2:

Invalid SQL:

			SELECT prefix.*, prefixpermission.usergroupid AS restriction
			FROM forumprefixset AS forumprefixset
			INNER JOIN prefixset AS prefixset ON (prefixset.prefixsetid = forumprefixset.prefixsetid)
			INNER JOIN prefix AS prefix ON (prefix.prefixsetid = prefixset.prefixsetid)
			LEFT JOIN prefixpermission AS prefixpermission ON (prefix.prefixid = prefixpermission.prefixid)
			WHERE forumprefixset.forumid = 2
			ORDER BY prefixset.displayorder, prefix.displayorder;

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
 
You must log in or register to reply here.
Back
Top