Page 2 of 2

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla hepl

Posted: 17 Dec 2009, 01:15
by AndreaNobili
The version of the database thata give me the problel is MySQL: 4.0.30-standard on MySQL: 5.0.81 I have not problem...

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla hepl

Posted: 19 Dec 2009, 19:46
by Jan
Ok

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 20 Aug 2010, 22:51
by Jan
Hi, enable debug mode in your Joomla! so you get more detailed information about the SQL error.

Jan

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 14 Sep 2010, 20:16
by Jan

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 12 Oct 2010, 10:21
by jarin
Hello,
I have the same problem...
Warning: Invalid argument supplied for foreach() in C:\wamp\www\itwcz\administrator\components\com_phocagallery\models\phocagallerycs.php on line 126

Debug says:
500 - Vyskytla se chyba
JDatabaseMySQL::query: 1146 - Table 'itwcz.jos_phocagallery_categories' doesn't exist 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() C:\wamp\www\itwcz\administrator\index.php:67
2 JComponentHelper->renderComponent() C:\wamp\www\itwcz\administrator\includes\application.php:136
3 require_once() C:\wamp\www\itwcz\libraries\joomla\application\component\helper.php:162
4 JController->execute() C:\wamp\www\itwcz\administrator\components\com_phocagallery\admin.phocagallery.php:40
5 PhocaGalleryCpController->display() C:\wamp\www\itwcz\libraries\joomla\application\component\controller.php:236
6 JController->display() C:\wamp\www\itwcz\administrator\components\com_phocagallery\controller.php:148
7 PhocaGalleryCpViewPhocaGalleryCs->display() C:\wamp\www\itwcz\libraries\joomla\application\component\controller.php:310
8 JView->get() C:\wamp\www\itwcz\administrator\components\com_phocagallery\views\phocagallerycs\view.html.php:36
9 PhocaGalleryCpModelPhocaGalleryCs->getData() C:\wamp\www\itwcz\libraries\joomla\application\component\view.php:364
10 JModel->_getList() C:\wamp\www\itwcz\administrator\components\com_phocagallery\models\phocagallerycs.php:42
11 JDatabaseMySQL->loadObjectList() C:\wamp\www\itwcz\libraries\joomla\application\component\model.php:284
12 JDatabaseMySQL->query() C:\wamp\www\itwcz\libraries\joomla\database\database\mysql.php:458
13 JError->raiseError() C:\wamp\www\itwcz\libraries\joomla\database\database\mysql.php:231
14 JError->raise() C:\wamp\www\itwcz\libraries\joomla\error\error.php:171
15 JException->__construct() C:\wamp\www\itwcz\libraries\joomla\error\error.php:136

sysinfo
PHP built zapnuto: Windows NT CHAOS 5.2 build 3790
Verze databáze: 5.1.33-community-log
Porovnání databáze: utf8_general_ci
Verze PHP: 5.2.9-2
Webový server: Apache/2.2.11 (Win32) PHP/5.2.9-2
Rozhraní Webového serveru na PHP: apache2handler
Verze Joomla!: Joomla! 1.5.21 Stable [ senu takaa ama wepulai ] 08-October-2010 18:00 GMT
User Agent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.2; OfficeLiveConnector.1.5; OfficeLivePatch.1.3; .NET4.0C)
MySQL 5.1.33
WAMP 2.0
Can you help me please?

Thanks in advance.

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 17 Oct 2010, 13:46
by Jan
Hi, the debug says what is wrong there:
Table 'itwcz.jos_phocagallery_categories' doesn't exist
The table does not exist, so you should to create it manually.

See:
https://www.phoca.cz/documents/50-phoca/ ... al-advices (2)
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 20 Oct 2010, 17:11
by jarin
Thanks a lot!
looks much better.

Re: Some problem installing Phoca Gallery 2.6.1 onmy Joomla

Posted: 27 Oct 2010, 21:59
by Jan
Ok