Database error on click on "mytiki home"
- Status
- Closed
- Subject
- Database error on click on "mytiki home"
- Version
- 1.9.x
- Category
- Error
- Feature
- MyTiki
Database independence (Non-Mysql, ADOdb Postgres, Oracle, etc) - Resolution status
- Out of Date
- Lastmod by
- Kissaki
- Rating
- Description
1.9.6 w/ postgresql 8.0.8.
Click on MyTiki Home.
Error is:
An error occured in a database query!
Context:
File tiki-my_tiki.php
Url 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
Values:
0 andy
Message:
Error Message ERROR: syntax error at or near "asc" at character 219- Solution
Please upgrade to a recent version of tiki.
If the problem persists, add a new tracker item.- Importance
- 7
- Priority
- 35
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is currently unavailableUnable to connect to show2.tiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is currently unavailableUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
- Ticket ID
- 930
- Created
- Saturday 11 November, 2006 04:40:44 UTC
by Unknown - LastModif
- Saturday 08 August, 2009 19:23:55 UTC