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