Galette

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