Bug #3447
closed
When no users are present in user management a fatal query error is present
Added by krileon about 12 years ago.
Updated over 11 years ago.
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
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
The query responsible is the one used to retrieve user notes.
- File 3447.patch 3447.patch added
- Status changed from Assigned to Resolved
- Assignee changed from krileon to beat
- % Done changed from 0 to 100
- Target version changed from CB 1.8.1 to CB 1.9
- Status changed from Resolved to Closed
- Estimated time set to 1:00 h
Fixed as suggested in r1889 .
Thank you Kyle.
Also available in: Atom
PDF
Updated by 
Updated by