Actions
Bug #3447
closed
When no users are present in user management a fatal query error is present
Description
When there is an empty list of users in user management (after a delete of a single user result for example). The below fatal query error is displayed.
JDatabaseMySQLi::query: 1064 - 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 n.state >= 0 GROUP BY n.user_id' at line 3 SQL=SELECT n.user_id, COUNT AS note_count FROM `jos_user_notes` AS n WHERE n.user_id IN () AND n.state >= 0 GROUP BY n.user_id
The only remedy is to disable debug mode and clear the search result. It's due to the IN () (no results).
Files
Updated by krileon over 12 years ago
Call stack
- Function Location
1 JAdministrator->dispatch() D:\xampp\htdocs\cb\administrator\index.php:46
2 JComponentHelper::renderComponent() D:\xampp\htdocs\cb\administrator\includes\application.php:153
3 JComponentHelper::executeComponent() D:\xampp\htdocs\cb\libraries\joomla\application\component\helper.php:357
4 require_once() D:\xampp\htdocs\cb\libraries\joomla\application\component\helper.php:388
5 require() D:\xampp\htdocs\cb\administrator\components\com_comprofiler\admin.comprofiler.php:29
6 CBController_users->showUsers() D:\xampp\htdocs\cb\administrator\components\com_comprofiler\admin.comprofiler.controller.php:152
7 CBdatabase->loadObjectList() D:\xampp\htdocs\cb\administrator\components\com_comprofiler\controller\controller.users.php:284
8 CBdatabase->query() D:\xampp\htdocs\cb\administrator\components\com_comprofiler\library\cb\cb.database.php:861
9 JDatabaseMySQLi->query() D:\xampp\htdocs\cb\administrator\components\com_comprofiler\library\cb\cb.database.php:695
10 JError::raiseError() D:\xampp\htdocs\cb\libraries\joomla\database\database\mysqli.php:396
11 JError::raise() D:\xampp\htdocs\cb\libraries\joomla\error\error.php:251
Updated by krileon over 12 years ago
The query responsible is the one used to retrieve user notes.
Updated by krileon over 12 years ago
- File 3447.patch 3447.patch added
- Status changed from Assigned to Resolved
- Assignee changed from krileon to beat
- % Done changed from 0 to 100
Updated by beat over 12 years ago
- Target version changed from CB 1.8.1 to CB 1.9
Updated by beat about 12 years ago
- Status changed from Resolved to Closed
- Estimated time set to 1:00 h
Fixed as suggested in r1889 .
Thank you Kyle.
Actions