Page 1 of 1

MySQL error in Files section

Posted: 25 Jul 2011, 11:28
by 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!

Re: MySQL error in Files section

Posted: 25 Jul 2011, 17:26
by 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

Re: MySQL error in Files section

Posted: 26 Jul 2011, 04:12
by 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.

Re: MySQL error in Files section

Posted: 27 Jul 2011, 00:39
by Jan
Ok