Page MenuHomePhabricator

selecting "my watchlist" results in sql error
Closed, ResolvedPublic

Description

Author: wanyden

Description:
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


Version: 1.4.x
Severity: critical

Details

Reference
bz2747

Event Timeline

bzimport raised the priority of this task from to Unbreak Now!.
bzimport set Reference to bz2747.
bzimport added a subscriber: Unknown Object (MLST).
bzimport created this task.Jul 7 2005, 6:01 PM
brion added a comment.Jul 7 2005, 6:40 PM

What's your MySQL version?

brion added a comment.Jul 16 2005, 6:45 AM

1.4.7 reverts to prior version of SpecialWatchlist.php, which works on MySQL 3.23.x. Resolving as fixed.

tine.benko wrote:

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.