Phoca Forum

Hi,
i was hoping to ypdate my site this weekend....
so far i have updated joomla from 1.5.24 > 1.7 using jupdate

i have now installed phoca gallery 3.15 in the new 1.7 install. an clicked upgrade (because the image folders existed)

however i am now getting various sql errors

in the images tab (back end) i get

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

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

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


and in the front end i get

Warning: Invalid argument supplied for foreach() in /home/ukcoast/public_html/jupgrade/components/com_phocagallery/models/categories.php on line 159

you can see the old site running here
http://www.ukcoastalwildlife.co.uk

thanks
jason

***now updated joomla to 2.5.1 (template i had did not work in 1.7

Hi Jason,

Those errors could be with some error in your database.
Please have a look here (left side) - especially "Upgrading the tables"

https://www.phoca.cz/documents/2-phoca-g ... em-solving

regards, christine

Hi,
i have had a look, but it all seems to be there. could someone take a look at it for me please? i could provide all the details via pm.

thank you
jason

hi,
ok, getting closer, i have duplicated the tables and added the new prefix..i now have a list of images here> http://ukcoastalwildlife.co.uk/jupgrade ... hp/gallery

just need to update the tables and add the facebook phocagallery_fb_users table. i have tried this but i am now a little out of my depth, would apreciate a little more assistance
Thanks jason.