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
CHOISISSEZ
VOTRE CHAÎNE
live life

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