Phoca Forum

hi
probs with installation from phoca
installation runs okay and all tables exist

but if want create an new catagory i get this failure


Warning: Invalid argument supplied for foreach() in /..../joomla/administrator/components/com_phocagallery/models/phocagallerycs.php on line 126


what can i do
i read all the threads with the same failure but i can not find the solution
joomla 1.5
phoca newest version
mysql 4

Hi, still seems like some table, or column is missing in the database. Try to enable debug mode (if you get some error message) and see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

my failure text


500 - •Es ist ein Fehler aufgetreten•

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 'SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_c SQL=SELECT a.*, cc.title AS parentname, u.name AS editor, g.name AS groupname, v.average AS ratingavg, ua.username AS usercatname, c.countid AS countid FROM jos_phocagallery_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_groups AS g ON g.id = a.access LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.parent_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id JOIN (SELECT c.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS c GROUP BY c.parent_id ) AS c ON a.parent_id = c.parent_id ORDER BY a.ordering

Call stack
# Function Location
1 JAdministrator->dispatch() /..../index.php:67
2 JComponentHelper->renderComponent() /..../includes/application.php:136
3 require_once() /homepages/..../joomla/libraries/joomla/application/component/helper.php:162
4 JController->execute() /..../components/com_phocagallery/admin.phocagallery.php:40
5 PhocaGalleryCpController->display() /homepages/..../joomla/libraries/joomla/application/component/controller.php:236
6 JController->display() /..../components/com_phocagallery/controller.php:148
7 PhocaGalleryCpViewPhocaGalleryCs->display() /homepages/..../joomla/libraries/joomla/application/component/controller.php:310
8 JView->get() /..../components/com_phocagallery/views/phocagallerycs/view.html.php:36
9 PhocaGalleryCpModelPhocaGalleryCs->getData() /homepages/..../joomla/libraries/joomla/application/component/view.php:364
10 JModel->_getList() /..../components/com_phocagallery/models/phocagallerycs.php:42
11 JDatabaseMySQL->loadObjectList() /homepages/..../joomla/libraries/joomla/application/component/model.php:284
12 JDatabaseMySQL->query() /homepages/..../joomla/libraries/joomla/database/database/mysql.php:458
13 JError->raiseError() /homepages/..../joomla/libraries/joomla/database/database/mysql.php:231
14 JError->raise() /homepages/..../joomla/libraries/joomla/error/error.php:171
15 JException->__construct() /homepages/..../joomla/libraries/joomla/error/error.php:136

Hi, such error can happen on some versions of mysql, try to upgrade version of mysql if you can

Hi Jan,

is there a known issue with MySQL Version 4.0.25? Because I do have similar debug messages like jhaustein.

Which MySQL Versions do you recommend?

I upgraded PG from v_2.5.2 to v_2.7.1 on a server with MySQL 4.0.25 returning me problems. Now I am afraid of upgrading PG from v_2.5.2 to v_2.7.1 on a server with MySQL 4.1.22.

Hi, I have tested the script with mysql 4.1 and it was working OK, but there are some settings in 4 version which can have problems with the compound query.

So if you are running 4 version, you need to check the settings.

I recommend version 5 of course.

Jan