Problem after upgrade from Phoca Gallery 2.2.4 to 2.5.7

[anasilvana]

Hi,
I have a problem after upgrading to 2.5.7 manually. I've followed the update instruction https://www.phoca.cz/documents/2-phoca-g ... ca-gallery but some errors came up when i click <image> or <image rating> menu. I have altered the database as well and add fields like geotitle, zoom, longitude, latitude, etc ..

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

its running just fine before i made an upgrade.
Will very much appreciate for any help. Thanks

[Jan]

Hi, seems like still some column or table is missing on your site. try to enable debug mode, so you should get exactly the error message

Jan

[jptkts]

I just upgraded from 2.2.4 as well and didn't encounter that
HOWEVER the pagination at the bottom is no longer there at the bottom (I do have backups though in case). If I paste in a page like ?start=19 it doesn't goto that page either.

Other details:
Parts of the template previously installed are showing up but the popup is using the default original template. Also I don't store the original high res photos after processing the images as we have limited server space and over 500 images.

I will continue debugging it might figure it out and can put it in debug mode like you suggested.

Thanks

[anasilvana]

Thanks Jan,
Problem solved! Turn on debug mode and found out that table _phocagallery_img_votes and _phocagallery_img_votes_statistics hasn't been created. Done that and now my gallery back to normal again.

Thanks

[Jan]

Hi, you should resave your parameters (parameters basic) as there are two new paginations (categories, images)

Jan

[Jan]

Did you resave the parameters in parameters component - in menu link to gallery?