SQL dbase errors after installation

[jenk]

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

[Jan]

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

[jenk]

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

[Jan]

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