Re: Problème a l installation de la v2
Date: jeudi 21 février 2008 22:33:11
Bonjour,
après ce problème de résolu, j en un enfin plusieurs mais qui doivent surement être lié. Alors le premier apparait quand je clique sur le bouton "Utilisateur" du Menu "Utilisateur" dans l espace "Admin" voici le message:
[mdb2_error: message="MDB2 Error: syntax error" code=-2 mode=callback callback=displayPearError prefix="" info="_doQuery: [Error message: Could not execute statement] [Last query: PREPARE MDB2_Statement_mysqli_7d653c3688b0078a789fb3275ea862e0 FROM 'SELECT authentication.*, member.subscription AS member_subscription, member.member_num AS member_member_num, instructor.sign AS instructor_sign, member_pool_join.member_pool_id AS member_pool_join_member_pool_id, member_pool_join.member_pool_id AS member_pool_join_member_pool_id, member_pool.name AS member_pool_name FROM authentication LEFT JOIN member AS member ON (member.id=authentication.id) LEFT JOIN instructor AS instructor ON (instructor.id=authentication.id) LEFT JOIN member_pool_join AS member_pool_join ON (member_pool_join.member_id=authentication.id) LEFT JOIN member_pool AS member_pool ON (member_pool.id=member_pool_join.member_pool_id) LEFT JOIN nationality AS nationality ON (nationality.id=authentication.nationality_id) WHERE authentication.last_name LIKE 'AND activated=1 ORDER BY authentication.last_name'] [Native code: 1064] [Native message: 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 'AND activated=1 ORDER BY authentication.last_name'' at line 1] "]
Le second message apparait quand je clique sur le bouton "Qualification" du Menu "Donnée" du Cahier.
[mdb2_error: message="MDB2 Error: syntax error" code=-2 mode=callback callback=displayPearError prefix="" info="_doQuery: [Error message: Could not execute statement] [Last query: PREPARE MDB2_Statement_mysqli_89320049b1009c5027c878aba65bf578 FROM 'SELECT member_qualif.*, authentication.last_name AS authentication_last_name, authentication.first_name AS authentication_first_name, authentication.activated AS authentication_activated, member.subscription AS member_subscription, member.qualif_alert_delay AS member_qualif_alert_delay, qualification.name AS qualification_name, qualification.time_limitation AS qualification_time_limitation, qualification.grant_date_enable AS qualification_grant_date_enable, qualification.ident_value_enable AS qualification_ident_value_enable FROM member_qualif LEFT JOIN authentication AS authentication ON (authentication.id=member_qualif.member_id) LEFT JOIN member AS member ON (member.id=member_qualif.member_id) LEFT JOIN qualification AS qualification ON (qualification.id=member_qualif.qualif_id) WHERE member_id='1''] [Native code: 1064] [Native message: 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 '1''' at line 1] "]
et enfin dernier message d erreur trouver apparait quand je clique sur le bouton "Lister" du menu "Réservation
[mdb2_error: message="MDB2 Error: syntax error" code=-2 mode=callback callback=displayPearError prefix="" info="_doQuery: [Error message: Could not execute statement] [Last query: PREPARE MDB2_Statement_mysqli_56c41a7a60a8bf6571d07ce0de462e2f FROM 'SELECT booking.*, aircraft.id AS aircraft_id, aircraft.callsign AS aircraft_callsign, authentication.first_name AS authentication_first_name, authentication.last_name AS authentication_last_name, instructor.sign AS instructor_sign FROM booking LEFT JOIN aircraft AS aircraft ON (aircraft.id=booking.aircraft_id) LEFT JOIN authentication AS authentication ON (authentication.id=booking.member_id) LEFT JOIN instructor AS instructor ON (instructor.id=booking.instructor_id) WHERE end_date>='2008-02-21 22:16:12' ORDER BY start_date ASC LIMIT 0, 50'] [Native code: 1064] [Native message: 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 '2008-02-21 22:16:12' ORDER BY start_date ASC LIMIT 0, 50'' at line 1] "]
Si quelqu'un passait par la et pourrai me dire d ou vient le problème ....
J ai réinstaller la version 1.3.1 et la version 2 sans modifier les tables et toujours pareil ......