DBStatement::execute() statement fail :
SELECT COUNT(*) AS `count` FROM `we_guide` WHERE (id IN (SELECT guide_id FROM we_guide_x_etape WHERE etape_id IN ()) AND we_guide.id IN (SELECT we_guide_x_theme.guide_id FROM we_guide_x_theme WHERE we_guide_x_theme.theme_id="9")) ORDER BY RAND() LIMIT 1
Array
(
[0] => 42000
[1] => 1064
[2] => 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 we_guide.id IN (SELECT we_guide_x_theme.guide_id FROM we_guide_x_theme WH' at line 1
)
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/idiorm.php @ line 413
DBStatement->execute()
Parameters : Array
(
[0] => Array
(
[0] => 9
)
)
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/idiorm.php @ line 1639
ORM::_execute()
Parameters : Array
(
[0] => SELECT COUNT(*) AS `count` FROM `we_guide` WHERE (id IN (SELECT guide_id FROM we_guide_x_etape WHERE etape_id IN ()) AND we_guide.id IN (SELECT we_guide_x_theme.guide_id FROM we_guide_x_theme WHERE we_guide_x_theme.theme_id=?)) ORDER BY RAND() LIMIT 1
[1] => Array
(
[0] => 9
)
[2] => default
)
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/idiorm.php @ line 582 ORM->_run() Parameters : Array ( )
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/paris.php @ line 118
ORM->find_one()
Parameters : Array
(
[0] =>
)
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/idiorm.php @ line 709 ORMWrapper->find_one() Parameters : Array ( )
/var/www/vhosts/52we.com/httpdocs/core/vendors/j4mie/idiorm.php @ line 659
ORM->_call_aggregate_db_function()
Parameters : Array
(
[0] => count
[1] => *
)
/var/www/vhosts/52we.com/httpdocs/apps/classes/We/Etablissement.php @ line 116 ORM->count() Parameters : Array ( )
/var/www/vhosts/52we.com/httpdocs/apps/classes/We/Etablissement.php @ line 103
We_Etablissement->nearest_guides()
Parameters : Array
(
[0] => 50
[1] => 10
[2] => 10
[3] => 9
)
/var/www/vhosts/52we.com/httpdocs/pages/etb.php @ line 132
We_Etablissement->nearest_guides_for_theme()
Parameters : Array
(
[0] => 9
[1] => 50
[2] => 10
[3] => 10
)
/var/www/vhosts/52we.com/httpdocs/core/classes/Page.php @ line 228
Function : include()
Parameters : Array
(
[0] => /var/www/vhosts/52we.com/httpdocs/pages/etb.php
)
/var/www/vhosts/52we.com/httpdocs/core/classes/Template.php @ line 23
Page::load()
Parameters : Array
(
[0] =>
[1] =>
)
/var/www/vhosts/52we.com/httpdocs/index.php @ line 62 Template::display() Parameters : Array ( )