Last modified: 2009-10-24 08:56:56 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T23258, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 21258 - 1052 Database error
1052 Database error
Status: RESOLVED INVALID
Product: MediaWiki extensions
Classification: Unclassified
ReaderFeedback (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-10-23 20:28 UTC by Robert Edward Goodermote Jr.
Modified: 2009-10-24 08:56 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Robert Edward Goodermote Jr. 2009-10-23 20:28:33 UTC
A user by the name of Harmaggedon has been experiencing a datbase error, specifically 1052. He came to #mediawiki on IRC requestin assistance. After several attempts he continued to get the error which is below

"YPE HTML PUBLIC "-//IETF//DTD 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.
Comment 1 Aaron Schulz 2009-10-24 02:51:47 UTC
Unless `wikirevision` somehow has an rfb_ratings column then that error makes no sense at all.
Comment 2 Harmageddon 2009-10-24 08:53:28 UTC
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!
Comment 3 Aaron Schulz 2009-10-24 08:56:56 UTC
Closing. Other difficulties can go on the extension talk page.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links