Loading...
 
Skip to main content

Architecture / Installation


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.


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.
>