SQL-error using postgresql.
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.