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