**********************************************************************************
******************************** 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
"""