error on installing in 1.7

[Huckerby3]

Hi,

Just tried to install phoca download 2.1.6 on Joomla.1.7

All appeared to work, until I clicked on 'files' and got the following error message:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/epiphany/public_html/napc/libraries/joomla/database/database/mysql.php on line 282

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/epiphany/public_html/napc/libraries/joomla/database/database/mysql.php on line 282

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/epiphany/public_html/napc/libraries/joomla/database/database/mysql.php on line 282

When I turn Joomla debuggin on, I get the following message when clicking on 'Files':

Joomla!
500 - An error has occurred.

JDatabaseMySQL::query: 1146 - Table 'epiphany_napc.j17_phocadownload' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `j17_phocadownload` AS a LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN j17_users AS uua ON uua.id=a.userid LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN j17_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc

Please help! What have I done wrong?

Many thanks

Luke

[Huckerby3]

Aplogies - the answer to my problem is here: https://www.phoca.cz/documents/17-phoca- ... em-solving

I needed to manually install database tables, as after an upgrade on the core joomla, I'd renamed my table suffix.

[Jan]

Ok