The 2026 Drupal Business Survey is open. Your response will help shape the future of the Drupal business ecosystem.
By nawaaz_ahmed on
Hi Folks - I tried to upgrade my site to 5 RC 1 and I ran into some problems. I use subdomain forwarding on my site, so I installed drupal5rc1 as a sub-directory, copied over settings.php from my drupal473 installation, logged into my old drupal site as administrator, set the theme to bluemarine, disabled all the additional modules I had installed, then configured my subdomain to point to the new directory and ran update.php.
I now see the following message when I access my site
user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'bluemarine' AND b.status = 1 AND (r.rid IN (2) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /drupal5rc1/includes/database.mysql.inc on line 167.
The page displays with all the content except for the left block menus and this message at the top of the page.
What am I doing wrong?
Any help would be greatly appreciated.
Thanks!
Nawaaz
Comments
Re: Upgrading problems from 4.7.3 to 5 RC 1
I used phpMyAdmin to convert all collations to utf8_general_ci on my drupal database. But the website still shows the error message.
user warning: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta WHERE b.theme = 'bluemarine' AND b.status = 1 AND (r.rid IN (1) OR r.rid IS NULL) ORDER BY b.region, b.weight, b.module in /drupal5rc1/includes/database.mysql.inc on line 167.
Frpm phpMyAdmin
blocks 65 MyISAM utf8_general_ci 2.9 KB -
blocks_roles 0 MyISAM utf8_general_ci 1.0 KB
Is it possible it has cached the previous results?
Thanks!
Nawaaz
Re: Upgrading problems from 4.7.3 to 5 RC 1
Turns out all the columns of my tables had the collation set to utf8_unicode_ci and changing the collation for the table and database only changes the defaults for newly created columns and tables and not for existing ones.
I manually upgraded all my collations (for all columns). I guess I could have done it via php and sql (similar to the update_convert_table_utf8 function in update.php) but I did not trust my php/sql skills yet to do that.
It would be nice if there are utilities to do these kinds of maintainence tasks.