Phoca Forum

Hi,

I have a new install of phoca 2.0.1 on joomla 1.5.7. I was required to manually create the database tables, which I did. Now I get the following error messages in Control Panel under images and other sections :

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

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

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

Please can anyone provide any advice to resolve this. I am a sql dbase newbie and have no idea what this means.

Thanks

Jen

The tables are still not here or their names are not correct, see the tables names in phpMyAdmin and let me know them .... (prefix of these tables)

Jan

the prefix is ij15

as when I checked Joomla, administrator, system info it reported this...

$dbprefix 'ij15_'

and all the other databases I have use this prefix.

These are the databases:

ij15_phocagallery
ij15_phocagallery_categories
ij15_phocagallery_comments
ij15_phocagallery_user_category
ij15_phocagallery_votes
ij15_phocagallery_votes_statistics

I hope this is the information you require,

Thanks
Jen

so if all other tables has the prefix ij15_ and all Phoca Galleries tables are created, then you should not get such error ...