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 (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.
- Ticket ID
- 930
- Created
- Saturday 11 November, 2006 04:40:44 GMT-0000
by Unknown - LastModif
- Saturday 08 August, 2009 19:23:55 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- fresh opening of tiki home page tiki-index (I removed a warning) is it OK
- Tracker with field type "Numeric" won't
- tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
- Kanban plugin; the Swimlane field throw an error if using a category field type
- Kanban plugin: Error if the fields Description and Swimlane are empty
;){kind=link}
;){kind=link}