Hello,
I installed Phocagallery 3.0 RC 5 on Joomla 1.6.2. Administration section works fine but when I insert a gallery in an article, it gives me this:
Warning: Invalid argument supplied for foreach() in *********\plugins\content\phocagallery\phocagallery.php on line 737
It is this line:
737 foreach ($data_outcome_array as $category) {
738 // ROUTE
739 $category->link = JRoute::_(PhocaGalleryRoute::getCategoryRoute($category->id, $category->alias));
Help me please
Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
-
kymm
- Phoca Member

- Posts: 12
- Joined: 12 May 2011, 10:14
-
kymm
- Phoca Member

- Posts: 12
- Joined: 12 May 2011, 10:14
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
No answer ??? 
- Jan
- Phoca Hero

- Posts: 49190
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
Hi, try to enable debug mode to get info from the database, do you run the latest plugin?
If you find Phoca extensions useful, please support the project
-
kymm
- Phoca Member

- Posts: 12
- Joined: 12 May 2011, 10:14
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
Lastest plugin :Jan wrote:Hi, try to enable debug mode to get info from the database, do you run the latest plugin?
Button phoca gallery 2.7.1
Phoca Gallery Plugin 3.0.1
How do I enable debug mode?
-
focavero
- Phoca Newbie

- Posts: 6
- Joined: 08 Dec 2010, 20:00
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
Hi, I have the same problem, I can't do anything with the component beacause of the errors:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in .../libraries/joomla/database/database/mysqli.php on line 345
and
Warning: Invalid argument supplied for foreach() in .../libraries/joomla/database/database/mysqli.php on line 727
With the debug ON it tells me about:
JDatabaseMySQL::query: 1146 - Table 'DBname.jos_phocagallery_categories' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `jos_phocagallery_categories` 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_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
?????? What do I need to do? Please help!
Sorry I forgot to say: I installed today the latest version for Joomla 1.6
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in .../libraries/joomla/database/database/mysqli.php on line 345
and
Warning: Invalid argument supplied for foreach() in .../libraries/joomla/database/database/mysqli.php on line 727
With the debug ON it tells me about:
JDatabaseMySQL::query: 1146 - Table 'DBname.jos_phocagallery_categories' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg,cc.countid AS countid FROM `jos_phocagallery_categories` 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_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN jos_users AS ua ON ua.id = a.owner_id LEFT JOIN jos_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM jos_phocagallery_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
?????? What do I need to do? Please help!
Sorry I forgot to say: I installed today the latest version for Joomla 1.6
-
kymm
- Phoca Member

- Posts: 12
- Joined: 12 May 2011, 10:14
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
I do not understand anything, it resumed operating alone..........
-
focavero
- Phoca Newbie

- Posts: 6
- Joined: 08 Dec 2010, 20:00
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
did you solve your problem?
-
kymm
- Phoca Member

- Posts: 12
- Joined: 12 May 2011, 10:14
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
I never do anything... I don't know why phoca run well now..
-
donvito
- Phoca Newbie

- Posts: 1
- Joined: 15 Jun 2011, 08:42
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
Hello,
if got the same problem! I need help! What can i do to run phoca galerie?
if got the same problem! I need help! What can i do to run phoca galerie?
- Jan
- Phoca Hero

- Posts: 49190
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Probleme PhocaGallery 3 RC5 & Joomla 1.6.2
See:
https://www.phoca.cz/documents/2-phoca-g ... em-solving
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan
https://www.phoca.cz/documents/2-phoca-g ... em-solving
https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan
If you find Phoca extensions useful, please support the project