4.0.0 Alpha3 - Error MySQl

Phoca Gallery - image gallery extension
Azot
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 26 Feb 2013, 20:17

4.0.0 Alpha3 - Error MySQl

Post by Azot »

PHP version: 5.3
MySQl: 5.1.58
Apache: 2.2.17
Joomla! version: 3.0.3
Errors after entering the...
- Images

Code: Select all

Warning: Invalid argument supplied for foreach() in /home/u728642350/public_html/administrator/components/com_phocagallery/views/phocagalleryimgs/view.html.php on line 32
- Categories

Code: Select all

 0 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 `fpz17_phocagallery_categories` AS a LEFT JOIN `fpz17_languages` AS l ON l.lang_code = a.language LEFT JOIN fpz17_users AS uc ON uc.id=a.checked_out LEFT JOIN fpz17_viewlevels AS ag ON ag.id = a.access LEFT JOIN fpz17_phocagallery_categories AS c ON c.id = a.parent_id LEFT JOIN fpz17_users AS ua ON ua.id = a.owner_id LEFT JOIN fpz17_phocagallery_votes_statistics AS v ON v.catid = a.id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM fpz17_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
Full list http://wklej.to/k2cCo
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49149
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: 4.0.0 Alpha3 - Error MySQl

Post by Jan »

Hi, check if all tables were installed in your database, running the sript without any problem :idea:

Jan
If you find Phoca extensions useful, please support the project
Post Reply