Project

General

Profile

Actions

Bug #3447

closed

When no users are present in user management a fatal query error is present

Added by krileon almost 12 years ago. Updated over 11 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
18 April 2012
Due date:
% Done:

100%

Estimated time:
1:00 h

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

3447.patch (1.48 KB) 3447.patch krileon, 18 April 2012 17:31
Actions #1

Updated by krileon almost 12 years ago

Call stack
  1. 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
Actions #2

Updated by krileon almost 12 years ago

The query responsible is the one used to retrieve user notes.

Actions #3

Updated by krileon almost 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
Actions #4

Updated by beat almost 12 years ago

  • Target version changed from CB 1.8.1 to CB 1.9
Actions #5

Updated by beat over 11 years ago

  • Status changed from Resolved to Closed
  • Estimated time set to 1:00 h

Fixed as suggested in r1889 .
Thank you Kyle.

Actions

Also available in: Atom PDF