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
