MySQL error in Files section

[baseliner]

Hi,

I'm using Joomla 1.6.1 stable with Phoca Download 2.0.1. I'm getting the following error when I go to the Files section while logged in as admin:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /<path_to_site>/libraries/joomla/database/database/mysql.php on line 317

And I can't see any file in the Files section anymore.

This started after I enabled user uploads and uploaded a non-authorized file as a non-admin user.

Hope someone can help! Thanks!

[Jan]

Hi, enable debug mode to get more information about this problem - search other similar posts where you can find more information.

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

[baseliner]

Thanks Jan. Looks like it was a problem with the upgrade from 2.0.0 RC2 to 2.0.1. I did an Install instead of an Upgrade and that took care of the issue. I didn't have much data yet so it was fine.

[Jan]

Ok