Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

Does not work after upgrade Joomla v3.5.0
(1 viewing) (1) Guest
Support forum for users using free edition of Book it!. These forums are for mutual help among users.

NOTE: Due to our capacity limitations, ARTIO does not monitor this forum category regularly. If you want direct support from ARTIO, please start a ticket at Support Dashboard. If you have no support ticket available, you need to purchase it. .
  • Page:
  • 1

TOPIC: Does not work after upgrade Joomla v3.5.0

Does not work after upgrade Joomla v3.5.0 8 years, 6 months ago #47504

I get error:

1267 - Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT element FROM #__extensions AS e LEFT JOIN #__booking_payment AS p ON e.element = p.alias WHERE folder = 'bookingpayment' AND p.id IS NULL
The topic has been locked.

Re: Does not work after upgrade Joomla v3.5.0 8 years, 5 months ago #47515

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
Last Edit: 8 years, 5 months ago by MelsonMarketing.
The topic has been locked.

Re: Does not work after upgrade Joomla v3.5.0 8 years, 5 months ago #47516

  • mitk
Hello,

this problem has been already fixed and the version 2.3.8 is redeployed. Please make a reinstall to get the fix. Open Booking - Control Panel - Configuration - Check Updates and select the button Reinstall. Such reinstalling does not delete any data or configuration.
The topic has been locked.
  • Page:
  • 1
User Login Empty