| #1 | log_error - ERROR: : sql_query: #2 'SELECT `cours`.*, `Join_0`.`Categorie`, `Join_1`.`Nom` AS CatName, `Join_1`.`ID` AS CatID, `Join_1`.`Sites` FROM `cours` LEFT JOIN `categories_des_cours` AS `Join_0` ON `cours`.`ID` = `Join_0`.`Cours` LEFT JOIN `categories` AS `Join_1` ON (`Join_0`.`Categorie` = `Join_1`.`ID`) OR (`cours`.`MainCat` = `Join_1`.`ID`) WHERE (((`cours`.`Lang` IN (0,7,6,8,1)) or ((`cours`.`Lang` IS NULL) or (`cours`.`Lang` IN (0,10)))) AND (((`cours`.`Etat` = 'Pret') or (`cours`.`Etat` = 'SurDemande')) or (`cours`.`ID` = €))) AND (((`Join_0`.`Categorie` = 6) OR (`cours`.`MainCat` = 6)) OR (`Join_0`.`Cours` = €)) ORDER BY `cours`.`Ref`, `CatID`': 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 (((`Join_0`.`Categorie` = 6) OR (`cours`.`MainCat` = 6)) OR (`Join_0`.' at line 1
|
| #2 | Skipping 4 frames, requested 5 frames, will get frames 4 to 9 (excluded) out of 10
|
| #3 | sql_db::query | | "/home/dautrevaux/lib_include/sql_lib.inc.php:341" |
| #4 | argv[0] | = | "SELECT `cours`.*, `Join_0`.`Categorie`, `Join_1`.`Nom` AS CatName, `Join_1`.`ID` AS CatID, `Join_1`.`Sites` FROM `cours` LEFT JOIN `categories_des_cours` AS `Join_0` ON `cours`.`ID` = `Join_0`.`Cours` LEFT JOIN `categories` AS `Join_1` ON (`Join_0`.`Categorie` = `Join_1`.`ID`) OR (`cours`.`MainCat` = `Join_1`.`ID`) WHERE (((`cours`.`Lang` IN (0,7,6,8,1)) or ((`cours`.`Lang` IS NULL) or (`cours`.`Lang` IN (0,10)))) AND (((`cours`.`Etat` = 'Pret') or (`cours`.`Etat` = 'SurDemande')) or (`cours`.`ID` = €))) AND (((`Join_0`.`Categorie` = 6) OR (`cours`.`MainCat` = 6)) OR (`Join_0`.`Cours` = €)) ORDER BY `cours`.`Ref`, `CatID`" |
| #5 | sql_result::query | | "/home/dautrevaux/lib_include/sql_lib.inc.php:329" |
| #6 | argv[0] | = | "SELECT `cours`.*, `Join_0`.`Categorie`, `Join_1`.`Nom` AS CatName, `Join_1`.`ID` AS CatID, `Join_1`.`Sites` FROM `cours` LEFT JOIN `categories_des_cours` AS `Join_0` ON `cours`.`ID` = `Join_0`.`Cours` LEFT JOIN `categories` AS `Join_1` ON (`Join_0`.`Categorie` = `Join_1`.`ID`) OR (`cours`.`MainCat` = `Join_1`.`ID`) WHERE (((`cours`.`Lang` IN (0,7,6,8,1)) or ((`cours`.`Lang` IS NULL) or (`cours`.`Lang` IN (0,10)))) AND (((`cours`.`Etat` = 'Pret') or (`cours`.`Etat` = 'SurDemande')) or (`cours`.`ID` = €))) AND (((`Join_0`.`Categorie` = 6) OR (`cours`.`MainCat` = 6)) OR (`Join_0`.`Cours` = €)) ORDER BY `cours`.`Ref`, `CatID`" |
| #7 | sql_result::sql_result | | "/home/dautrevaux/lib_include/sql_lib.inc.php:1117" |
| #8 | | | starting to print argv[0] type is object |
| #9 | argv[0]->link | | Resource id #32 mysql link |
| #10 | argv[0]->db_name | = | "ac6_form" |
| #11 | argv[0]->db_user | = | "acsys" |
| #12 | argv[0]->db_host | = | "localhost" |
| #13 | argv[0]->db_pass | = | "n9cHEFMajKAcphvF" |
| #14 | argv[0]->query_count | = | 2 |
| #15 | argv[0]->be_safe | = | "1" |
| #16 | | | starting to print argv[0]->logfile type is object |
| #17 | argv[0]->logfile->file | | unset |
| #18 | argv[0]->logfile->name | = | "/home/dautrevaux/www/ac6-formation/logs/cours.php.log" |
| #19 | argv[0]->logfile->num | = | 1 |
| #20 | argv[0]->logfile->level | = | 99 |
| #21 | argv[0]->logfile->loggers | | unset |
| #22 | argv[0]->logfile->util_lib__object_ID | = | 2 |
| #23 | | | ending to print argv[0]->logfile type is object |
| #24 | argv[0]->level | = | 0 |
| #25 | argv[0]->prefix | = | "SQL_db ac6_form@localhost" |
| #26 | argv[0]->started | = | "" |
| #27 | argv[0]->event | = | 3 |
| #28 | argv[0]->print_errors | = | "1" |
| #29 | argv[0]->print_debug | = | "1" |
| #30 | argv[0]->backtrace_level | = | 0 |
| #31 | argv[0]->util_lib__object_ID | = | 1 |
| #32 | | | ending to print argv[0] type is object |
| #33 | argv[1] | = | "SELECT `cours`.*, `Join_0`.`Categorie`, `Join_1`.`Nom` AS CatName, `Join_1`.`ID` AS CatID, `Join_1`.`Sites` FROM `cours` LEFT JOIN `categories_des_cours` AS `Join_0` ON `cours`.`ID` = `Join_0`.`Cours` LEFT JOIN `categories` AS `Join_1` ON (`Join_0`.`Categorie` = `Join_1`.`ID`) OR (`cours`.`MainCat` = `Join_1`.`ID`) WHERE (((`cours`.`Lang` IN (0,7,6,8,1)) or ((`cours`.`Lang` IS NULL) or (`cours`.`Lang` IN (0,10)))) AND (((`cours`.`Etat` = 'Pret') or (`cours`.`Etat` = 'SurDemande')) or (`cours`.`ID` = €))) AND (((`Join_0`.`Categorie` = 6) OR (`cours`.`MainCat` = 6)) OR (`Join_0`.`Cours` = €)) ORDER BY `cours`.`Ref`, `CatID`" |
| #34 | sql_select::run | | "/home/dautrevaux/www/include/read_subsite_specs.inc.php:227" |
| #35 | require_once | | "/home/dautrevaux/lib_include/read_site_specs.inc.php:392" |
| #36 | argv[0] | = | "/home/dautrevaux/www/include/read_subsite_specs.inc.php" |
| #37 | 1 stack frame omitted
|
