I ran the suggested maintenance script, which returned the following
(in parts translated from Norwegian):
root@web1:/www/bmk.no/www/wiki/maintenance# php sql.php
archives/patch-log_user_text.sql
Syntax error in a database request.
Most recent database request was:
«ALTER TABLE `bmkwikilogging`
ADD log_user_text varchar(255) binary NOT NULL default '',
ADD log_page int unsigned NULL,
CHANGE log_type log_type varbinary(32) NOT NULL,
CHANGE log_action log_action varbinary(32) NOT NULL
»
from the function «DatabaseBase::sourceStream».
The database return the error «1060: Duplicate column name 'log_user_text'
(localhost)».
-- Even Thorbergsen
On 18/08/10 08:06, Even Thorbergsen wrote:
However, I still get the database query error
from LogPage::saveContent,
described above, when saving edits.
How do I proceed from here?
I guess it is possible to turn on display of the "offending" SQL query?
Try running the patch file directly:
cd /path/to/wiki/maintenance
php sql.php archives/patch-log_user_text.sql
-- Tim Starling