Page 1 of 1

500 error in phocagallery 3.0.2

Posted: 15 Oct 2011, 10:28
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

Re: 500 error in phocagallery 3.0.2

Posted: 15 Oct 2011, 10:50
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.

Re: 500 error in phocagallery 3.0.2

Posted: 15 Oct 2011, 11:19
by Benno
Ok.

Kind regards,
Benno

Re: 500 error in phocagallery 3.0.2

Posted: 19 Oct 2012, 19:19
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!

Re: 500 error in phocagallery 3.0.2

Posted: 22 Oct 2012, 19:07
by Jan
HI, you have installed wrong version in your Joomla! You need to install Phoca Gallery 3 in Joomla! 2.5

Jan

[SOLVED]: 500 error in phocagallery

Posted: 28 Oct 2012, 22:26
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

Re: 500 error in phocagallery 3.0.2

Posted: 31 Oct 2012, 02:24
by Jan
Ok