Thanks for your reply. Bad news, it doesn't work :( Clearing the objectcache didn't change anything to the problem.
Setting wgDBmysql5 to true fails with a syntax error.
I debugged and see error here : SQL: SELECT /* Parser::replaceLinkHolders */ page_id, page_namespace, page_title FROM `wiki_page` WHERE (page_namespace=0 AND page_title IN('CatÃÂ(c)gorie:Baglama', 'CatÃÂ(c)gorie:Balalaïka', 'CatÃÂ(c)gorie:Bandoura', ... , 'CatÃÂ(c)gorie:Rythme', 'CatÃÂ(c)gorie:Cuisine', 'CatÃÂ(c)gorie:St SQL ERROR: Illegal mix of collations for operation ' IN ' (<mysql host>)
I checked collation of wiki_page table. Collation = latin1_general_ci except for the 2 fields page_title and page_touched where it is latin_bin.
Just a few queries after, I get :
SQL: SELECT /* MediaWikiBagOStuff::_doquery */ value,exptime FROM `wiki_objectcache` WHERE keyname='tousauxbalkans:messages:Outils' ** no caching ** WARNING: Abrupt exit in /home/.../includes/GlobalFunctions.php at line 579 WARNING: Abrupt exit in /home/.../includes/OutputPage.php at line 798 WARNING: Abrupt exit in /home/.../includes/Database.php at line 476 WARNING: Abrupt exit in /home/.../includes/Database.php at line 419 WARNING: Abrupt exit in /home/.../includes/Parser.php at line 3677 WARNING: Abrupt exit in /home/.../includes/Parser.php at line 238 WARNING: Abrupt exit in /home/.../includes/OutputPage.php at line 314 WARNING: Abrupt exit in /home/.../includes/Article.php at line 905 WARNING: Abrupt exit in /home/.../includes/Wiki.php at line 326 WARNING: Abrupt exit in /home/.../includes/Wiki.php at line 50 WARNING: Abrupt exit in /home/.../index.php at line 127
2006/4/14, Brion Vibber brion@pobox.com:
iubito wrote: [snip]
How do you explain that ? Which table(s) I must look better to compare in what they are different
?
Does the experimental new support of UTF8 should solve this ? (I kept
the
compatible UTF8)
I'm not 100% sure this will help, but try:
Try:
- Add to LocalSettings.php:
$wgDBmysql5 = true;
- Clear the cache in database:
TRUNCATE TABLE objectcache;
Happy Easter everybody ! :-)
-- Sylvain Machefert