Erreur 1064

Erreur 1064 - SQL/NoSQL - Programmation

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 ?

Reply

Marsh Posté le 04-04-2010 à 00:23:23   

Reply

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);

Reply

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  
 
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


---------------
http://www.aideinfo.com/  Whois adresses IP/domaines le plus évolué !!  FAQ Free Mobile
Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed