A few errors after fresh install

Phoca Gallery - image gallery extension
mangotti
Phoca Newbie
Phoca Newbie
Posts: 1
Joined: 30 Jun 2011, 01:53

A few errors after fresh install

Post by mangotti »

I just installed this onto a Joomla 1.6 site and I am receiving a few errors.
In the admin area under users, I get the following error when th page loads:

Code: Select all

500 - An error has occurred.
Table 'origami_nysboc.jos_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM jos_phocagallery_user AS a LEFT JOIN jos_languages AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM jos_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM jos_phocagallery AS i LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN jos_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Table 'origami_nysboc.jos_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM jos_phocagallery_user AS a LEFT JOIN jos_languages AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM jos_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM jos_phocagallery AS i LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN jos_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc LIMIT 0, 100 Table 'origami_nysboc.jos_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM jos_phocagallery_user AS a LEFT JOIN jos_languages AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM jos_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM jos_phocagallery AS i LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN jos_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc Table 'origami_nysboc.jos_phocagallery_user' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,c.countcid,i.countiid FROM jos_phocagallery_user AS a LEFT JOIN jos_languages AS l ON l.lang_code = a.language LEFT JOIN jos_users AS ua ON ua.id=a.userid LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN (SELECT c.owner_id, c.id, count(*) AS countcid FROM jos_phocagallery_categories AS c GROUP BY c.owner_id) AS c ON a.userid = c.owner_id LEFT JOIN (SELECT i.catid, uc.userid AS uid, count(i.id) AS countiid FROM jos_phocagallery AS i LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = i.catid LEFT JOIN jos_phocagallery_user AS uc ON uc.userid = cc.owner_id GROUP BY uc.userid ) AS i ON i.uid = c.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY uc.username asc

Return to Control Panel
Then, under the categories area I get this:

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/origami/public_html/libraries/joomla/database/database/mysql.php on line 317

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/origami/public_html/libraries/joomla/database/database/mysql.php on line 317
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49190
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: A few errors after fresh install

Post by Jan »

Hi, while installation, the table were not created in database, see install.sql.bak file, see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

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