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

Assigned To

None

Authored By

	• bzimport
	Jul 7 2005, 6:01 PM

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!.Nov 21 2014, 8:39 PM

• bzimport added a project: MediaWiki-libs-Rdbms.

• bzimport set Reference to bz2747.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Jul 7 2005, 6:01 PM

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.

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.

Luke081515 removed a subscriber: • wikibugs-l-list.Jan 28 2016, 6:05 PM

selecting "my watchlist" results in sql errorClosed, ResolvedPublicActions

Description

Details

Event Timeline

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