multiple database error messages

[tosh124]

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

[Jan]

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

Jan

[tosh124]

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

[Jan]

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