Re: SQL-error using postgresql.
Forgotten to mention: I'm using tikiwiki 1.9.6.
Regards,
Gert de Weert.
> Hello. I'm getting a sql-error in file tiki-my_tiki.php.
>
> Query: select distinct(p."pageName"), p."user" as lastEditor, p."creator", max(a."lastModif") as date from "tiki_actionlog" as a, "tiki_pages" as p where a."pageName"= p."pageName" and a."user"= ? group by p."pageName" asc order by "pageName" asc
>
> The error message is: "ERROR: syntax error at or near "asc" at character 220"
> It seems that this syntax of 'asc' is not supported in postgresql. I'm seeing this error message rather often.
>
> Any ideas?
>
> Config:
> - apache 2.0.55
> - php 5.2.0
> - postgresql 8.1.5
> All running on Gentoo.
>
> Regards,
> Gert de Weert.
>