1.6 RC1 - Category View Settings

[garykeefe109]

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.

[Jan]

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

[garykeefe109]

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

[Jan]

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

Jan

[Jan]

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

[garykeefe109]

Thank you for your efforts.