Last modified: 2012-08-09 08:50:30 UTC
Since 2012-07-23, when some languages, including British English and Mongolian, are chosen on the left side of the homepage, I have been getting, when typing any word in the "Search" field and pressing "Enter" from the homepage, the following message: "As an anonymous user, you can only add new data. If you would like to also modify existing data, please create an account and indicate your languages on your user page. Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT expression_id, language_id FROM uw_expression WHERE spelling=BINARY 'débit' AND uw_expression.remove_transaction_id IS NULL AND EXISTS (SELECT * FROM uw_syntrans WHERE uw_syntrans.expression_id=uw_expression.expression_id AND uw_syntrans.remove_transaction_id IS NULL ) AND language_id= from within function ‘.’ Database returned error ‘1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (localhost).’ "
Note that the search doesn't work.
Fixed! It happened when getLanguageIdForCode returns a null value in getExpressionsRecordSet, i.e. when there is no correspondance between a MediaWiki language code and a language_id in OmegaWiki. I also updated the language table, where the MediaWiki code for en-gb was missing, and the one for Mongolian was wrong.
