Upgrade - everything gone?

[stdo]

I'm having a similar issue...on the images page I get this error where the images are:

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

But, like coendeurloo said, I can see the categories in the Thumbnail Creation drop box. On the Categories page, I get:

Warning: Invalid argument supplied for foreach() in /home/garraf2/public_html/joomla/administrator/components/com_phocagallery/models/phocagallerycs.php on line 126

I know all of the info is there, something just needs to be fixed somewhere for it all to display. I'm trying this next:

https://www.phoca.cz/documents/2-phoca-g ... L_database

Same issue here. I have been upgrading from 2.5.2, I think.

I tried to reinstall the v_2.7.1 with upgrade option, but the error msgs still remain:

On: option=com_phocagallery&view=phocagalleryusers

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/v.../libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /www/htdocs/v.../libraries/joomla/database/database/mysql.php on line 344

On: option=com_phocagallery&view=phocagallerycs

Code: Select all

Warning: Invalid argument supplied for foreach() in /www/htdocs/v.../administrator/components/com_phocagallery/models/phocagallerycs.php on line 126

Any hints to solve this problem?


By the way, there is an error in the actual install.bak of v_2.7.1 in some lines behind "-- 2.6.0" there is the "ADD" missing.

Code: Select all

-- ALTER TABLE `#__phocagallery` `extid` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `extl` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `extm` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `exts` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `exto` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `extw` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery` `exth` varchar(255) NOT NULL default '' AFTER `hits` ;

[Jan]

Hi,

translation - seems like it is not complete (I got new translation and will paste it to the site in some days)

The first problem I can solve is that the 2 categories are not shown in the backend menu. I can access them from image backend menu

Sorry, I don't understand, there are not displayed but how you can access them?