Phoca Forum

3.0.0 Beta1

When I set the "Display Image Instead of Folder Icon" to anything other than Random or Special (i.e. Title Descending...) I get an error message after selecting the associated menu item:

Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\Joomla16\administrator\components\com_phocagallery\libraries\phocagallery\image\imagefront.php on line 421

for each category to display. I don't know if this is a bug or if I'm doing something wrong.

Thanks for your time and slick component.

Hi, thank you for this info, seems like there will be some error in database sql query.

Try to enable debug mode to display it.

Jan

Thanks.

Below is the error:

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 'BY a.title DESC LIMIT 0,1' at line 1 SQL=SELECT a.id, a.filename, a.exts, a.extm, a.extw, a.exth FROM hhh_phocagallery AS a WHERE a.catid = 2 AND a.published = 1ORDER BY a.title DESC LIMIT 0,1


Call stack
# Function Location
1 JSite->dispatch() C:\xampp\htdocs\Joomla16\index.php:43
2 JComponentHelper::renderComponent() C:\xampp\htdocs\Joomla16\includes\application.php:184
3 require_once() C:\xampp\htdocs\Joomla16\libraries\joomla\application\component\helper.php:152
4 JController->execute() C:\xampp\htdocs\Joomla16\components\com_phocagallery\phocagallery.php:48
5 PhocaGalleryController->display() C:\xampp\htdocs\Joomla16\libraries\joomla\application\component\controller.php:629
6 JController->display() C:\xampp\htdocs\Joomla16\components\com_phocagallery\controller.php:17
7 PhocaGalleryViewCategory->display() C:\xampp\htdocs\Joomla16\libraries\joomla\application\component\controller.php:596
8 PhocaGalleryImageFront->getRandomImageRecursive() C:\xampp\htdocs\Joomla16\components\com_phocagallery\views\category\view.html.php:932
9 JDatabaseMySQL->loadObjectList() C:\xampp\htdocs\Joomla16\administrator\components\com_phocagallery\libraries\phocagallery\image\imagefront.php:408
10 JDatabaseMySQL->query() C:\xampp\htdocs\Joomla16\libraries\joomla\database\database\mysql.php:430
11 JError::raiseError() C:\xampp\htdocs\Joomla16\libraries\joomla\database\database\mysql.php:208
12 JError::raise() C:\xampp\htdocs\Joomla16\libraries\joomla\error\error.php:179

Ok, thank you I will take a look at it.

Jan

Ok, found, will be fixed in RC, thank you, Jan

Thank you for your efforts.