Error occured when trying to switch user from ADMIN page
- Status
- Closed
- Subject
- Error occured when trying to switch user from ADMIN page
- Version
- 2.x
- Category
- Error
- Feature
- Database MySQL (MyISAM)
- Resolution status
- New
- Submitted by
- sperio
- Lastmod by
- Landry Bitege
- Rating
- Description
Error
An error occured in a database query!
Context:
File tiki-adminusers.php
Url tiki-adminusers.phpQuery:
select distinct up.* from `users_permissions` as up, `users_grouppermissions` as ug where ug.`groupName` in () and up.`permName`=ug.`permName`
Values:
Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and up.`permName`=ug.`permName`' at line 1
Built query was probably:
select distinct up.* from `users_permissions` as up, `users_grouppermissions` as ug where ug.`groupName` in () and up.`permName`=ug.`permName`
- Solution
- Workaround
- Priority
- 25
- 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
- 2192
- Created
- Tuesday 02 December, 2008 13:04:38 UTC
by Unknown - LastModif
- Tuesday 31 March, 2026 17:37:14 UTC