Ekopedia:Major database issue on French SQL database

Un article de Ékopédia, l'encyclopédie pratique.
Aller à : navigation, rechercher

Québec, January 28, 2009

The Ekopedia Project needs your help!

We have a critical issue on the french database (http://fr.ekopedia.org) and despite the fact that this problem does not disturb the normal operation of the service, this issue is major as it lead to an unstable database and backups. In other words, we could lose all the knowledge (about 10 000 pages) set up since 6 years.

Why you should help

Every day, this is more than 10 000 people that get, with Ekopedia, solutions to build a better world. Without Ekopedia, every year, millions of people have no access to that knowledge and solutions.

How to help

To understand the problem


Ekopedia.org Project was created in 2002 and run Mediawiki application since 2004. Ekopedia.org consist of 8 websites (1 for each language + 1 common website for images).


  • If you make an edit and add a character like "φ", during the save, there is a conversion that silently (corrupt) turn it into literal question marks (?).
  • It's possible to detect the issue when trying to add some Mediawiki extensions (like TeX). Error message: "Illegal mix of collations".

The cause

Probably during a Mediawiki upgrade, the sysadmin (me) made a really really bad choice ($wgDBmysql5 = true;).

Who can solve the problem

How to fix it

Thanks, --jluc 28 janvier 2009 à 13:55 (EST)