stephan
316583d108
This commit introduces comprehensive tracing functionality to the account management flow by adding calls to `fxTraceCompte` and `fxTraceCompteRedirect` at key points in the login and routing processes. The changes improve the tracking of user actions and session states, facilitating better debugging and monitoring of account-related activities. Additionally, the promoteur hub event retrieval function is updated to include tracing, enhancing visibility into hub interactions. These updates aim to improve maintainability and user experience in the account management system.
23 lines
1.1 KiB
SQL
23 lines
1.1 KiB
SQL
-- MSIN-diag-lite — 3 requêtes seulement (si le script complet gèle Navicat)
|
|
-- Exécuter UNE requête à la fois (F5 sur la sélection), noter AVANT puis APRÈS.
|
|
|
|
SET @com_login = 'stephan@progiweb.ca';
|
|
SELECT @com_id := com_id FROM inscriptions_comptes WHERE com_login = @com_login LIMIT 1;
|
|
|
|
-- ========== REQUÊTE 1 — Accès V2 (cause routage hub) ==========
|
|
SELECT com_id, COUNT(*) AS nb, GROUP_CONCAT(eve_id ORDER BY eve_id) AS eve_ids
|
|
FROM inscriptions_eve_acces
|
|
WHERE ea_statut = 'actif'
|
|
AND (ea_expires_at IS NULL OR ea_expires_at > NOW())
|
|
GROUP BY com_id;
|
|
|
|
-- ========== REQUÊTE 2 — Taille promoteur legacy (cause lenteur hub) ==========
|
|
SELECT com_id, com_login, LENGTH(com_eve_promoteur) AS len_champ
|
|
FROM inscriptions_comptes
|
|
WHERE com_id = @com_id;
|
|
|
|
-- ========== REQUÊTE 3 — Page hub + variable legacy ==========
|
|
SELECT 'page_hub' AS k, pag_actif AS v FROM inscriptions_pages WHERE pag_code = 'compte_promoteur_hub'
|
|
UNION ALL
|
|
SELECT 'legacy_var', IFNULL((SELECT var_valeur FROM variables WHERE var_nom = 'promoteur_legacy_actif' LIMIT 1), 'ABSENT');
|