Phoca Gallery Error (Please Help)

[bushib]

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

[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:

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

[bushib]

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

[Jan]

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

[Beata]

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

[Jan]

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

Jan