Phoca Forum

Hello,
I am using the gallery module to rotate images on the homepage, but I am getting consistent error message when I go into the module, the messages are similar to "libraries/joomla/database/database/mysql.php on line 317"
I dont recall them being there when I set up the image rotator so something seems to have changed.

When I enter the image gallery module I see the error message "Warning: Invalid argument supplied for foreach() in /home/histor45/public_html/administrator/components/com_phocagallery/libraries/phocagallery/render/renderadmin.php on line 70"

Does anyone have any idea what is wrong? I am hoping to set up the slider so that I can have a different gallery on each of several different pages.
thanks
Col

Hi, enable debug mode in Joomla! configuration to get more information about the problem in database.

Jan

Hi Jan,
thanks for your reply. I have switched it on and the errors I get when entering the images link of the gallery are;

500 - An error has occurred.
JDatabaseMySQL::query: 1146 - Table 'histor45_jo161.jos_phocagallery' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg FROM `jos_phocagallery` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_users AS uua ON uua.id=a.userid LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = c.owner_id LEFT JOIN jos_phocagallery_img_votes_statistics AS v ON v.imgid = a.id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /home/histor45/public_html/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/histor45/public_html/administrator/includes/application.php:152
3 require_once() /home/histor45/public_html/libraries/joomla/application/component/helper.php:152
4 JController->execute() /home/histor45/public_html/administrator/components/com_phocagallery/phocagallery.php:35
5 PhocaGalleryCpController->display() /home/histor45/public_html/libraries/joomla/application/component/controller.php:629
6 JController->display() /home/histor45/public_html/administrator/components/com_phocagallery/controller.php:184
7 PhocaGalleryCpViewPhocaGalleryImgs->display() /home/histor45/public_html/libraries/joomla/application/component/controller.php:596
8 JView->get() /home/histor45/public_html/administrator/components/com_phocagallery/views/phocagalleryimgs/view.html.php:28
9 JModelList->getItems() /home/histor45/public_html/libraries/joomla/application/component/view.php:365
10 JModelList->getstart() /home/histor45/public_html/libraries/joomla/application/component/modellist.php:118
11 JModelList->getTotal() /home/histor45/public_html/libraries/joomla/application/component/modellist.php:244
12 JModel->_getListCount() /home/histor45/public_html/libraries/joomla/application/component/modellist.php:213
13 JDatabaseMySQL->query() /home/histor45/public_html/libraries/joomla/application/component/model.php:230
14 JError::raiseError() /home/histor45/public_html/libraries/joomla/database/database/mysql.php:208
15 JError::raise() /home/histor45/public_html/libraries/joomla/error/error.php:179

cheers
Col

Hi, the tables for Phoca Gallery were not created in your database, try to see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan