Have exact same problems as others here on the forum, after moving to a new server!
I get a lot of error message e-mails like the one below:
I tried the script which was posted for a 3.8.2 and up to 4.2 board, but it can't run with VBulletin 5!
Anyone has a similar script that just work for VB 5? The below is for VB 3.8.2
I get a lot of error message e-mails like the one below:
Code:
Database error in vBulletin 5.1.4: Invalid SQL: SELECT * FROM routenew WHERE `prefix` IN ('forum/general-forums/the-talk-about-everything-lounge/12745-i-donÂ’t-like-your-attitude','forum/general-forums/the-talk-about-everything-lounge','forum/general-forums','forum'); MySQL Error : Illegal mix of collations for operation ' IN ' Error Number : 1271 Request Date : Thursday, January 8th 2015 @ 11:13:08 PM Error Date : Thursday, January 8th 2015 @ 11:13:08 PM Script : [URL="http://forum/forum/general-forums/the-talk-about-everything-lounge/12745-i-donÂ't-like-your-attitude?p=31205"]http:///forum/forum/general-forums/the-talk-about-everything-lounge/12745-i-donÂ’t-like-your-attitude?p=31205[/URL] Referrer : IP Address : 68.180.228.219 Username : Guest Classname : vB_Database_MySQL MySQL Version :
Anyone has a similar script that just work for VB 5? The below is for VB 3.8.2
PHP Code:
<?php // Don't forget to enter your db infos. define('THIS_SCRIPT', 'convert'); require './global.php'; //--------------- header('Content-type: text/plain'); $dbconn = mysql_connect('localhost', 'DB-user', 'DB-pass') or die( mysql_error() ); mysql_select_db("db_name"); $sql = "ALTER DATABASE `DB-Name` DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci"; $result = mysql_query($sql) or die( mysql_error() ); print "Database changed to latin\n"; $sql = 'SHOW TABLES'; $result = mysql_query($sql) or die( mysql_error() ); while ( $row = mysql_fetch_row($result) ) { $table = mysql_real_escape_string($row[0]); $sql = "ALTER TABLE $table DEFAULT CHARACTER SET latin1 COLLATE latin1_general_ci, CONVERT TO CHARACTER SET latin1 COLLATE latin1_general_ci"; mysql_query($sql) or die( mysql_error() ); print "$table changed to latin.\n"; } mysql_close($dbconn); ?>
Comment