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
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. 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 not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. 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