Erreur 1064 - SQL/NoSQL - Programmation
Marsh Posté le 04-04-2010 à 00:31:24
la ligne 463 :
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
Marsh Posté le 05-04-2010 à 10:47:32
Déjà, mets ton code dans les balises ad hoc, c'est difficilement lisible.
Ensuite, au lieu de chercher à enlever les traces d'humidité de ton mur, trouve d'abord la fuite d'eau. En l'occurrence, la fuite vient des erreurs que tu as avant.
Citation : Warning: Missing argument 1 for PresencesController::index() in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 49 |
Marsh Posté le 04-04-2010 à 00:23:23
Bonjour,
j'essaye de finaliser l'installation d'une application et j'ai le message suivant :
Warning: Missing argument 1 for PresencesController::index() in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 49
Notice: Undefined variable: agent_id in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 56
Notice: Undefined variable: agent_id in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 58
Query: SELECT `Agent`.`prenom`, `Agent`.`nom` FROM `agents` AS `Agent` LEFT JOIN `situations` AS `Situation` ON (`Agent`.`situation_id` = `Situation`.`id`) LEFT JOIN `statuts` AS `Statut` ON (`Agent`.`statut_id` = `Statut`.`id`) LEFT JOIN `roles` AS `Role` ON (`Agent`.`role_id` = `Role`.`id`) WHERE `Agent`.`id`=
Warning: SQL Error: 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 '' at line 1 in /home/mfrguade/public_html/97115/gtt/cake/libs/model/datasources/dbo_source.php on line 463
Notice: Undefined variable: agent_id in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 83
Query: SELECT `Presence`.`id`, `Presence`.`agent_id`, `Presence`.`service_id`, `Presence`.`date`, `Presence`.`heureDebut`, `Presence`.`heureFin`, `Presence`.`nbHeures`, `Presence`.`nbHeuresSup` FROM `presences` AS `Presence` WHERE date = '2010-03-29' and agent_id = and service_id = 1
Warning: SQL Error: 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 'and service_id = 1' at line 1 in /home/mfrguade/public_html/97115/gtt/cake/libs/model/datasources/dbo_source.php on line 463
Notice: Undefined variable: agent_id in /home/mfrguade/public_html/97115/gtt/app/controllers/presences_controller.php on line 86
Query: SELECT `Agentsemainetype`.`id`, `Agentsemainetype`.`agent_id`, `Agentsemainetype`.`semainestype_id`, `Agentsemainetype`.`service_id`, `Agentsemainetype`.`dateDebut`, `Agentsemainetype`.`dateFin` FROM `agentsemainetypes` AS `Agentsemainetype` WHERE agent_id = and service_id = 1 and (dateDebut <= '2010-03-29') and ('2010-03-29' <= dateFin)
Warning: SQL Error: 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 'and service_id = 1 and (dateDebut <= '2010-03-29') and ('2010-03-29' <= dateFin' at line 1 in /home/mfrguade/public_html/97115/gtt/cake/libs/model/datasources/dbo_source.php on line 463
Quelq'un pourrait m'aider ?