Skip to main content
Topic: Show drafts end up with error on PostgresSQL (Read 548 times) previous topic - next topic
0 Members and 1 Guest are viewing this 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!