Mysqli - error files dialog

[jciconsult]

This message appears 3 times.
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /home/jcic8210/public_html/jacobsonconsulting.com/jver316/libraries/joomla/database/database/mysqli.php on line 305

[Jan]

Hi, enable debug mode to get info from the database, check if you server does support mysqli, maybe you should switch to mysql

Jan

[jciconsult]

I reset the site to mysql and tested that the site still works but the files display still gives
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/jcic8210/public_html/jacobsonconsulting.com/jver316/libraries/joomla/database/database/mysql.php on line 282

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

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

[jciconsult]

The debug listing is available on my server at this link
http://www.jacobsonconsulting.biz/jcius ... g_info.pdf

[Jan]

In in your database, the userid is missing, it seems, while installing Phoca Download 2 first stable version, it was not clicked on install but on upgrade. Search more info about this as it is explained in this forum many times (in short see install.sql.bak file and run the alter table sql query to add the missing userid column)

Jan

[sina_box]

hi
i had the same problem in joomla 1.7 but it solved by a guide in phoca site with solving install problems . now I am working with Joomla 2.5 , I have the same problem but it's not going to be solved by the same way !!!
would you please help me ?
thank you all

[wolfsauge]

Hi everybody,
I am struggling with the Joomla migration from 1.5. to 2.5
I used to use Remository, but uninstalled it because there is no version for J2.5. Then installed Phoca Download on the J1.5 installation and upgraded the whole thing to J2.5
And this is what did not work:
On the files page: Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in .../www/www/jupgrade/libraries/joomla/database/database/mysqli.php on line 263
same page, batch processing: Warning: Invalid argument supplied for foreach() in .../www/www/jupgrade/administrator/components/com_phocadownload/helpers/phocadownload.php on line 19
same on the category page
The link to the download section in the main menu does not work, too:
500 - View nicht gefunden [Name, Typ, Präfix]: section, html, phocadownloadView

Is there a simple solution?
Since I have just a couple of download files a clean new installation seems more promising than go on struggling what went wrong - or would I have to face the same error messages?
Any idea?
Thanks for any tip!
Greetings
wolfsauge

[Jan]

Hi, enable debug mode of Joomla! which tells you more.

Jan

[wolfsauge]

Has already been enabled. Thanks anyway!

[Jan]

Hmm, then database should display some SQL error message