Phoca Forum

I was having issues with my categories. I deleted the ones that were working. Then PhocaGallery wouldn't let me create new ones. Kepting getting "error when creating categories".

So I uninstalled 2.7.1 and reinstalled 2.7.1 and now I get this error at the top of each page...
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kiddsl5/public_html/usasolarpower.com/joomla17/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/kiddsl5/public_html/usasolarpower.com/joomla17/libraries/joomla/database/database/mysql.php on line 344

Warning: Invalid argument supplied for foreach() in /home/kiddsl5/public_html/usasolarpower.com/joomla17/administrator/components/com_phocagallery/libraries/phocagallery/render/renderadmin.php on line 65

I did an "upgrade" and got this error:
Phoca Gallery not successfully upgraded:
Error while updating HITS columnError while updating Extlink1 columnError while updating Extlink2 columnError while updating Date columnError while updating Geotitle (Category) columnError while updating Zoom (Category) columnError while updating Longitude (Category) columnError while updating Latitude (Category) columnError while updating Userfolder columnError while updating Deleteuserid columnError while updating Uploaduserid columnError while updating Accessuserid columnError while updating Geotitle columnError while updating Zoom columnError while updating Longitude columnError while updating Latitude columnError while updating Video Code columnError while updating VirtueMart Product ID columnError while updating Image Original Size columnError while updating Owner ID columnError while updating Approved(Categories) columnError while updating Approved(Images) columnError while updating External Image Id columnError while updating External Large Image columnError while updating External Medium Image columnError while updating External Small Image columnError while updating External Image Width columnError while updating External Image Height columnError while updating External Image Original columnError while updating External Id (Category) columnError while updating External Image Album columnError while updating External Image User columnError while updating Metakey columnError while updating Metakey column (Categories)Error while updating MetaDescription columnError while updating MetaDescription column (Categories)Error while updating External Image Album - Auth columnTable 'kiddsl5_joomla17.jos_phocagallery' doesn't exist SQL=SELECT * FROM `jos_phocagallery` LIMIT 1;
Table 'kiddsl5_joomla17.jos_phocagallery_categories' doesn't exist SQL=SELECT * FROM `jos_phocagallery_categories` LIMIT 1;

WHAT IS GOING ON HERE? WHY WAS IT WORKING AND NOW IT'S CRASHED?

to answer my own questions - it crashes after an uninstall because in the guts of the zipped pack of files, the database is instructed to drop these tables from the mysql database:
DROP TABLE IF EXISTS `#__phocagallery`;
DROP TABLE IF EXISTS `#__phocagallery_categories`;
DROP TABLE IF EXISTS `#__phocagallery_votes`;
DROP TABLE IF EXISTS `#__phocagallery_votes_statistics`;
DROP TABLE IF EXISTS `#__phocagallery_comments`;
DROP TABLE IF EXISTS `#__phocagallery_img_comments`;
DROP TABLE IF EXISTS `#__phocagallery_user_category`;
DROP TABLE IF EXISTS `#__phocagallery_img_votes`;
DROP TABLE IF EXISTS `#__phocagallery_img_votes_statistics`;
DROP TABLE IF EXISTS `#__phocagallery_user`;

Therefore - upon reinstall, they are not there nor are they recreated.

manually create the tables and it works. it was a headache but it worked for me.

LrG

Well done!
Kind regards,
Benno