Problème avec Phoca

[hugoprod]

bon soir,
Je vous contact car j'ai un message d'erreur avec phoca dans la partie UPLOAD. Voici une copie:

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 fs6n4_users AS a LEFT JOIN fs6n4_phocadownload AS f ON f.owner_id = a.id LEFT JOIN fs6n4_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN fs6n4_users AS ua ON ua.id=f.owner_id LEFT JOIN fs6n4_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM fs6n4_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 fs6n4_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 username asc, a.id asc 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 fs6n4_users AS a LEFT JOIN fs6n4_phocadownload AS f ON f.owner_id = a.id LEFT JOIN fs6n4_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN fs6n4_users AS ua ON ua.id=f.owner_id LEFT JOIN fs6n4_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM fs6n4_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 fs6n4_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 username asc, a.id asc LIMIT 0, 20 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 fs6n4_users AS a LEFT JOIN fs6n4_phocadownload AS f ON f.owner_id = a.id LEFT JOIN fs6n4_phocadownload_categories AS cc ON cc.id = f.catid LEFT JOIN fs6n4_users AS ua ON ua.id=f.owner_id LEFT JOIN fs6n4_users AS uc ON uc.id=f.checked_out LEFT JOIN (SELECT fa.owner_id, fa.id, count(*) AS countfaid FROM fs6n4_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 fs6n4_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 username asc, a.id asc

Mes utilisateurs ne peuvent pas uploader est ce normal?
Merci de votre aide.

[jisse03]

Re : Problème avec Phoca

Bonjour,

La première partie du message, avant SQL = donne la raison de l'erreur en général.

Et si la raison de l'erreur n'est pas indiquée, exécuter la même requête dans phpMyAdmin donnera aussi les indications.

[hugoprod]

Re : Problème avec Phoca

désolé je ne comprend pas...

[jisse03]

Re : Problème avec Phoca

Le message d'erreur ne commence certainement pas par SQL=, mais par un truc du genre "you have an error in..." c'ets cette partie là qui est intéressante pour ne pas avoir à décortiquer la requête point par point.