**********************************************************************************
******************************** DEBUG DATABASE ********************************
**********************************************************************************
----------------------------------- ERROR PDO -----------------------------------
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'debug-groupcorner.gcv2_languages' doesn't exist
----------------------------------- ERROR LINE -----------------------------------
LINE: 334 /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/model.php
----------------------------------- FULL REQUEST -----------------------------------
SELECT SQL_CALC_FOUND_ROWS
JSON_ARRAYAGG(JSON_OBJECT('slug',contents_i18n.slug,'title',contents_i18n.h1_title,'pos',pages_url_contents.pos)) as tab,
languages.landing_page_slug as landing_page_slug,
contents_i18n_2.h1_title as end_title
FROM
`gcv2_pages_url` AS pages_url
left JOIN `gcv2_pages_url_contents` AS pages_url_contents ON pages_url_contents.pages_url_id=pages_url.id
left JOIN `gcv2_contents_i18n` AS contents_i18n ON contents_i18n.contents_id=pages_url_contents.contents_id
left JOIN `gcv2_languages` AS languages ON languages.code=contents_i18n.lang
left JOIN `gcv2_contents_i18n` AS contents_i18n_2 ON contents_i18n_2.contents_id=pages_url.contents_id and contents_i18n.lang=contents_i18n_2.lang and contents_i18n_2.active IS TRUE
WHERE ( contents_i18n.`active` is TRUE AND contents_i18n.`lang`='fr_FR' AND pages_url.`name`='Londres' )
GROUP BY pages_url.id
LIMIT 1
----------------------------------- PREPARE REQUEST -----------------------------------
SELECT SQL_CALC_FOUND_ROWS
JSON_ARRAYAGG(JSON_OBJECT('slug',contents_i18n.slug,'title',contents_i18n.h1_title,'pos',pages_url_contents.pos)) as tab,
languages.landing_page_slug as landing_page_slug,
contents_i18n_2.h1_title as end_title
FROM
`gcv2_pages_url` AS pages_url
left JOIN `gcv2_pages_url_contents` AS pages_url_contents ON pages_url_contents.pages_url_id=pages_url.id
left JOIN `gcv2_contents_i18n` AS contents_i18n ON contents_i18n.contents_id=pages_url_contents.contents_id
left JOIN `gcv2_languages` AS languages ON languages.code=contents_i18n.lang
left JOIN `gcv2_contents_i18n` AS contents_i18n_2 ON contents_i18n_2.contents_id=pages_url.contents_id and contents_i18n.lang=contents_i18n_2.lang and contents_i18n_2.active IS TRUE
WHERE ( contents_i18n.`active` is TRUE AND contents_i18n.`lang`=:W_VAL_45 AND pages_url.`name`=:W_VAL_46 )
GROUP BY pages_url.id
LIMIT 1
----------------------------------- PARAMETERS -----------------------------------
Array
(
[ contents_i18n.`lang`] => Array
(
[key] => :W_VAL_45
[value] => fr_FR
)
[ pages_url.`name`] => Array
(
[key] => :W_VAL_46
[value] => Londres
)
)
----------------------------------- 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/helpers/GC_Pages.php:40 - getFirstLine
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/helpers/smarty/plugins/function.get.php:83 - getLinkByPages
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^c905e1074c7b704472d6de35856cfc4fbc381eb5_2.file.top_destinations.tpl.php:29 - smarty_function_get
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 - content_66727898245031_15439712
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 - getRenderedTemplateCode
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^61158514f7bd30c6c8aa773f88f3549fb02448e0_2.file.content_menu.tpl.php:68 - _subTemplateRender
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 - content_66f269325ffca9_78834316
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 - getRenderedTemplateCode
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^463d0821c8d982040f26f632efda47fc424bd172_2.file.header.tpl.php:214 - _subTemplateRender
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 - content_66baf7a96875a3_09484256
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 - getRenderedTemplateCode
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 - render
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 - _execute
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/NView.php:789 - fetch
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/NView.php:890 - getContent
/var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Hotel.php:197 - printPage
/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_languages' 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/helpers/GC_Pages.php
[line] => 40
[function] => getFirstLine
[class] => core\Model
[type] => ->
)
[5] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/helpers/smarty/plugins/function.get.php
[line] => 83
[function] => getLinkByPages
[class] => helpers\GC_Pages
[type] => ::
)
[6] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^c905e1074c7b704472d6de35856cfc4fbc381eb5_2.file.top_destinations.tpl.php
[line] => 29
[function] => smarty_function_get
)
[7] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
[line] => 123
[function] => content_66727898245031_15439712
)
[8] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
[line] => 114
[function] => getRenderedTemplateCode
[class] => Smarty_Template_Resource_Base
[type] => ->
)
[9] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
[line] => 217
[function] => render
[class] => Smarty_Template_Compiled
[type] => ->
)
[10] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
[line] => 386
[function] => render
[class] => Smarty_Internal_Template
[type] => ->
)
[11] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^61158514f7bd30c6c8aa773f88f3549fb02448e0_2.file.content_menu.tpl.php
[line] => 68
[function] => _subTemplateRender
[class] => Smarty_Internal_Template
[type] => ->
)
[12] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
[line] => 123
[function] => content_66f269325ffca9_78834316
)
[13] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
[line] => 114
[function] => getRenderedTemplateCode
[class] => Smarty_Template_Resource_Base
[type] => ->
)
[14] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
[line] => 217
[function] => render
[class] => Smarty_Template_Compiled
[type] => ->
)
[15] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
[line] => 386
[function] => render
[class] => Smarty_Internal_Template
[type] => ->
)
[16] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/templates_c/fr_FR^463d0821c8d982040f26f632efda47fc424bd172_2.file.header.tpl.php
[line] => 214
[function] => _subTemplateRender
[class] => Smarty_Internal_Template
[type] => ->
)
[17] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php
[line] => 123
[function] => content_66baf7a96875a3_09484256
)
[18] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php
[line] => 114
[function] => getRenderedTemplateCode
[class] => Smarty_Template_Resource_Base
[type] => ->
)
[19] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
[line] => 217
[function] => render
[class] => Smarty_Template_Compiled
[type] => ->
)
[20] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
[line] => 238
[function] => render
[class] => Smarty_Internal_Template
[type] => ->
)
[21] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
[line] => 116
[function] => _execute
[class] => Smarty_Internal_TemplateBase
[type] => ->
)
[22] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/NView.php
[line] => 789
[function] => fetch
[class] => Smarty_Internal_TemplateBase
[type] => ->
)
[23] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/NView.php
[line] => 890
[function] => getContent
[class] => core\NView
[type] => ->
)
[24] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/controllers/front_office/site/Hotel.php
[line] => 197
[function] => printPage
[class] => core\NView
[type] => ->
)
[25] => Array
(
[function] => index
[class] => controllers\front_office\site\Hotel
[type] => ->
)
[26] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php
[line] => 110
[function] => call_user_func_array
)
[27] => Array
(
[file] => /var/www/vhosts/debug-groupcorner.ovh/httpdocs/app/core/router.php
[line] => 280
[function] => invokeObject
[class] => core\Router
[type] => ::
)
[28] => 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_languages' doesn't exist
)
)
------------------------------------------------------------------------------------
"""
\n
----------------------------------\n
URL: debug-groupcorner.ovh/fr/hotel/the-originals-saintes-ouest-recouvrance\n
----------------------------------\n
BACKYOU : -\n
MEMBRE : -\n
PROFIL : \n
----------------------------------\n
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'debug-groupcorner.gcv2_languages' doesn't exist\n
----------------------------------\n
FULL REQUEST : \n
\n
SELECT SQL_CALC_FOUND_ROWS \n
JSON_ARRAYAGG(JSON_OBJECT('slug',contents_i18n.slug,'title',contents_i18n.h1_title,'pos',pages_url_contents.pos)) as tab,\n
languages.landing_page_slug as landing_page_slug,\n
contents_i18n_2.h1_title as end_title\n
\n
\n
FROM \n
\n
`gcv2_pages_url` AS pages_url \n
left JOIN `gcv2_pages_url_contents` AS pages_url_contents ON pages_url_contents.pages_url_id=pages_url.id \n
left JOIN `gcv2_contents_i18n` AS contents_i18n ON contents_i18n.contents_id=pages_url_contents.contents_id \n
left JOIN `gcv2_languages` AS languages ON languages.code=contents_i18n.lang \n
left JOIN `gcv2_contents_i18n` AS contents_i18n_2 ON contents_i18n_2.contents_id=pages_url.contents_id and contents_i18n.lang=contents_i18n_2.lang and contents_i18n_2.active IS TRUE \n
\n
WHERE ( contents_i18n.`active` is TRUE AND contents_i18n.`lang`='fr_FR' AND pages_url.`name`='Londres' ) \n
\n
GROUP BY pages_url.id \n
\n
LIMIT 1\n
----------------------------------\n
WHERE PARAMS : \n
\n
contents_i18n.`lang` : fr_FR (:W_VAL_45)\n
pages_url.`name` : Londres (:W_VAL_46)\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/helpers/GC_Pages.php:40 - getFirstLine\n
app/helpers/smarty/plugins/function.get.php:83 - getLinkByPages\n
templates_c/fr_FR^c905e1074c7b704472d6de35856cfc4fbc381eb5_2.file.top_destinations.tpl.php:29 - smarty_function_get\n
templates_c/fr_FR^61158514f7bd30c6c8aa773f88f3549fb02448e0_2.file.content_menu.tpl.php:68 - _subTemplateRender\n
templates_c/fr_FR^463d0821c8d982040f26f632efda47fc424bd172_2.file.header.tpl.php:214 - _subTemplateRender\n
app/core/NView.php:789 - fetch\n
app/core/NView.php:890 - getContent\n
app/controllers/front_office/site/Hotel.php:197 - printPage\n
app/core/router.php:110 - call_user_func_array\n
app/core/router.php:280 - invokeObject\n
index.php:77 - dispatch\n
----------------------------------\n
"""