500 error in phocagallery 3.0.2

Phoca Gallery - image gallery extension
morsagmon
Phoca Newbie
Phoca Newbie
Posts: 7
Joined: 18 Sep 2010, 20:51

500 error in phocagallery 3.0.2

Post by morsagmon »

Installed the PG component 3.0.2 on a Joomla 1.7.1.
Clicking on "Category Ratings" or "Users" (perhaps others?) in the control panel, brings up the following page:
500 - An error has occurred.

Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc LIMIT 0, 20 Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc Table 'dhhisunm_jdb.ha17_phocagallery_votes' doesn't exist SQL=SELECT a.*,l.title AS language_title,ua.id AS ratinguserid, ua.username AS ratingusername, ua.name AS ratingname,uc.name AS editor,c.title AS category_title, c.id AS category_id FROM `ha17_phocagallery_votes` AS a LEFT JOIN `ha17_languages` AS l ON l.lang_code = a.language LEFT JOIN ha17_users AS ua ON ua.id=a.userid LEFT JOIN ha17_users AS uc ON uc.id=a.checked_out LEFT JOIN ha17_phocagallery_categories AS c ON c.id = a.catid GROUP BY a.id ORDER BY ua.username asc

Return to Control Panel
morsagmon
Phoca Newbie
Phoca Newbie
Posts: 7
Joined: 18 Sep 2010, 20:51

Re: 500 error in phocagallery 3.0.2

Post by morsagmon »

OK. I found out what it is.
When installing, I chose "Upgrade" and not "Install".
I had an old version of Phocagallery (2.7.5) on Joomla 1.5, so I thought I'll find my pics in the DB - which didn't happen anyway.
I re-installed and all is working fine now.
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9974
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: 500 error in phocagallery 3.0.2

Post by Benno »

Ok.

Kind regards,
Benno
focavero
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 08 Dec 2010, 20:00

Re: 500 error in phocagallery 3.0.2

Post by focavero »

Hi, sorry but this solutions was not good for me.
Problem: clicking in admin on Rating, comments, users, etc. I get the 500 error and a long text as said above.
In Images and Categories the error is a string saying:
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /var/www....libraries/joomla/database/database/mysqli.php on line 263 Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /..../libraries/joomla/database/database/mysqli.php on line 263
and other string is:
Warning: Invalid argument supplied for foreach() in /var/..../administrator/components/com_phocagallery/libraries/phocagallery/render/renderadmin.php on line 70
What I did:
  • Uninstalled completely Phocagallery
  • Database was empty
  • Created all MyPrefix_tabs on the DataBase with the install.bak
Everything seamed to be ok, but NO LINK in the component menu!! :x


But....
all the above errors and messages are STILL THERE !!!!

What am I doing wrong?
Working on
Joomla 2.5.7 and Phocagallery 2.7.9

Thank you so much for help, I installed so many times Phocagallery before on other sites with no problem!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: 500 error in phocagallery 3.0.2

Post by Jan »

HI, you have installed wrong version in your Joomla! You need to install Phoca Gallery 3 in Joomla! 2.5

Jan
If you find Phoca extensions useful, please support the project
focavero
Phoca Newbie
Phoca Newbie
Posts: 6
Joined: 08 Dec 2010, 20:00

[SOLVED]: 500 error in phocagallery

Post by focavero »

I downloaded the right version but somehow I did install the old one... stupid me!

Now I have the new version correctly installed.
Thank you
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: 500 error in phocagallery 3.0.2

Post by Jan »

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