FILES : Warning: mysql_num_rows()

Phoca Documentation - creating documentation in Joomla! CMS
dounne
Phoca Member
Phoca Member
Posts: 19
Joined: 12 Jun 2011, 16:37

FILES : Warning: mysql_num_rows()

Post by dounne » 24 Jun 2011, 15:29

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 ! :twisted:

dounne
Phoca Member
Phoca Member
Posts: 19
Joined: 12 Jun 2011, 16:37

Re: FILES : Warning: mysql_num_rows()

Post by dounne » 26 Jun 2011, 15:34

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 :D
(viewtopic.php?f=31&t=14432&p=58197#p58197)

Post Reply