https://bugzilla.wikimedia.org/show_bug.cgi?id=68994
Bug ID: 68994 Summary: DynamicPageList2 compatibility probleme with PostgreSQL Product: MediaWiki extensions Version: unspecified Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: Unprioritized Component: DynamicPageList2 Assignee: wikibugs-l@lists.wikimedia.org Reporter: david.roger.p...@gmail.com Web browser: --- Mobile Platform: --- Using actual version of DynamicPageList2 with Mediawiki and PostgreSQL database does not work. It's due to "LIMIT offset,row_count" usage in DPLMain.php. For Postgresql compatibility, it's better to use "LIMIT row_count OFFSET offset" syntax. Here are errors : SQL ERROR: ERREUR: la syntaxe LIMIT #,# n'est pas supportée LINE 1: ...ev_page=rev.rev_page ) ORDER BY rev_timestamp ASC LIMIT 0, 1 ^ HINT: Utilisez les clauses séparées LIMIT et OFFSET. Parser: using preprocessor: Preprocessor_DOM Parser output marked as uncacheable. SQL ERROR (ignored): ERREUR: la syntaxe LIMIT #,# n'est pas supportée LINE 1: ...ev_page=rev.rev_page ) ORDER BY rev_timestamp ASC LIMIT 0, 1 ^ HINT: Utilisez les clauses séparées LIMIT et OFFSET. [exception] [ab8564cb] /index.php/Accueil Exception from line 554 of /var/www/cnp31wiki/intranet/includes/db/DatabasePostgres.php: Unable to free Postgres result -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l