[*]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/htdocs/www.miosito.it/libraries/joomla/databas ... /mysql.php on line 344[*]
I followed the guide but does not work. Version 1.3.7
I tried it in debug mode:
JDatabaseMySQL::query: 1054 - Unknown column 'a.ordering' in 'order clause' SQL=SELECT a.*, fa.countfaid, fn.countfnid, 0 AS checked_out FROM jos_users AS a LEFT JOIN jos_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jos_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jos_phocadownload_sections AS s ON s.id = f.sectionid LEFT JOIN jos_groups AS g ON g.id = f.access LEFT JOIN jos_users AS aa ON aa.id = f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jos_phocadownload AS fa WHERE fa.approved = 1 GROUP BY fa.owner_id) AS fa ON a.id = fa.owner_id LEFT JOIN (SELECT fn.owner_id, fn.id, count(*) AS countfnid FROM jos_phocadownload AS fn WHERE fn.approved = 0 GROUP BY fn.owner_id) AS fn ON a.id = fn.owner_id WHERE a.id > 0 AND (fa.countfaid > 0 OR fn.countfnid > 0) GROUP by a.id ORDER BY a.ordering , a.id LIMIT 0, 20
