Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1504]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1505]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1506]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1507]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1508]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1509]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1512]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1516]
Notice (8): Undefined offset: 0 [APP/Controller/PagesController.php, line 1521]
Notice (8): Undefined index: nom_duree [APP/Controller/PagesController.php, line 1558]
Notice (8): Undefined index: id_package [APP/Controller/PagesController.php, line 1565]
Errors

Database Error

Error: 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 'and pt.package_tarif_type_id = 2 and sp.datedepart > NOW() + INTERVAL 7 DAY ORDE' at line 3

SQL Query: SELECT sp.id, sp.datedepart, sp.dateretour, fs.prixadulte, fs.prixenfant, fs.allotement, fs.reserver, al.name, pt.prixdouble, pt.prixsingle, pt.prixtriple, pt.prixquadriple, pt.prixquintuple,pt.prixsextuple, fs.prixadulte, cty1.name as ville_depart, cty2.name as ville_arrivee FROM start_packages sp, flight_starts fs, flights fl, airlines al, package_tarifs pt, cities cty1, cities cty2 WHERE sp.flight_start_id = fs.id and fs.flight_id = fl.id and fl.airline_id = al.id and fl.city_id = cty1.id and fl.city_id1 = cty2.id and sp.id = pt.start_package_id and sp.etat = 1 and sp.package_id = and pt.package_tarif_type_id = 2 and sp.datedepart > NOW() + INTERVAL 7 DAY ORDER BY sp.datedepart ASC

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace