HTTP Error 500 when opening an item in debug modus

[GoogleCodeExporter]

What steps will reproduce the problem?
1. set "Debug System" to yes in global configuration
2. open an item WITHOUT an tag



What is the expected output? What do you see instead?
500 - An error has occurred!

JDatabaseMySQL::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 ') ORDER BY name ASC' at line 1 SQL=SELECT *,t.id as tid 
FROM jos_flexicontent_tags as t WHERE t.id IN () ORDER BY name ASC

Call stack
#   Function    Location
1   JAdministrator->dispatch()  
C:\IDE\xampp\htdocs\joomla\administrator\index.php:67
2   JComponentHelper->renderComponent() 
C:\IDE\xampp\htdocs\joomla\administrator\includes\application.php:136
3   require_once()  
C:\IDE\xampp\htdocs\joomla\libraries\joomla\application\component\helper.ph
p:162
4   JController->execute()  
C:\IDE\xampp\htdocs\joomla\administrator\components\com_flexicontent\admin.
flexicontent.php:63
5   FlexicontentControllerItems->edit() 
C:\IDE\xampp\htdocs\joomla\libraries\joomla\application\component\controlle
r.php:236
6   FlexicontentController->display()   
C:\IDE\xampp\htdocs\joomla\administrator\components\com_flexicontent\contro
llers\items.php:574
7   JController->display()  
C:\IDE\xampp\htdocs\joomla\administrator\components\com_flexicontent\contro
ller.php:55
8   FlexicontentViewItem->display() 
C:\IDE\xampp\htdocs\joomla\libraries\joomla\application\component\controlle
r.php:310
9   FlexicontentModelItem->getUsedtags()    
C:\IDE\xampp\htdocs\joomla\administrator\components\com_flexicontent\views\
item\view.html.php:109
10  JDatabaseMySQLi->loadObjectList()   
C:\IDE\xampp\htdocs\joomla\administrator\components\com_flexicontent\models
\item.php:949
11  JDatabaseMySQLi->query()    
C:\IDE\xampp\htdocs\joomla\libraries\joomla\database\database\mysqli.php:47
4
12  JError->raiseError()    
C:\IDE\xampp\htdocs\joomla\libraries\joomla\database\database\mysqli.php:24
7
13  JError->raise() 
C:\IDE\xampp\htdocs\joomla\libraries\joomla\error\error.php:171
14  JException->__construct()   
C:\IDE\xampp\htdocs\joomla\libraries\joomla\error\error.php:136



What version of the product are you using? On what operating system?
FLEXIcontent version 1.5.2 stable



Please provide any additional information below.
The error could be in function getUsedtags of file 
\administrator\components\com_flexicontent\models\item.php (line 949) 
because there is no check whether $A is empty

Original issue reported on code.google.com by hannesre...@gmail.com on 29 Mar 2010 at 10:33

[GoogleCodeExporter]

Fixed in r178

Original comment by emmanuel...@gmail.com on 4 Apr 2010 at 6:04

• Changed state: Fixed