Phoca Forum

Hi there,

I just installed Phocadownload.

I have created the tables through SQL query successfully.

When I use the Admin Panle of PHoca Gallery it gives me the 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: array_merge() [function.array-merge]: Argument #2 is not an array in /home/aycdirec/public_html/cityfunclub/administrator/components/com_phocadownload/helpers/phocadownload.php on line 22

Warning: Invalid argument supplied for foreach() in /home/aycdirec/public_html/cityfunclub/libraries/joomla/html/html/select.php on line 68"

I want to know that how to fix these errors.

Best Regards
bushib

hi, the same as by phoca gallery, ... tables are not created in your database... but before try to see your database and php versions, it seem like they are obsolete ???

Jan

Hi there,

As I mentioned before I renamed the table names and created the Tables by running SQL query.

php version 5.2.6
mysql version 5.0.45

I want to know that how to fix the errors.

Regards
bushib

This queries are displayed if Phoca cannot acces the database (mostly in case the tables are not created or the names of these tables are not correct ... e.g. you have jos_ prefix and the tables ave #__ this prefix)

Jan

Hi,

I just checked the table names and they are as follows.

jos_phocadownload
jos_phocadownload_sections
jos_phocadownload_settings

Please help how to fix this issue.

Regard
bushib

do other tables have prefix jos, are all columns ok ?

Hi there,

Yes the tables have prefixes jos and all column names are okay.

These are the table names in the database.

jos_phocadownload
jos_phocadownload_sections
jos_phocadownload_settings

Regards
bushib

so please let me know e.g. screenshot of phpmyadmin (ot the tables)... I must take a look at it

Jan

Hi there,

Please find attached the image.

Regards
bushib

only what can I do is to see it live

Jan