Bonjour, j’ai un petit souci assez gênant. J’ai un utilisateur qui a tous les droits sur le module projets mais dans :
projet/list.php?leftmenu=projects
La liste est vide, il faut que je supprime la ‘x’ pour que la liste apparaisse… Et dès que je mets des critères… La liste est à nouveau vide.
Par contre pour un user ‘admin’ ça fonctionne parfaitement (c’est probablement un problème de droits donc) et je n’arrive pas à trouver où je pourrais avoir fait une erreur… Je précise que j’utilise le module multi sociétés.Merci d’avance pour vos suggestions !
Bonjour,
C’est étonnant, tu pourrais nous envoyer une capture d’écran ?
Est-ce que tu as quelque chose de complété sur cet écran ?
Idéalement, il faudrait que tu actives le module Barre de débogage et que tu copies ce que tu trouves dans « Database », notamment les lignes :
SELECT COUNT(*) as nbtotalofrecords FROM z2jh_projet as p LEFT JOIN z2jh_societe as s on p.fk_soc = s.rowid LEFT JOIN z2jh_c_country as country on country.rowid = s.fk_pays LEFT JOIN z2jh_c_lead_status as cls on p.fk_opp_status = cls.rowid LEFT JOIN z2jh_user AS u ON p.fk_user_creat = u.rowid WHERE p.entity IN (1) AND p.fk_statut IN (0,1)0.49
SELECT p.rowid as id, p.ref, p.title, p.fk_statut as status, cls.position, (CASE WHEN p.fk_opp_status IS NULL THEN 0 ELSE p.fk_opp_status END) as fk_opp_status, p.public, p.fk_user_creat, p.datec as date_creation, p.dateo as date_start, p.datee as date_end, p.opp_amount, p.opp_percent, (p.opp_amount * p.opp_percent / 100) as opp_weighted_amount, p.tms as date_modification, p.budget_amount, p.usage_opportunity, p.usage_task, p.usage_bill_time, p.usage_organize_event, p.email_msgid, p.import_key, p.accept_conference_suggestions, p.accept_booth_suggestions, p.price_registration, p.price_booth, s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.code_client, country.code as country_code, cls.code as opp_status_code, u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender FROM z2jh_projet as p LEFT JOIN z2jh_societe as s on p.fk_soc = s.rowid LEFT JOIN z2jh_c_country as country on country.rowid = s.fk_pays LEFT JOIN z2jh_c_lead_status as cls on p.fk_opp_status = cls.rowid LEFT JOIN z2jh_user AS u ON p.fk_user_creat = u.rowid WHERE p.entity IN (1) AND p.fk_statut IN (0,1) ORDER BY p.ref ASC LIMIT 26 0.63
Redis-nous !
En pré-rempli, j’ai ‘brouillon’ et ‘ouvert’ dans le champ Etat et la liste est vide. Si j’efface avec la ‘x’, la liste complète apparait. Dès que je remplis un champ (quel qu’il soit) et même s’il y a des enregistrements qui correspondent, la liste est vide. alors que ce n’est pas le cas avec un utilisateur qui est administrateur multi-societe (même un administrateur de l’entité a leur même souci.
D’accord, c’est bien ce que j’avais en tête.
Donc il faudrait que tu fasses ça pour qu’on voit ce qui coince :
J’ai activé le module et mis les logs dans le fichier. Et là, rien…Y-a-t-il un niveau de logging qu’on puisse modifier ?
Il faut cliquer sur la barre, lors que vous êtes dans les projets, pour ensuite aller sur Database :
Merci, mais module activé, je ne vois pas la barre… (Nginx/PHP-FPM). Il faut ajouter un truc en variable PHP?
C’est ok, je ne l’avais pas activée sur le bon environnement 
Les logs DB ci-dessous
————————————————————————————
SELECT transkey, transvalue FROM llx_overwrite_trans where (lang=‹ fr_FR › OR lang IS NULL) AND entity IN (0, 3) ORDER BY lang DESC0.13
SELECT m.rowid, m.type, m.module, m.fk_menu, m.fk_mainmenu, m.fk_leftmenu, m.url, m.titre, m.prefix, m.langs, m.perms, m.enabled, m.target, m.mainmenu, m.leftmenu, m.position FROM llx_menu as m WHERE m.entity IN (0,3) AND m.menu_handler IN (‹ eldy ›,‹ all ›) AND m.usertype IN (0,2) ORDER BY m.type DESC, m.position, m.rowid0.18
SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ projet › ORDER BY pos0.22
SELECT rowid, label, context, author, color, active, initvalue, movefield, typefield, replacement, compulsory, sizefield, tooltipinfo, formatfield, querydisplay FROM llx_myfield WHERE 1 = 1 AND ( context=‹ › OR context like ‹ %projectlist% › OR context like ‹ %main% › ) AND typefield =3 ORDER BY context, label0.15
SELECT ctc.rowid, ctc.code, ctc.source FROM llx_c_type_contact as ctc WHERE ctc.element = 'project’0.13
SELECT COUNT(*) as nbtotalofrecords FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid LEFT JOIN llx_c_country as country on country.rowid = s.fk_pays LEFT JOIN llx_c_lead_status as cls on p.fk_opp_status = cls.rowid LEFT JOIN llx_user AS u ON p.fk_user_creat = u.rowid WHERE p.entity IN (1,3) AND p.fk_statut IN (0,1)0.7
SELECT p.rowid as id, p.ref, p.title, p.fk_statut as status, p.fk_opp_status, p.public, p.fk_user_creat, p.datec as date_creation, p.dateo as date_start, p.datee as date_end, p.opp_amount, p.opp_percent, (p.opp_amount * p.opp_percent / 100) as opp_weighted_amount, p.tms as date_modification, p.budget_amount, p.usage_opportunity, p.usage_task, p.usage_bill_time, p.usage_organize_event, p.email_msgid, p.import_key, p.accept_conference_suggestions, p.accept_booth_suggestions, p.price_registration, p.price_booth, s.rowid as socid, s.nom as name, s.name_alias as alias, s.email, s.email, s.phone, s.fax, s.address, s.town, s.zip, s.fk_pays, s.client, s.code_client, country.code as country_code, cls.code as opp_status_code, u.login, u.lastname, u.firstname, u.email as user_email, u.statut as user_statut, u.entity, u.photo, u.office_phone, u.office_fax, u.user_mobile, u.job, u.gender , p.entity FROM llx_projet as p LEFT JOIN llx_societe as s on p.fk_soc = s.rowid LEFT JOIN llx_c_country as country on country.rowid = s.fk_pays LEFT JOIN llx_c_lead_status as cls on p.fk_opp_status = cls.rowid LEFT JOIN llx_user AS u ON p.fk_user_creat = u.rowid WHERE p.entity IN (1,3) AND p.fk_statut IN (0,1) ORDER BY p.ref ASC LIMIT 26 0.89
SELECT rowid, title, url, target FROM llx_bookmark WHERE (fk_user = 1 OR fk_user is NULL OR fk_user = 0) AND entity IN (3) ORDER BY position0.17
SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ entity › ORDER BY pos0.17
SELECT rowid, code, label FROM llx_c_country WHERE rowid = 10.13
SELECT code_iso, label, unicode FROM llx_c_currencies WHERE active = 1 AND code_iso = 'EUR’0.27
SELECT DISTINCT u.rowid, u.lastname as lastname, u.firstname, u.statut as status, u.login, u.admin, u.entity, u.gender, u.photo FROM llx_user as u WHERE u.rowid IN (SELECT ug.fk_user FROM llx_usergroup_user as ug WHERE ug.entity IN (0,3)) AND u.statut <> 0 ORDER BY u.statut DESC, u.firstname ASC, u.lastname ASC0.82
SELECT sp.rowid, sp.lastname, sp.statut, sp.firstname, sp.poste, sp.email, sp.phone, sp.phone_perso, sp.phone_mobile, sp.town AS contact_town FROM llx_socpeople as sp WHERE sp.entity IN (5,3) AND ((sp.fk_user_creat = 1 AND sp.priv = 1) OR sp.priv = 0) ORDER BY sp.lastname ASC1.68
SELECT u.rowid, u.lastname, u.firstname, u.statut as status, u.login, u.photo, u.gender, u.entity, u.admin FROM llx_user as u WHERE EXISTS (SELECT ug.fk_user FROM llx_usergroup_user as ug WHERE u.rowid = ug.fk_user AND ug.entity IN (0,3)) OR u.entity = 0 AND u.statut <> 0 ORDER BY status DESC, firstname ASC, lastname ASC1.27
SELECT fk_parent as id_parent, rowid as id_son FROM llx_categorie WHERE fk_parent != 0 AND entity IN (1,2,5,3)0.15
SELECT DISTINCT c.rowid, c.label, c.ref_ext, c.description, c.color, c.position, c.fk_parent, c.visible FROM llx_categorie as c WHERE c.entity IN (1,2,5,3) AND c.type = 60.13
SELECT rowid, code, label, percent FROM llx_c_lead_status WHERE active = 1 ORDER BY position0.14
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 142 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.7
SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llx_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IS NOT NULL AND u.rowid = 30 ORDER BY u.entity ASC0.17
SELECT rowid, name, label, type, size, elementtype, fieldunique, fieldrequired, param, pos, alwayseditable, perms, langs, list, printable, totalizable, fielddefault, fieldcomputed, entity, enabled, help, css, cssview, csslist FROM llx_extrafields WHERE elementtype = ‹ user › ORDER BY pos0.35
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 142 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 157 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.63
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 157 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 158 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.4
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 158 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 161 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.39
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 161 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.4
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 162 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.58
SELECT u.rowid, u.lastname, u.firstname, u.employee, u.gender, u.civility as civility_code, u.birth, u.job, u.email, u.email_oauth2, u.personal_email, u.socialnetworks, u.signature, u.office_phone, u.office_fax, u.user_mobile, u.personal_mobile, u.address, u.zip, u.town, u.fk_state as state_id, u.fk_country as country_id, u.admin, u.login, u.note_private, u.note_public, u.pass, u.pass_crypted, u.pass_temp, u.api_key, u.fk_soc, u.fk_socpeople, u.fk_member, u.fk_user, u.ldap_sid, u.fk_user_expense_validator, u.fk_user_holiday_validator, u.statut as status, u.lang, u.entity, u.datec as datec, u.tms as datem, u.datelastlogin as datel, u.datepreviouslogin as datep, u.flagdelsessionsbefore, u.iplastlogin, u.ippreviouslogin, u.datelastpassvalidation, u.datestartvalidity, u.dateendvalidity, u.photo as photo, u.openid as openid, u.accountancy_code_user_general, u.accountancy_code, u.thm, u.tjm, u.salary, u.salaryextra, u.weeklyhours, u.color, u.dateemployment, u.dateemploymentend, u.fk_warehouse, u.ref_ext, u.default_range, u.default_c_exp_tax_cat, u.national_registration_number, u.ref_employee, c.code as country_code, c.label as country, d.code_departement as state_code, d.nom as state, s.label as label_establishment, u.fk_establishment FROM llx_user as u LEFT JOIN llx_c_country as c ON u.fk_country = c.rowid LEFT JOIN llx_c_departements as d ON u.fk_state = d.rowid LEFT JOIN llx_establishment as s ON u.fk_establishment = s.rowid WHERE u.entity IS NOT NULL AND u.rowid = 4 ORDER BY u.entity ASC0.58
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 162 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 163 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.44
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 163 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 164 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.4
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 164 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.42
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 165 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 165 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.4
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 166 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 166 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 167 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.56
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 167 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 168 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 168 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 169 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.42
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 169 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 170 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.56
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 170 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.41
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 171 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.59
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 171 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.4
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 172 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.45
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 172 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.39
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 173 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.43
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 173 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.42
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 174 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.42
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 174 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.43
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 175 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.45
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 175 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.38
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 176 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.48
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 176 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.39
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 177 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.42
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 177 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.43
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, ‹ -1 › as socid, t.statut as statuscontact, t.login, t.photo, t.gender, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_user as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 178 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ internal › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC0.52
SELECT ec.rowid, ec.statut as statuslink, ec.fk_socpeople as id, ec.fk_c_type_contact, t.fk_soc as socid, t.statut as statuscontact, t.civility as civility, t.lastname as lastname, t.firstname, t.email, tc.source, tc.element, tc.code, tc.libelle as type_label FROM llx_c_type_contact as tc, llx_element_contact as ec LEFT JOIN llx_socpeople as t on ec.fk_socpeople = t.rowid WHERE ec.element_id = 178 AND ec.fk_c_type_contact = tc.rowid AND tc.element = ‹ project › AND tc.source = ‹ external › AND tc.active = 1 AND t.statut = 1 ORDER BY t.lastname ASC
N’hésite pas à utiliser " ``` " avant et après ton code, pour un affichage plus pratique sur le forum.
Alors, voilà les conditions qui sont indiqués :
WHERE p.entity IN (1,3) AND p.fk_statut IN (0,1)
Donc ça m’affiche les projets présents dans l’entité 1 et 3 avec un statut brouillon ou actif.
Est-ce que ça correspond pour 1 et 3 ?
Est-ce que ce sont les logs de ton utilisateur « défectueux » ou les tiens ?
Il faut bien regarder ceux de ton utilisateur.
Peux-tu regarder aussi dans la barre de débug, s’il y a quelque chose dans Error handler ?
Merci pour ces précisions.
Alors, 1 & 3 ça matche en ce qui concerne les sociétés. Et oui, par défaut le filtre est posé sur brouillon et actif. Là, c’est une requête qui fonctionne puisque je suis “superadmin multi sociétés”. Par contre la barre de débug ne s’affiche pas sur son profil ? est-ce que j’ai loupé quelque chose ? (Et surtout merci pour ton aide!)
Ah mince, bien vu, c’est sans doute accessible uniquement côté admin, mince…
Dans ce cas, tu peux aller dans les outils de dévelopement (F12 sur Firefox).
Allez ensuite dans Réseau et Requête de ton fichier list.php.
J’aurais besoin de la partie à droite :
Je n’ai pas de requête de type POST mais GET…. Et je ne vois pas l’onglet “requête”
Hmmm ça va complexifier les choses. Il faut bien que l’onglet réseau soit ouvert, puis que tu cliques sur liste de projets.
Est-ce que tu as fait ça ?
Oui bien sûr. Je connais les outils de débogage. Et surtout ma requête est un GET et donc je n’ai rien dans ‘requête"‘…
D’accord, pardon.
Hmmm je commence à bloquer. Il faudrait voir s’il y a quelque chose de spécifique dans les logs. Est-ce que vous auriez ça ?
C’est la première chose que j’ai vérifiée. RIEN ;-( (je viens de faire un mail au créateur du module multisociétés pour voir s’il a déjà rencontré le problème…
Quoi qu’il en soit, merci pour votre disponibilité et vos conseils!
1 « J'aime »
