FILES : Warning: mysql_num_rows()

[dounne]

Hi all,

I was using the 2.0.0Rc3 and I have just installed the 2.0.0. Everything is ok ... nearly : when I clikc on Files it shows me an error :

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.765/iimpeds/www/libraries/joomla/database/database/mysql.php on line 317

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.765/iimpeds/www/libraries/joomla/database/database/mysql.php on line 317

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /homez.765/iimpeds/www/libraries/joomla/database/database/mysql.php on line 317

I still can upload files without problems, I can manage the Categories...
Anyone could help me to solve it?

Thanks !

[dounne]

thanks to Chrisd :

OK,
I've done some more research and voilà I think I've got a fix...
My suspicion was correct. Obviously I have updated from 2.0.0 RC3 to the final 2.0.0 version and this has not created the 'userid' field in the 'jos_phocadownload'.

I have run the following SQL statement on my database

Code: Select all
ALTER TABLE `jos_phocadownload` ADD `userid` int(11) NOT NULL Default '0' AFTER `description`



and the error has gone, the file list is shown...

HTH

chrisd

(viewtopic.php?f=31&t=14432&p=58197#p58197)