Page MenuHomePhabricator

PageHistory::history Key column 'name_title_timestamp' doesn't exist in table"
Closed, InvalidPublic

Description

Author: catblack

Description:
Hey y'all, I'm astounded by MediaWIKI after trying unsuccessfully to get PHPwiki
to run, I decided to just try MediaWiki and found the install painless and the
functionallity wonderful.

But I'm getting this error when I try to hit any history page.

It's not an error related to the sysop acct... Did I miss an option in the setup?

I'm currently exploring the idea of wiki as a journal, so email me for the url.
(I might set another one up to test this.)

Great, easy setup with Ipowerweb.com hosting, btw.

Error below!

A database query syntax error has occurred. This could be because of an illegal
search query (see Searching ActionHourWiki), or it may indicate a bug in the
software. The last attempted database query was:

SELECT

old_id,old_user,old_comment,old_user_text,old_timestamp,old_minor_edit FROM old
USE INDEX (name_title_timestamp) WHERE old_namespace=0 AND old_title='Main_Page'
ORDER BY inverse_timestamp LIMIT 0,50

from within function "PageHistory::history". MySQL returned error "1072: Key
column 'name_title_timestamp' doesn't exist in table".


Version: 1.3.x
Severity: normal
OS: FreeBSD
Platform: Other
URL: http://not.given.com

Details

Reference
bz429

Revisions and Commits

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 6:54 PM
bzimport set Reference to bz429.
bzimport added a subscriber: Unknown Object (MLST).

jeluf wrote:

Please provide the output of the config session. Did you encounter any error
messages during installation?

Apparently, indexes have not been created during DB setup.

They are defined in maintenance/indexes.sql, you can run this script using mysql
client or e.g. phpmyadmin

No follow-up response from reporter after several months.

Current versions define indexes in the main tables.sql, so it would be really hard to get this
wrong if eg doing a manual installation. Resolving as INVALID.

Diffusion changed the task status from Invalid to Resolved by committing Unknown Object (Diffusion Commit).Mar 4 2015, 8:21 AM
Diffusion added a commit: Unknown Object (Diffusion Commit).
Aklapper changed the task status from Resolved to Invalid.Mar 4 2015, 5:45 PM
Aklapper claimed this task.