Last modified: 2010-05-15 15:38:47 UTC
If you set $wgMaxCredits=-1; (in DefaultSettings.php), the wiki crashes Database error From Phase3 A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT rev_user, rev_user_text, user_real_name, MAX(rev_timestamp) as timestamp FROM revision LEFT JOIN user ON rev_user = user_id WHERE rev_page = AND old_user != 0 GROUP BY rev_user, rev_user_text, user_real_name ORDER BY timestamp DESC from within function "Article::getContributors". MySQL 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 'AND old_user != 0 GROUP BY rev_user, rev_user_text, user_rea". See provisionally http://bugzilla.wikipedia.org/show_bug.cgi?id=508
forgot to say this, the error is present on: - existing installation (after having changed the variable $wgMaxCredits to -1) - fresh installation, fresh database (with the variable $wgMaxCredits = -1)
Fixed in Article.php, revision 1.257 Please test.
New error message is database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT rev_user, rev_user_text, user_real_name, MAX(rev_timestamp) as timestamp FROM revision LEFT JOIN user ON rev_user = user_id WHERE rev_page = 1 AND old_user != 0 GROUP BY rev_user, rev_user_text, user_real_name ORDER BY timestamp DESC from within function "Article::getContributors". MySQL returned error "1054: Unknown column 'old_user' in 'where clause'".
replaced old_user by rev_user. Fixed.