Page MenuHomePhabricator

Database error: MySQL returned error "1054: Unknown column 'ipb_anon_only' in 'where clause'
Closed, ResolvedPublic

Description

Author: jasonnc80

Description:
I recently began getting a Database error when I try to edit pages with created
accounts. The error only comes up when I am logged in as my SysOp account or
other people are logged in as well.

Anon editing works fine with no problems. Here is the error I'm getting:

Database error
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

SELECT * FROM `wiki_ipblocks` WHERE ipb_address = '76.5.175.172' AND

ipb_auto = '1' AND ipb_anon_only = '0'

from within function "Block::load". MySQL returned error "1054: Unknown column
'ipb_anon_only' in 'where clause' (wiki.projectbob.org)".

This only started happening recently. I've tried to restore the database to a
previous date (the last known time I edited) but to no avail. Any help is
appreciated.


Version: 1.9.x
Severity: major
OS: Windows XP
Platform: PC
URL: http://www.projectbob.org/wiki

Details

Reference
bz8862

Event Timeline

bzimport raised the priority of this task from to High.Nov 21 2014, 9:32 PM
bzimport set Reference to bz8862.
bzimport added a subscriber: Unknown Object (MLST).

robchur wrote:

Upgrade to 1.9.1 and re-run the update script; there were some bugs in the
update order for the 1.9.0 upgrade, which cause this problem.

  • This bug has been marked as a duplicate of 8641 ***