Tweet
J'ai installé Phoca Download 2.1.9, pour un site hébergé sur OVH et l'installation s'est déroulée normalement.
Mais lorsque je tente de créer des dossiers dans PD, j'ai les messages d'erreur :
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /homez.59/uncafede/www/chorale/libraries/joomla/database/database/mysqli.php on line 263
ET
Warning: Invalid argument supplied for foreach() in /homez.59/uncafede/www/chorale/administrator/components/com_phocadownload/helpers/phocadownload.php on line 19
Dans l'espace USERS :
Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc LIMIT 0, 20 Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc
Ce qui est d'autant plus surprenant que j'ai déjà installé ce composant sur d'autres sites, chez d'autres hébergeurs, sans aucun problème…
Mais lorsque je tente de créer des dossiers dans PD, j'ai les messages d'erreur :
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in /homez.59/uncafede/www/chorale/libraries/joomla/database/database/mysqli.php on line 263
ET
Warning: Invalid argument supplied for foreach() in /homez.59/uncafede/www/chorale/administrator/components/com_phocadownload/helpers/phocadownload.php on line 19
Dans l'espace USERS :
Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc LIMIT 0, 20 Table '694336-1.jom_phocadownload' doesn't exist SQL=SELECT a.*,f.id as file_id,cc.id as category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,uc.name AS editor,fa.countfaid,fn.countfnid FROM jom_users AS a LEFT JOIN jom_phocadownload AS f ON f.owner_id = a.id LEFT JOIN jom_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN jom_users AS ua ON ua.id=f.owner_id LEFT JOIN jom_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM jom_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 jom_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 uc.username asc
Ce qui est d'autant plus surprenant que j'ai déjà installé ce composant sur d'autres sites, chez d'autres hébergeurs, sans aucun problème…
Commentaire