I had the same problem.
But after changing the collations in the database all is working again.
It would be too hard to change all the tables manually - so use this script:
- Create a Php file with the following content and name it f.e. "change.php"
- Upload it via ftp to your Joomla-root
- Call it via your browser (
www.yourdomain.com/change.php)
- Wait for success-message and you're done!
<?php
$conn1=new MySQLi("localhost","User","Passwort","Datenbank");
if($conn1->connect_errno){
echo mysqli_connect_error();
exit;
}
$res=$conn1->query("show tables") or die($conn1->error); while($tables=$res->fetch_array()){
$conn1->query("ALTER TABLE $tables[0] CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci") or die($conn1->error); } echo "The collation of your database has been successfully changed!";
$res->free();
$conn1->close();
?>
Regards
Michael
