Phoca Forum

Hi,
Just upgraded to 2.1.1 from (I think) 2.0.x (the previous 1.6 version) and everything seems to work ok except when I go to files it just displays the following error three times (I had three categories active if that is a clue)

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

and no files are listed.
I can still add files though and they show up ok in the plugin etc and work on the frontend, just no files listed in the backend. The categories list is ok and can be edited as normal.
It would be quite nice to fix this without having to uninistall and reinstall as that would be a lot of recreating of links to do...thoughts anyone?
Joomla version 1.7.0 by the way.
RogerCO

Apologies - I did search before posting, but nothing came up. Now I find by browsing back through this forum the answer.
v2.1 seems to have added a new column in the database table jos_phocadownload and for some reason this is not captured by the upgrade script.
The answer (assuming you have something like phpMyAdmin access to your database) is to run this query on the database:

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

This will add the necessary additional column and everything springs back to life.
Should really be part of the upgrade script but problem solved now.
RogerCO

Ok.

Kind regards,
Benno