Actions
Anomalie #841
ferméGalette v0.8. Erreur de syntaxe SQL pour un simple adhérent responsable d'un groupe.
Début:
29/07/2014
Echéance:
% réalisé:
100%
Temps estimé:
Version utilisée:
Vote:
Description
Lorsqu'un simple adhérent responsable d'un groupe essaie d'afficher la liste des adhérents ou celle des groupes, cela déclenche les erreurs logs suivantes :
::1 - 2014-07-29 08:43:03 - 3 - Query error: SELECT DISTINCT count(DISTINCT a.id_adh) AS `count`, `p`.*, `gr`. AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` INNER JOIN `galette_groups_members` AS `gr` ON `a`.`id_adh`=`gr`.`id_adh` INNER JOIN `galette_groups_managers` AS `m` ON `gr`.`id_group`=`m`.`id_group` WHERE m.id_adh = '' exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT DISTINCT...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT DISTINCT...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT DISTINCT...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(770): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(725): Galette\Repository\Members->_proceedCount(Object(Zend\Db\Sql\Select)) #5 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(224): Galette\Repository\Members->_buildSelect(4, NULL, false, true) #6 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(181): Galette\Repository\Members->getMembersList(true, NULL, true, false, true, true) #7 C:\xampp183\htdocs\galette08dev\gestion_adherents.php(264): Galette\Repository\Members->getManagedMembersList(true) #8 {main} ::1 - 2014-07-29 08:43:03 - 4 - Cannot count members | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1 ::1 - 2014-07-29 08:43:03 - 3 - Query error: SELECT DISTINCT `a`.*, `p`.*, `gr`. AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` INNER JOIN `galette_groups_members` AS `gr` ON `a`.`id_adh`=`gr`.`id_adh` INNER JOIN `galette_groups_managers` AS `m` ON `gr`.`id_group`=`m`.`id_group` WHERE m.id_adh = '' ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0 exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT DISTINCT...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT DISTINCT...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT DISTINCT...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(231): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(181): Galette\Repository\Members->getMembersList(true, NULL, true, false, true, true) #5 C:\xampp183\htdocs\galette08dev\gestion_adherents.php(264): Galette\Repository\Members->getManagedMembersList(true) #6 {main} ::1 - 2014-07-29 08:43:03 - 4 - Cannot list members | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1 ::1 - 2014-07-29 08:43:03 - 3 - Query error: SELECT `a`.*, count(b.id_group) AS `members`, `c`. AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON `a`.`id_group`=`b`.`id_group` INNER JOIN `galette_groups_managers` AS `c` ON `a`.`id_group`=`c`.`id_group` WHERE c.id_adh = 1 GROUP BY `a`.`id_group`, `a`.`group_name`, `a`.`creation_date`, `a`.`parent_group` ORDER BY `a`.`group_name` ASC exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON ' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT `a`.*, c...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT `a`.*, c...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT `a`.*, c...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Groups.php(138): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\gestion_adherents.php(268): Galette\Repository\Groups->getList() #5 {main} ::1 - 2014-07-29 08:43:03 - 4 - Cannot list groups | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON ' at line 1 ::1 - 2014-07-29 08:43:16 - 3 - Query error: SELECT `a`.*, count(b.id_group) AS `members`, `c`. AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON `a`.`id_group`=`b`.`id_group` INNER JOIN `galette_groups_managers` AS `c` ON `a`.`id_group`=`c`.`id_group` WHERE c.id_adh = 1 GROUP BY `a`.`id_group`, `a`.`group_name`, `a`.`creation_date`, `a`.`parent_group` ORDER BY `a`.`group_name` ASC exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON ' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT `a`.*, c...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT `a`.*, c...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT `a`.*, c...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Groups.php(138): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\gestion_groupes.php(161): Galette\Repository\Groups->getList() #5 {main} ::1 - 2014-07-29 08:43:16 - 4 - Cannot list groups | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS `` FROM `galette_groups` AS `a` LEFT JOIN `galette_groups_members` AS `b` ON ' at line 1
Actions
#1
Mis à jour par Johan Cwiklinski il y a plus de 9 ans
- Assigné à mis à Johan Cwiklinski
- Catégorie mis à Core
Actions
#2
Mis à jour par Johan Cwiklinski il y a plus de 9 ans
- % réalisé changé de 0 à 100
- Statut changé de Nouveau à Résolu
Appliqué par commit a57d20be2fc9e5b9c78ac80026876d399fa232ad.
Actions
#4
Mis à jour par Roland Telle il y a plus de 9 ans
Une partie seulement est traitée.
Lorsqu'un simple adhérent responsable d'un groupe se connecte et affiche la liste des adhérents, le nombre des adhérents n'est pas inscrit et la liste est vide. Cf. logs de Galette :
::1 - 2014-07-30 06:11:44 - 3 - Query error: SELECT DISTINCT count(DISTINCT a.id_adh) AS `count`, `p`.*, `gr`. AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` INNER JOIN `galette_groups_members` AS `gr` ON `a`.`id_adh`=`gr`.`id_adh` INNER JOIN `galette_groups_managers` AS `m` ON `gr`.`id_group`=`m`.`id_group` WHERE m.id_adh = '' exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT DISTINCT...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT DISTINCT...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT DISTINCT...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(770): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(725): Galette\Repository\Members->_proceedCount(Object(Zend\Db\Sql\Select)) #5 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(224): Galette\Repository\Members->_buildSelect(4, NULL, false, true) #6 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(181): Galette\Repository\Members->getMembersList(true, NULL, true, false, true, true) #7 C:\xampp183\htdocs\galette08dev\gestion_adherents.php(264): Galette\Repository\Members->getManagedMembersList(true) #8 {main} ::1 - 2014-07-30 06:11:44 - 4 - Cannot count members | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1 ::1 - 2014-07-30 06:11:44 - 3 - Query error: SELECT DISTINCT `a`.*, `p`.*, `gr`. AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` AS `p` ON `a`.`id_statut`=`p`.`id_statut` INNER JOIN `galette_groups_members` AS `gr` ON `a`.`id_adh`=`gr`.`id_adh` INNER JOIN `galette_groups_managers` AS `m` ON `gr`.`id_group`=`m`.`id_group` WHERE m.id_adh = '' ORDER BY `nom_adh` ASC, `prenom_adh` ASC LIMIT 20 OFFSET 0 exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1' in C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php:386 Stack trace: #0 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Driver\Pdo\Connection.php(386): PDO->query('SELECT DISTINCT...') #1 C:\xampp183\htdocs\galette08dev\includes\Zend-2.2.5\Zend\Db\Adapter\Adapter.php(189): Zend\Db\Adapter\Driver\Pdo\Connection->execute('SELECT DISTINCT...') #2 C:\xampp183\htdocs\galette08dev\lib\Galette\Core\Db.php(771): Zend\Db\Adapter\Adapter->query('SELECT DISTINCT...', 'execute') #3 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(231): Galette\Core\Db->execute(Object(Zend\Db\Sql\Select)) #4 C:\xampp183\htdocs\galette08dev\lib\Galette\Repository\Members.php(181): Galette\Repository\Members->getMembersList(true, NULL, true, false, true, true) #5 C:\xampp183\htdocs\galette08dev\gestion_adherents.php(264): Galette\Repository\Members->getManagedMembersList(true) #6 {main} ::1 - 2014-07-30 06:11:44 - 4 - Cannot list members | SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS ``, `m`. AS `` FROM `galette_adherents` AS `a` INNER JOIN `galette_statuts` A' at line 1
Actions
#5
Mis à jour par Johan Cwiklinski il y a plus de 9 ans
- Statut changé de Fermé à In Progress
Arf, je n'ai pas constaté d'erreurs lors de mes tests (rapides, j'en conviens). J'essaie de reproduire pour corriger.
Actions
#6
Mis à jour par Johan Cwiklinski il y a plus de 9 ans
- Statut changé de In Progress à Résolu
Appliqué par commit 92c6d9794bf5ff319fee15be4c7230d7cdcecad9.
Actions
#7
Mis à jour par Johan Cwiklinski il y a plus de 9 ans
- Statut changé de Résolu à Fermé
Cette fois, tous les problèmes doivent être résolus :)
Actions