Phoca Forum

Posted: **03 Feb 2012, 16:36**

Hi

I updated Joomla from 1.7.4 to 2.5.1. Frontend ist working fine, but when I access the files in the backend, the following error shows up, and no items are listed:

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/xxx/public_html/libraries/joomla/database/database/mysql.php on line 287

I have Phoca Download 2.1.4 installed, no Plugins.

Hope someone can help me.

Posted: **04 Feb 2012, 21:27**

Hi, enable debug mode to get more info about the problem in your database:

https://www.phoca.cz/documents/16-joomla ... ent-errors

https://www.phoca.cz/documents/50-phoca/ ... -joomla-17

Posted: **06 Feb 2012, 13:21**

Perfect found the error. It was

Code: Select all

Unknown column 'a.userid' in 'on clause' SQL=...

so I run the following SQL statement:

Code: Select all

ALTER TABLE `joom_phocadownload` ADD   `userid` int(11) NOT NULL default '0' AFTER `description` ;

and problem was solved. Thanks.

Posted: **09 Feb 2012, 06:39**

Yes this is a common problem when updating Phoca Download. There are many threads about it!

Phoca Forum

Error after Update to Joomla 2.5

Error after Update to Joomla 2.5

Re: Error after Update to Joomla 2.5

Re: Error after Update to Joomla 2.5

Re: Error after Update to Joomla 2.5