Page MenuHomePhabricator

1052 Database error
Closed, InvalidPublic

Description

Author: Rgoodermote

Description:
A user by the name of Harmaggedon has been experiencing a datbase error, specifically 1052. He came to MediaWiki-General on IRC requestin assistance. After several attempts he continued to get the error which is below

"YPE HTML PUBLIC "-IETFDTD HTML 2.0//EN"> Internal Error

A database error has occurred
Query: SELECT rfb_ratings FROM wikirevision FORCE INDEX (page_timestamp),wikireader_feedback WHERE rev_page = '36' AND (rev_id = rfb_rev_id) AND (rfb_timestamp >= '20090920000000') AND (rev_timestamp >= '20090911123847')
Function: ReaderFeedback::getVoteAggregates
Error: 1052 Column 'rfb_ratings' in field list is ambiguous (localhost)"

He also reported it here http://www.mediawiki.org/wiki/Extension_talk:ReaderFeedback#Database_Error

His Mediawiki version is 1.15.1 and MySQL is MySQL: 5.0.77mm0.1-log

I am reporting this on his behalf.


Version: unspecified
Severity: enhancement

Details

Reference
bz21258

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:52 PM
bzimport set Reference to bz21258.

Unless wikirevision somehow has an rfb_ratings column then that error makes no sense at all.

Well, there was a rfb_ratings column, because before I got this error, there was another error that told me there was no rfb_ratings column in this table. But now, after I deleted this column, it works!!! Thank you!

Closing. Other difficulties can go on the extension talk page.