Skip to main content ↑ ↓
Show drafts end up with error on PostgresSQL Started by Vague Whiner · · Read 7935 times 0 Members and 2 Guests are viewing this topic. previous topic - next topic

Show drafts end up with error on PostgresSQL

I get this error when I hit the »Show drafts» from the profile info ...

Code: [Select]

ERROR: LIMIT #,# syntax is not supported
LINE 8: LIMIT 0, 15
^
HINT: Use separate LIMIT and OFFSET clauses.
File: /sites3/oche/elkarte/sources/subs/Drafts.subs.php
Line: 274

Note: Your database version is 1.1.8.
Stop Whining!

Re: Show drafts end up with error on PostgresSQL

Reply #1 –

in Drafts.subs.php find on line 267

Code: (find) [Select]
		LIMIT {raw:limit}' : ''),
Change that to
Code: (replace) [Select]
		LIMIT ' . $limit : ''),

This is (yet) another thing that was fixed in 2.0, which now only uses LIMIT and OFFSET clauses for both mysql and postgre

Re: Show drafts end up with error on PostgresSQL

Reply #2 –

Wørkening! Wunderfool!

Much obliged!
Stop Whining!