Last modified: 2010-05-15 15:33:53 UTC
Error message: Database error From WikiPOBia (for user "Billy Ruffian") A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "wfSpecialWatchlist". MySQL returned error "1064: You have an error in your SQL syntax near 'UNION SELECT rc_namespace cur_namespace, rc_title cur_title, rc_comment cur_' at line 9 (localhost)". Location of faulty code is probably in includes/SpecialWatchlist.php
What's your MySQL version?
1.4.7 reverts to prior version of SpecialWatchlist.php, which works on MySQL 3.23.x. Resolving as fixed.
I have very simmilar problem so I wont open new bug... When I try to open MyWatchlist (just if it ist't empty), error 1064 occurs. Here is c/p: >A database query syntax error has occurred. This may indicate a bug in the >software. The last attempted database query was: >(SQL query hidden) >from within function "wfSpecialWatchlist". MySQL returned error "1064: You >have an error in your SQL syntax near 'INDEX (page_timestamp) WHERE wl_user=5 >AND wl_namespace=page_namespace ' at line 4 (localhost)". >Retrieved from "http://--path--/index.php?title=Special:Watchlist" That error occurs also on some other pages e.g.: RandomPage, MyContributions, Special pages/AllPages. That error came up after upgrading v.1.4.7. to 1.5beta4 and keeping the same db.
That's bug 3056.