Writings Photos Code Contact Resume
This is how you can fix your utf8 b0rked drupal database.

You are here

Submitted by msameer on Tue, 29/08/2006 - 7:21pm

The problem:

You are on a shared hosting. Your host upgrades MySQL. Your drupal 4.7 installation is boom broken!

The reason:

Drupal 4.7 sets the database connection to utf8 if you are running MySQL 4.1+
When you upgrade drupal from 4.6 to 4.7 and you are using MySQL 4.1+, drupal will convert the tables to utf8. But it won't if you are running MySQL 4.0.
Your host upgrades MySQL from 4.0 to 4.1+ and drupal will start setting the connection to utf8 BUT MySQL "knows" that the tables are in latin1 encoding. He doesnt know that the data is really utf8 but the tables are latin1. It'll convert the data from latin1 to utf8 and send it to drupal. You'll end up with a broken website due to the double utf8 conversion.

The solution:

Use his script to convert the tables to utf8.

The instructions are near the top.

Comments

Submitted by shaimaa on Wed, 30/08/2006 - 10:46pm

محمد مينفعش تنزل بالترجمه العربي بقي يمكن افهم حاجه
:(

Submitted by msameer on Fri, 01/09/2006 - 1:55pm

المشكله مش موضوع الترجمه

المشكله ان حتى بالترجمه فيه ناس كتير مش هاتفهم مش علشان هم مابيفهموش او لان انا بافههم اكتر منهم

على اى حال هاحاول اشرح:

الموضوع ببساطه هى ان لما مستضيف الموقع اللى مشغل دروبال يقوم بعمل ترقية لبرنامج قواعد البيانات MySQL الذى تعتمد عليه دروبال ما 4.x الى 4.1 و تكون انت تستخدم دروبال 4.7 العربى هايبوظ

و انا باعت سكربت php بيحل المشكله دى

لو عايزه شرح مفصل اكتر اوليلى

Submitted by Ted Carroll (not verified) on Fri, 09/02/2007 - 7:41pm

I used to have lots of problems with Drupal 4.7. Buggy PIECE OF SH...

Submitted by msameer on Fri, 09/02/2007 - 9:44pm

I've been using 4.7 and it's absolutely fine with me.

It's been used for developing websites and internal portals by the company I work for and it wasn't bad at all.

Submitted by IRC (not verified) on Fri, 09/02/2007 - 11:49pm

ya 3am el 7ag 3abarny, bokra 2eh el nezam, law sa7y edeeny missed we akalemak

Add new comment

Subscribe to /  digg  bookmark