Phoca Forum

I just updated to the most current version 2.0.0. When I click on files I get these lines:

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/.../public_html/.../libraries/joomla/database/database/mysqli.php on line 345

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/.../public_html/.../libraries/joomla/database/database/mysqli.php on line 345

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in/home/.../public_html/.../libraries/joomla/database/database/mysqli.php on line 345

Thanks!!

Hello all
I also got same error when i updated to version 2.0.0 for joomla 1.6
getting same error when going to backend file list
As i was in the start of my project, i did full reinstall of this version and things are working ok now,
but wish to know, what caused this problem to avoid this thing in future.
BTW thanx developers for this very useful component.

Regards

Hi, enable debug mode to see the error.

Mostly there is a problem with missing table userid - this can be added manually (see this forum, there is a guide for this)

There is no upgrade version - Phoca Download 2.0.0 Stable is first version. So the Upgrade function does not work - you need to install the Phoca Download 2.0.0 Stable, not upgrade. If you run some development version (RC, beta, etc.) then you need to run the ALTER TABLE (see install.sql.bak file in ZIP) to add the missing column "userid"

Jan