Last Actions module causes system error
- Status
- Open
- Subject
- Last Actions module causes system error
- Version
- 24.x
25.x - Category
- Error
- Easy for Newbie Dev
- Feature
- Database MySQL (InnoDB)
Modules - Resolution status
- Confirmed
- Submitted by
- Gary Cunningham-Lee
- Lastmod by
- Gary Cunningham-Lee
- Rating
- Description
I have two current Tiki master instances on my localhost and in both, when I try to activate the module "Last actions", I get a system error:
"You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'order by `lastModif` desc LIMIT 10 OFFSET 0' at line 1
The query was:
select a.* from `tiki_actionlog` a join `tiki_actionlog_conf` c on a.`action` = c.`action` and a.`objectType` = c.`objectType` and (c.`status` = 'v') where order by `lastModif` descThe built query was likely:
select a.* from `tiki_actionlog` a join `tiki_actionlog_conf` c on a.`action` = c.`action` and a.`objectType` = c.`objectType` and (c.`status` = 'v') where order by `lastModif` desc"Jonny said in the Matrix chat that the query is missing the
whereclause.- Importance
- 8
- Easy to solve?
- 8
- Priority
- 64
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
- 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
- 8202
- Created
- Wednesday 12 October, 2022 14:39:59 UTC
by Gary Cunningham-Lee - LastModif
- Thursday 03 November, 2022 14:56:59 UTC