Thread:Project:Support desk/A database query syntax error has occurred. Help please!/reply (7)

This is fixed, thanks to Platonides on mediawiki-l!

> Platonides asks: >   >> What errors are you getting? >> (eg. table foo not found) >>   >> What does update.php say? >> (eg. table foo already exists) >>   >>    > Thanks for asking! >   > Here's the one when trying to block a user (spambot), or delete the new page > full of spam: Key 'log_user_type_time'  doesn't exist in table Unknown column 'log_page' Both items are added in patch-log_user_text.sql log_user_text > Here is the report from update.php: > ...have log_user_text field in logging table. log_user_text field is added in that same patch, so it assumes all of   them are in the table. I don't know how did you end up with such half-applied patch. What engine are you using? MyIsam, Innodb... ?   You can execute ALTER TABLE logging DROP COLUMN log_user_text; Then rerun update.php which should now pick that full patch.

That fixed it!

I think the half applied patch may have had to do with doing the update from the web installer, and selecting the wrong option for the database on the frist go around, but I don't know.

I'm using MyISAM. I used Innodb at first but it was less stable on the server I was on so I switched.

What a relief to have this fixed. Thanks to all! Scott