Notice (8): Undefined offset: 0 [APP/Controller/ProgramsController.php, line 50]
Notice (8): Undefined variable: sProgramUnivers [APP/Controller/ProgramsController.php, line 67]
Notice (8): Undefined index:  [APP/Controller/ProgramsController.php, line 67]
Notice (8): Undefined index: id_type [APP/Controller/ProgramsController.php, line 109]
Notice (8): Undefined index: name [APP/Controller/ProgramsController.php, line 153]
Notice (8): Undefined index: name [APP/Controller/ProgramsController.php, line 154]
Notice (8): Undefined index: cnl_id [APP/Controller/ProgramsController.php, line 156]
Notice (8): Undefined index: program_id [APP/Controller/ProgramsController.php, line 156]
EQUIDIAPLAY.FR - Tous les programmes d'EQUIDIA en illimité
LES PROGRAMMES
BONUSTOUT SUR LE CHEVALSPORTS EQUESTRESCOURSES HIPPIQUES TOUS LES PROGRAMMES
BONUSTOUT SUR LE CHEVALSPORTS EQUESTRESCOURSES HIPPIQUES
Equidia
S'abonner

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 'GROUP BY IdPub ORDER BY CountPub DESC LIMIT 2) UNION ' at line 18

SQL Query: (SELECT publication_id AS IdPub , user_id, count(publication_id) as CountPub, program_id, program_id as program_id_fav, id_type, categories_cnl_id AS IdCNL, type_id AS ReplayVod FROM publications_views pview INNER JOIN publications pub ON pview.publication_id=pub.id INNER JOIN programs prog ON pub.program_id=prog.id WHERE categories_cnl_id=? AND type_id = 1 AND date_view >= DATE_SUB(NOW(),INTERVAL 7 DAY) AND date_fin > now() AND date_debut < now() AND univers_id=2 AND program_id != GROUP BY IdPub ORDER BY CountPub DESC LIMIT 2) UNION (SELECT publication_id AS IdPub , user_id, count(publication_id) as CountPub, program_id, program_id as program_id_fav, id_type, categories_cnl_id AS IdCNL, type_id AS ReplayVod FROM publications_views pview INNER JOIN publications pub ON pview.publication_id=pub.id INNER JOIN programs prog ON pub.program_id=prog.id WHERE categories_cnl_id=? AND type_id = 2 AND date_view >= DATE_SUB(NOW(),INTERVAL 7 DAY) AND date_fin > now() AND date_debut < now() AND univers_id=2 AND program_id != GROUP BY IdPub ORDER BY CountPub DESC LIMIT 1)

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

Stack Trace

  • CORE/Cake/Model/Datasource/DboSource.php line 458PDOStatement->execute(array)
  • CORE/Cake/Model/Datasource/DboSource.php line 424DboSource->_execute(string, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 665DboSource->execute(string, array, array)
  • APP/Model/Programs.php line 858DboSource->fetchAll(string, array)
  • APP/Controller/ProgramsController.php line 156Programs->getReco(null, null)
  • [internal function]ProgramsController->index()
  • CORE/Cake/Controller/Controller.php line 490ReflectionMethod->invokeArgs(ProgramsController, array)
  • CORE/Cake/Routing/Dispatcher.php line 185Controller->invokeAction(CakeRequest)
  • CORE/Cake/Routing/Dispatcher.php line 160Dispatcher->_invoke(ProgramsController, CakeRequest, CakeResponse)
  • APP/webroot/index.php line 121Dispatcher->dispatch(CakeRequest, CakeResponse)
  • ROOT/index.php line 41require(string)
Inscription

Je souhaite recevoir la newsletter d’Equidia

Je souhaite recevoir les offres des partenaires d’Equidia

* Champs obligatoires
** En cliquant ici vous acceptez les conditions générales d'utilisation
Vous avez déjà un compte ?
Mot de passe oublié
Vous avez oublié votre mot de passe? Renseignez votre adresse email et nous vous en renvoyons un nouveau !
* Champs obligatoires
Envoi à un ami
* Champs obligatoires
Rocket Fuel