Author: Michael.W.Dietrich
Description:
When running "php SMW_refreshData.php -v" whilst upgrading from 0.7.x (version from svn) after some pages have been processed properly I get the following error message and processing stops.
(116) Processing page with ID 1393 ...
Es gab einen Syntaxfehler in der Datenbankabfrage.
Die letzte Datenbankabfrage lautete: „ SELECT DISTINCT m3WDBpage.page_title as title, m3WDBpage.page_namespace as namespace, m3WDBpage.page_id as id FROM prop9, m3WDBpage INNER JOIN m3WDBsmw_relations AS rel8 ON rel8.subject_id=m3WDBpage.page_id LEFT JOIN m3WDBredirect AS rd10 ON rd10.rd_from=rel8.object_id WHERE ((m3WDBpage.page_namespace='0') OR (m3WDBpage.page_namespace='6')) AND (prop9.title=rel8.relation_title AND ((rel8.object_title='Msg' AND rel8.object_namespace=0) OR (rd10.rd_title='Msg' AND rd10.rd_namespace=0))) ORDER BY m3WDBpage.page_title ASC LIMIT 51 “ aus der Funktion „<tt>SMW::getQueryResult</tt>“.
MySQL meldete den Fehler: „<tt>1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for
operation '=' (localhost)</tt>“.
If this can't be fixed I've to step back to a bakup version of the database and to 0.7.
As I'm aware, that the german language version of SMW is Not used to often i doubt that this bug will be critical to users of other language versions but german.
Version: unspecified
Severity: critical
OS: Linux
Platform: PC
URL: http://www.self-qs.de