List of files is empty

[ecolora]

I have files in phoca download on my site. Here is example:

http://ecolora.com/index.php/programmy/ ... -joomla-15

But when i entered the admin page -> phoca download -> files i did not see any files. The list of files is empty. Why?

Joomla 1.6.
Phoca download 2.0.1.

[Jan]

Hi, enable debug mode and php error reporting to see if you will not get some error messge:

https://www.phoca.cz/documents/16-joomla ... rs-on-site
Jan

[jenhol]

Hi, I´m experiencing the same problem, but I don´t understand the solution given in the answer?

PD 2.0.1
Joomla 1.6.5

[Jan]

Hi, what exactl do you not understand? If you are not able to enable debug mode in your administration or enable php error reporting on your webhosting, you need to ask your webhosting provider

Jan

[jenhol]

Hi again, I turned the debug and display errors on, and now I´ve found what the problem is - the missing column in the database table.

My bad...

Problem solved - thx!

[grendizer71]

Hi to all.
I've got the same problem, can someone tell me what is the missing column in DB table? And what's the way to solve it? maybe using MyPHPadmin or using a script?

in my case, with the error lof enabled, the warning I have is "mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/vhosts/comunedimassafra.gov.it/httpdocs/libraries/joomla/database/database/mysql.php on line 282

I'm no so sure that the problem is into the missing column... anyway...

I hope in an answer... bye and tnx in advance.

[ecolora]

I got the same error message.

[Jan]

Hi, enable debug mode to see the error produced by database.

Jan

[ecolora]

Good day. Error message is:

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

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

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

[grendizer71]

in my case, as wrote, the warning I have is

"mysql_num_rows() expects parameter 1 to be resource, boolean given in /var/www/vhosts/comunedimassafra.gov.it/httpdocs/libraries/joomla/database/database/mysql.php on line 282"

Essentially the same one that ecolora has.

I've looking into the code, at line 282, and this is the result:

Code: Select all

public function getNumRows($cursor = null)
	{
		return mysql_num_rows($cursor ? $cursor : $this->cursor);
	}

Any ideas?