Author: matt

Description:
I had mediawiki working fine with 1.4.1. I upgraded to 1.4.4, updated my
site_stats table to the new definition, and now get the error logged below. I
don't think pg supports LIMIT clauses in UPDATE commands. Removing the LIMIT
clause in SiteStatsUpdate.php fixed this for me.

Warning: pg_query(): Query failed: ERROR: syntax error at or near "LIMIT" at
character 89 in /home/www/includes/DatabasePostgreSQL.php on line 99
A database error has occurred Query: UPDATE "site_stats" SET
ss_total_views=ss_total_views+1 LIMIT 1 Function: SiteStatsUpdate::doUpdate
Error: 1 ERROR: syntax error at or near "LIMIT" at character 89

Backtrace:

• GlobalFunctions.php line 507 calls wfbacktrace()
• DatabasePostgreSQL.php line 419 calls wfdebugdiebacktrace()
• Database.php line 333 calls databasepostgresql::reportqueryerror()
• SiteStatsUpdate.php line 123 calls databasepostgresql::query()
• index.php line 211 calls sitestatsupdate::doupdate()

Version: 1.4.x
Severity: normal