**********************************************************************************
********************************  DEBUG DATABASE  ********************************
**********************************************************************************

----------------------------------- ERROR PDO -----------------------------------

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'debug-groupcorner.gcv2_shapes' doesn't exist

----------------------------------- ERROR LINE -----------------------------------

LINE: 334    /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php

----------------------------------- PREPARE REQUEST -----------------------------------

SELECT  SQL_CALC_FOUND_ROWS C.id,C.parent_id

 FROM 
                    `gcv2_contents` C 
                    LEFT JOIN `gcv2_shapes` S ON (S.ref_table="contents" AND S.ref_table_id=C.id)
                

 WHERE 
                    C.type_slug='landing_page' AND
                    sub_type_slug='geo' AND
                    get_distance_km(43.2087063, 2.3685453, S.lat, S.lng) <= (S.radius/1000) AND
                    active=1
                    

 ORDER BY S.radius ASC 

 LIMIT 1

----------------------------------- PARAMETERS -----------------------------------

Array
(
)


----------------------------------- LIENS VSCODE -----------------------------------

/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/helpers/database.php:492 - execute
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php:189 - call_user_func_array
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php:334 - select
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Sitemap.php:14 - getFirstLine
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Hotel.php:184 - getLonLatBrothers
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php:110 - call_user_func_array
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php:280 - invokeObject
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/index.php:77 - dispatch ----------------------------------- ERROR PDO ----------------------------------- PDOException Object ( [message:protected] => SQLSTATE[42S02]: Base table or view not found: 1146 Table 'debug-groupcorner.gcv2_shapes' doesn't exist [string:Exception:private] => [code:protected] => 42S02 [file:protected] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/helpers/database.php [line:protected] => 492 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/helpers/database.php [line] => 492 [function] => execute [class] => PDOStatement [type] => -> ) [1] => Array ( [function] => select [class] => helpers\Database [type] => -> ) [2] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php [line] => 189 [function] => call_user_func_array ) [3] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php [line] => 334 [function] => select [class] => core\Model [type] => -> ) [4] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Sitemap.php [line] => 14 [function] => getFirstLine [class] => core\Model [type] => -> ) [5] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Hotel.php [line] => 184 [function] => getLonLatBrothers [class] => controllers\front_office\site\Sitemap [type] => -> ) [6] => Array ( [function] => index [class] => controllers\front_office\site\Hotel [type] => -> ) [7] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php [line] => 110 [function] => call_user_func_array ) [8] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php [line] => 280 [function] => invokeObject [class] => core\Router [type] => :: ) [9] => Array ( [file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/index.php [line] => 77 [function] => dispatch [class] => core\Router [type] => :: ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42S02 [1] => 1146 [2] => Table 'debug-groupcorner.gcv2_shapes' doesn't exist ) ) ------------------------------------------------------------------------------------
"""
\n
----------------------------------\n
URL: debug-groupcorner.ovh/de/hotel/de-loctroi\n
----------------------------------\n
BACKYOU : -\n
MEMBRE : -\n
PROFIL : \n
----------------------------------\n
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'debug-groupcorner.gcv2_shapes' doesn't exist\n
----------------------------------\n
FULL REQUEST : \n
\n
SELECT  SQL_CALC_FOUND_ROWS C.id,C.parent_id\n
\n
 FROM \n
                    `gcv2_contents` C \n
                    LEFT JOIN `gcv2_shapes` S ON (S.ref_table="contents" AND S.ref_table_id=C.id)\n
                \n
\n
 WHERE \n
                    C.type_slug='landing_page' AND\n
                    sub_type_slug='geo' AND\n
                    get_distance_km(43.2087063, 2.3685453, S.lat, S.lng) <= (S.radius/1000) AND\n
                    active=1\n
                    \n
\n
 ORDER BY S.radius ASC \n
\n
 LIMIT 1\n
----------------------------------\n
TRACE : \n
\n
app/helpers/database.php:492 - execute\n
app/core/model.php:189 - call_user_func_array\n
app/core/model.php:334 - select\n
app/controllers/front_office/site/Sitemap.php:14 - getFirstLine\n
app/controllers/front_office/site/Hotel.php:184 - getLonLatBrothers\n
app/core/router.php:110 - call_user_func_array\n
app/core/router.php:280 - invokeObject\n
index.php:77 - dispatch\n
----------------------------------\n
"""