Phoca Forum

Hi there,

I just installed Phoca Gallery in Joomla 1.5 after the successful installation when I try to use it from the front end or back end i gives me following errors.

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

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

Warning: Invalid argument supplied for foreach() in /home/aycdirec/public_html/cityfunclub/administrator/components/com_phocagallery/helpers/phocagallery.php on line 1248

Here is MY URL http://www.cityfunclub.com/ and please click the WALLPAPER from the top navigation.

Can anyone please guide me how to fix this problem.

Regards
bushib

Hi, it seems like your installation procedure didn't create the tables for the Phoca Gallery, so take a look at the install.bak file in the ZIP package and run the queries (which you find in this file) manually in your database, e.g. via phpMyAdmin, see:

please read:

https://www.phoca.cz/documentation/index ... stallation

Hi there,

I have created the tables by running SQL Query.

Now I want to rename the Tables through command.

Can you please tell me how can I do it.

Best Regards
bushib

Why you want to rename the tables ? Did you follow the manual (link I have added here) ... just add instead of #__ your prefix e.g. jos_ and run sql query...

Jan

As you see i have the same problems with 338 and 1248
I opened install.bak file but there isn't examples for these tables:

jos_phocadownload
jos_phocadownload_sections
jos_phocadownload_settings

and i am newbie with MySql tables....

[quote="Jan"]Hi, it seems like your installation procedure didn't create the tables for the Phoca Gallery, so take a look at the install.bak file in the ZIP package and run the queries (which you find in this file) manually in your database, e.g. via phpMyAdmin, see:

please read:

obsolete link removed

new link is:
https://www.phoca.cz/documents/2-phoca-g ... stallation

Jan