Print Page - Show drafts end up with error on PostgresSQL

Title: Show drafts end up with error on PostgresSQL
Post by: Vague Whiner on February 15, 2023, 05:04:48 pm

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


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.

Title: Re: Show drafts end up with error on PostgresSQL
Post by: Spuds on February 16, 2023, 09:07:21 am

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

Title: Re: Show drafts end up with error on PostgresSQL
Post by: Vague Whiner on February 17, 2023, 05:27:55 am

Wørkening! Wunderfool!

Much obliged!

ElkArte Community

Elk Development => Bug Reports => Exterminated Bugs => Topic started by: Vague Whiner on February 15, 2023, 05:04:48 pm