02 41 50 37 88

Accès

Online booking

Define my stay
Choice of rooms
Choice of options
Login / Register
Validation

Define my stay

When ?

Date of arrival

Date of departure

Arrival time

Who ?

Room1

Adults

Children*

Add a room

* For children under 16 years old

Reset

This site uses cookies to improve your browsing experience
By continuing your navigation, you agree to the use of cookies and other tracers for purposes of audience measurement, sharing with social networks, profiling. I want to set cookies

I refuse

I accept

_GET (2)
_SERVER (36)
_REQUEST (2)

_GET

array (
  'en/reservation-online' => '',
  'send' => '1',
)

_SERVER

array (
  'DOCUMENT_ROOT' => '/www/2013/03/sa601/www',
  'GATEWAY_INTERFACE' => 'CGI/1.1',
  'HOSTNAME' => 'WebFront08',
  'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
  'HTTP_ACCEPT_ENCODING' => 'br,gzip',
  'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
  'HTTP_CONNECTION' => 'close',
  'HTTP_HOST' => 'www.hotel-lecanter.fr',
  'HTTP_IF_MODIFIED_SINCE' => 'Thu, 13 Aug 2020 02:19:19 GMT',
  'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
  'HTTP_X_FORWARDED_FOR' => '3.238.4.24',
  'HTTP_X_FORWARDED_PORT' => '443',
  'HTTP_X_FORWARDED_PROTO' => 'https',
  'PATH' => '/bin:/usr/bin',
  'PHPRC' => '/home/phpini/hotel-lecanter.fr/php73',
  'QUERY_STRING' => 'en/reservation-online&send=1',
  'REDIRECT_HOSTNAME' => 'WebFront08',
  'REDIRECT_QUERY_STRING' => 'en/reservation-online&send=1',
  'REDIRECT_STATUS' => '200',
  'REDIRECT_URL' => '/en/reservation-online',
  'REMOTE_ADDR' => '10.1.2.250',
  'REMOTE_PORT' => '40896',
  'REQUEST_METHOD' => 'GET',
  'REQUEST_URI' => '/en/reservation-online?send=1',
  'SCRIPT_FILENAME' => '/www/2013/03/sa601/www/oktopus.php',
  'SCRIPT_NAME' => '/oktopus.php',
  'SERVER_ADDR' => '10.1.2.8',
  'SERVER_ADMIN' => 'service-client@sitti.fr',
  'SERVER_NAME' => 'www.hotel-lecanter.fr',
  'SERVER_PORT' => '80',
  'SERVER_PROTOCOL' => 'HTTP/1.1',
  'SERVER_SIGNATURE' => 'Apache/2.2.22 (Debian) Server at www.hotel-lecanter.fr Port 80
',
  'SERVER_SOFTWARE' => 'Apache/2.2.22 (Debian)',
  'PHP_SELF' => '/oktopus.php',
  'REQUEST_TIME_FLOAT' => 1603192587.1044841,
  'REQUEST_TIME' => 1603192587,
)

_REQUEST

array (
  'en/reservation-online' => '',
  'send' => '1',
)

Variables (5)
Constantes (81)
Configuration (100)
Utilisateur (27)

Variables dans le scope global

array (
  0 => 'okt',
  1 => 'oktAutoloadPaths',
  2 => '__composer_autoload_files',
  3 => '__l10n',
  4 => '__l10n_files',
)

Constantes

array (
  'OKT_START_TIME' => 1603192587.112355,
  'OKT_ROOT_PATH' => '/www/2013/03/sa601/www',
  'OKT_INC_DIR' => 'oktInc',
  'OKT_INC_PATH' => '/www/2013/03/sa601/www/oktInc',
  'OKT_UPLOAD_DIR' => 'upload',
  'OKT_UPLOAD_PATH' => '/www/2013/03/sa601/www/upload',
  'OKT_COMMON_DIR' => 'oktCommon',
  'OKT_COMMON_PATH' => '/www/2013/03/sa601/www/oktCommon',
  'OKT_MODULES_DIR' => 'oktModules',
  'OKT_MODULES_PATH' => '/www/2013/03/sa601/www/oktModules',
  'OKT_PUBLIC_DIR' => 'oktPublic',
  'OKT_PUBLIC_PATH' => '/www/2013/03/sa601/www/oktPublic',
  'OKT_CACHE_DIR' => 'oktCache',
  'OKT_CACHE_PATH' => '/www/2013/03/sa601/www/oktCache',
  'OKT_GLOBAL_CACHE_FILENAME' => 'static.php',
  'OKT_GLOBAL_CACHE_FILE' => '/www/2013/03/sa601/www/oktCache/static.php',
  'OKT_CONFIG_DIR' => 'oktConf',
  'OKT_CONFIG_PATH' => '/www/2013/03/sa601/www/oktConf',
  'OKT_LOG_DIR' => 'oktLog',
  'OKT_LOG_PATH' => '/www/2013/03/sa601/www/oktLog',
  'OKT_THEMES_DIR' => 'oktThemes',
  'OKT_THEMES_PATH' => '/www/2013/03/sa601/www/oktThemes',
  'OKT_CLASSES_PATH' => '/www/2013/03/sa601/www/oktInc/classes',
  'OKT_LOCALES_PATH' => '/www/2013/03/sa601/www/oktInc/locales',
  'OKT_VENDOR_PATH' => '/www/2013/03/sa601/www/oktInc/vendor',
  'OKT_MIN_DIR' => 'minify',
  'OKT_MIN_PATH' => '/www/2013/03/sa601/www/oktCache/minify',
  'OKT_MINGROUP_DIR' => 'groups',
  'OKT_MINGROUP_PATH' => '/www/2013/03/sa601/www/oktCache/minify/groups',
  'OKT_COOKIE_AUTH_NAME' => 'okt_auth',
  'OKT_COOKIE_AUTH_FROM' => 'okt_auth_from',
  'OKT_COOKIE_LANGUAGE' => 'okt_language',
  'OKT_COOKIE_CONSENT' => 'okt_consent',
  'OKT_ENVIRONMENT' => 'prod',
  'OKT_XDEBUG' => false,
  'OKT_FILENAME' => 'oktopus.php',
  'OKT_DIRNAME' => '/',
  'OKT_ADMIN_DIR' => 'administration',
  'OKT_ADMIN_HEADER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header.php',
  'OKT_ADMIN_HEADER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/header_ajax.php',
  'OKT_ADMIN_HEADER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/header_cnx.php',
  'OKT_ADMIN_FOOTER_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer.php',
  'OKT_ADMIN_FOOTER_FILE_AJAX' => '/www/2013/03/sa601/www/oktInc/admin/footer_ajax.php',
  'OKT_ADMIN_FOOTER_FILE_CNX' => '/www/2013/03/sa601/www/oktInc/admin/footer_cnx.php',
  'OKT_ADMIN_HEADER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/header_simple.php',
  'OKT_ADMIN_FOOTER_SIMPLE_FILE' => '/www/2013/03/sa601/www/oktInc/admin/footer_simple.php',
  'OKT_ADMIN_LOGIN_PAGE' => 'connexion.php',
  'OKT_GOOGLE_GEOCODE_KEY' => 'AIzaSyAZsu4vldPq58x4FWGs35p3ytzrAZ67xVI',
  'OKT_THUMB_COMPRESSION' => 80,
  'OKT_SEO_LIMIT_TITLE' => 75,
  'OKT_SEO_LIMIT_DESCRIPTION' => 200,
  'OKT_DB_LOG_USER' => 'ledns-oktolog',
  'OKT_DB_LOG_PWD' => '7gv2536uGfiImFLl',
  'OKT_ROUND_HALF_UP' => 1,
  'OKT_ROUND_HALF_DOWN' => 2,
  'OKT_ROUND_HALF_EVEN' => 3,
  'OKT_ROUND_HALF_ODD' => 4,
  'OKT_ROUND_UP' => 5,
  'OKT_ROUND_DOWN' => 6,
  'JSON_ENCODE_ALL' => 271,
  'FILTER_VALIDATE_BOOL' => 258,
  'HTMLPURIFIER_PREFIX' => '/www/2013/03/sa601/www/oktInc/vendor/composer/vendor/ezyang/htmlpurifier/library',
  'OKT_DB_HOST' => 'sql5',
  'OKT_DB_NAME' => 'sa601',
  'OKT_DB_USER' => 'sa601',
  'OKT_DB_PWD' => 'GF6NAnxDTCogUrzE',
  'OKT_DB_PREFIX' => 'oktopusV2_',
  'OKT_MODULES_URL' => '/oktModules',
  'OKT_COMMON_URL' => '/oktCommon',
  'OKT_UPLOAD_URL' => '/upload',
  'OKT_DIGESTS' => '/www/2013/03/sa601/www/oktInc/digests',
  'OKT_THEME_DEFAULT_PATH' => '/www/2013/03/sa601/www/oktThemes/default',
  'OKT_THEME_DEFAULT' => '/oktThemes/default',
  'OKT_THEME' => '/oktThemes/ra154-s',
  'OKT_THEME_PATH' => '/www/2013/03/sa601/www/oktThemes/ra154-s',
  'OKT_MAX_UPLOAD_SIZE' => 52428800,
  'OKT_DEBUG' => true,
  'OKT_PART' => 'public',
  '__DB_PREFIX_TVA__' => 'oktopusV2_mod_tva_',
  '__DB_PREFIX_GEO__' => 'oktopusV2_mod_geographie_',
  '__DB_PREFIX_RESA__' => 'oktopusV2_mod_resa_',
)

Configuration

array (
  'title' => 
  array (
    'fr' => 'L\'hôtel Le Canter',
    'en' => '',
    'es' => '',
  ),
  'desc' => 
  array (
    'fr' => '',
    'en' => '',
    'es' => '',
  ),
  'title_tag' => 
  array (
    'fr' => 'L\'hôtel Le Canter',
    'en' => '',
    'es' => '',
  ),
  'meta_description' => 
  array (
    'fr' => 'L\'hôtel Le Canter est un hôtel d\'hébergement séminaire et petit déjeuner près de Saumur dans le Maine-et-Loire (49).',
    'en' => '',
    'es' => '',
  ),
  'meta_keywords' => 
  array (
    'fr' => 'hébergement séminaire saumur, chambres hotel saumur, hôtel séminaire et petit déjeuner saumur, hôtel séminaire saumur, réserver hôtel saumur, hébergement séminaire et petit déjeuner saumur, chambres hôtel et petit déjeuner saumur, hébergement séminaire 49, chambres hotel 49, hôtel séminaire et petit déjeuner 49, hôtel séminaire 49, réserver hôtel 49, hébergement séminaire et petit déjeuner 49, chambres hôtel et petit déjeuner 49, hébergement séminaire maine et loire, chambres hotel maine et loire, hôtel séminaire et petit déjeuner maine et loire, hôtel séminaire maine et loire, réserver hôtel maine et loire, hébergement séminaire et petit déjeuner maine et loire, chambres hôtel et petit déjeuner maine et loire',
    'en' => '',
    'es' => '',
  ),
  'list_address' => 
  array (
    0 => 
    array (
      'libelle' => '',
      'company_name' => '',
      'street' => '1 Place De La Sénatorerie',
      'street_2' => '',
      'code' => '49400',
      'city' => 'Saint-Hilaire-Saint-Florent',
      'country' => 'France',
      'tel' => '02 41 50 37 88',
      'mobile' => '',
      'fax' => '',
      'email' => 'contact@hotel-lecanter.fr',
      'lat' => '47.2647675',
      'long' => '-0.1000264',
      'config_address_1' => '1',
      'config_address_2' => '1',
    ),
  ),
  'list_schedule' => 
  array (
    0 => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
  ),
  'company' => 
  array (
    'name' => 'OSER',
    'com_name' => 'L\'hôtel Le Canter',
    'siret' => '853 210 250 00017',
    'tva_intra' => 'FR00853210250',
  ),
  'plan' => 
  array (
    'affichage' => 0,
    'lat' => '',
    'long' => '',
  ),
  'leader' => 
  array (
    'name' => 'SIGURET',
    'firstname' => 'Olivier',
  ),
  'courriel_address' => 'prodokto@gmail.com',
  'courriel_name' => 'L\'hôtel Le Canter',
  'courriel_transport' => 'sendmail',
  'courriel_smtp' => 
  array (
    'host' => '',
    'port' => 25,
    'username' => 'dev@sitti.fr',
    'password' => 'cMGhbnTL',
  ),
  'courriel_sendmail' => '/usr/sbin/sendmail -t -i',
  'courriel_theme' => '1',
  'theme' => 'ra154-s',
  'theme_mobile' => '',
  'theme_tablet' => '',
  'public_theme' => 'base',
  'form_theme' => 'jiro',
  'button' => 
  array (
    'primary_type' => 'couleur',
    'effect' => 'bouton_fade1',
    'shadow_text' => '1',
    'shadow_box' => 0,
    'secondary_type' => 'bordure',
    'bloc3' => '1',
    'diapo' => '1',
  ),
  'menu' => 
  array (
    'type' => '6',
    'orientation' => '1',
    'compatible' => 
    array (
      0 => '6',
    ),
  ),
  'menu_bas' => 
  array (
    'enable_menu_deroulant' => false,
    'show_rubrique_principale' => true,
  ),
  'enable_admin_bar' => true,
  'enable_backtop' => true,
  'set_theme_column' => '2',
  'admin_sidebar_position' => 0,
  'admin_dashboard' => 0,
  'admin_theme' => 'admin',
  'admin_compress_output' => false,
  'panel_construction' => 
  array (
    'enable' => 0,
    'text' => 'Découvrez prochainement notre site internet',
    'color' => '000000',
    'bgcolor' => 'ffffff',
  ),
  'language' => 'es',
  'timezone' => 'Europe/Madrid',
  'admin_lang_switcher' => true,
  'app_path' => '/',
  'domain' => 'www.hotel-lecanter.fr',
  'internal_router' => true,
  'default_route' => 
  array (
    'class' => 'pagesController',
    'method' => 'pagesItem',
    'args' => 'accueil',
  ),
  'custom_routes' => 
  array (
  ),
  'redirect_404_to_home' => false,
  'app_file' => 'oktopus.php',
  'public_maintenance_mode' => false,
  'admin_maintenance_mode' => false,
  'modules_repositories_enabled' => true,
  'modules_repositories' => 
  array (
    'SITTI modules' => 'http://oktopus.ledns.net/modules/%VERSION%/index.xml',
  ),
  'themes_repositories_enabled' => true,
  'themes_repositories' => 
  array (
    'SITTI thèmes' => 'http://oktopus.ledns.net/themes/%VERSION%/index.xml',
  ),
  'debug_enabled' => true,
  'stop_redirect_on_error' => true,
  'xdebug_enabled' => false,
  'antispam_filters' => 'a:0:{}',
  'use_admin_lang_switcher' => NULL,
  'update_enabled' => true,
  'update_url' => 'http://oktopus.ledns.net/packages/versions.xml',
  'update_type' => 'stable',
  'api_enabled' => true,
  'api_key' => '2285ff62ae73262abf78d40aa266e65cd12b7fbbb11cae988a1626c9cb760c3d',
  'auth_security' => 
  array (
    'enabled' => true,
    'allowed_retries' => 5,
    'lockout_duration' => 30,
    'valid_duration' => 12,
    'whitelist' => 
    array (
    ),
    'blacklist' => 
    array (
    ),
  ),
  'minify_complete_enable' => false,
  'minify_css_admin' => 
  array (
    0 => '%COMMON_URL%/css/bootstrap.3.2.0.min.css',
    1 => '%COMMON_URL%/ui-themes/%ADMIN_THEME%/jquery-ui.css',
    2 => '%COMMON_URL%/js/jquery/popup/jquery.popup.css',
    3 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.css',
    4 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.css',
  ),
  'minify_js_admin' => 
  array (
    0 => '%COMMON_URL%/js/jquery/jquery.min.js',
    1 => '%COMMON_URL%/js/jquery/jquery-migrate.min.js',
    2 => '%COMMON_URL%/js/jquery/cookie/jquery.cookie.min.js',
    3 => '%COMMON_URL%/js/jquery/metadata/jquery.metadata.min.js',
    4 => '%COMMON_URL%/js/jquery/ui/jquery-ui.min.js',
    5 => '%COMMON_URL%/js/jquery/ui/i18n/jquery-ui-i18n.min.js',
    6 => '%COMMON_URL%/js/jquery/popup/jquery.popup.js',
    7 => '%COMMON_URL%/js/jquery/validate/jquery.validate.min.js',
    8 => '%COMMON_URL%/js/jquery/validate/additional-methods.min.js',
    9 => '%COMMON_URL%/js/jquery/util/jquery.util.js',
    10 => '%COMMON_URL%/js/jquery/maxlength/jquery.maxlength.min.js',
    11 => '%COMMON_URL%/js/jquery/slimscroll.min.js',
    12 => '%COMMON_URL%/js/jquery/moment.js',
    13 => '%COMMON_URL%/js/jquery/util/jquery.util.js',
    14 => '%COMMON_URL%/js/jquery/alphanumeric/jquery.alphanumeric.js',
    15 => '%COMMON_URL%/js/jquery/validform/jquery.validform.js',
    16 => '%COMMON_URL%/js/jquery/sprintf/jquery.sprintf.js',
    17 => '%COMMON_URL%/js/jquery/ui_dev/jquery.ui.combobox.js',
    18 => '%COMMON_URL%/js/jquery/form/jquery.form.js',
    19 => '%COMMON_URL%/js-plugins/timepicker/jquery.timepicker.js',
    20 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.js',
    21 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.pager.js',
    22 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.filter.js',
    23 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.total.js',
    24 => '%COMMON_URL%/js-plugins/tablesorter/jquery.tablesorter.customparser.js',
    25 => '%COMMON_URL%/js/jquery/maskinput/src/jquery.maskinput.js',
    26 => '%COMMON_URL%/js/common_admin.js',
  ),
  'minify_css_public' => 
  array (
  ),
  'minify_js_public' => 
  array (
  ),
  'log_admin' => 
  array (
    'ttl_months' => 3,
  ),
  'htmlpurifier_disabled' => false,
  'round' => 
  array (
    'rule' => 1,
    'precision' => 2,
  ),
  'slug_type' => 'ascii',
  'google_analytic' => 'UA-172001023-21',
  'google_conversion_id' => '',
  'google_conversion_label_contact' => '',
  'google_conversion_label_vente' => '',
  'google_code_appel_ak' => '',
  'google_code_appel_cl' => '',
  'google_phone' => '',
  'facebook_pixel_id' => '',
  'cnil_number' => '',
  'enable_logo_editeur' => false,
  'enable_w3c' => false,
  'enable_fixedMenu' => '2',
  'enable_rgpd' => 0,
  'activite' => 0,
  'format_date' => '%A %d %B %Y',
  'theme_vars' => 
  array (
    'titre_menu' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'titre_adresse' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'texte_tel' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'slogan1' => 
    array (
      'fr' => 'Bienvenue à l\'hôtel-bar Le Canter',
      'en' => 'Welcome to Le Canter hotel bar',
      'es' => 'Bienvenido al bar del hotel Le Canter',
    ),
    'slogan2' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'slogan3' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'btn1' => 
    array (
      'fr' => 'Réservez',
      'en' => 'Book',
      'es' => 'Libro',
    ),
    'btn2' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'titre_bas' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
    'texte_bas' => 
    array (
      'fr' => '',
      'en' => '',
      'es' => '',
    ),
  ),
  'breadcrumb' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'pager' => 
  array (
    'nb_page_display' => '3',
    'enable_group' => false,
    'templates' => 
    array (
      'default' => 'modele-1',
      'usables' => 
      array (
      ),
    ),
  ),
  'filter' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'error' => 
  array (
    'default' => 'modele-1',
    'usables' => 
    array (
    ),
  ),
  'debug_bar' => 
  array (
    'admin' => true,
    'public' => true,
    'tabs' => 
    array (
      'super_globales' => true,
      'app' => true,
      'logs' => true,
      'db' => true,
      'tools' => true,
    ),
  ),
  'enable_theme_multi' => false,
  'news_feed' => 
  array (
    'enabled' => false,
    'url' => '',
  ),
  'dpo' => 
  array (
    'name' => '',
  ),
  'app_host' => 'https://www.hotel-lecanter.fr',
  'app_url_court' => 'https://www.hotel-lecanter.fr/',
  'self_uri' => 'https://www.hotel-lecanter.fr/en/reservation-online?send=1',
  'address' => 
  array (
    'libelle' => '',
    'company_name' => '',
    'street' => '1 Place De La Sénatorerie',
    'street_2' => '',
    'code' => '49400',
    'city' => 'Saint-Hilaire-Saint-Florent',
    'country' => 'France',
    'tel' => '02 41 50 37 88',
    'mobile' => '',
    'fax' => '',
    'email' => 'contact@hotel-lecanter.fr',
    'lat' => '47.2647675',
    'long' => '-0.1000264',
    'config_address_1' => '1',
    'config_address_2' => '1',
  ),
  'gps' => 
  array (
    'libelle' => '',
    'company_name' => '',
    'street' => '1 Place De La Sénatorerie',
    'street_2' => '',
    'code' => '49400',
    'city' => 'Saint-Hilaire-Saint-Florent',
    'country' => 'France',
    'tel' => '02 41 50 37 88',
    'mobile' => '',
    'fax' => '',
    'email' => 'contact@hotel-lecanter.fr',
    'lat' => '47.2647675',
    'long' => '-0.1000264',
    'config_address_1' => '1',
    'config_address_2' => '1',
  ),
  'schedule' => 
  array (
    'fr' => '',
    'en' => '',
    'es' => '',
  ),
  'company_name' => 'L\'hôtel Le Canter',
  'app_url' => 'https://www.hotel-lecanter.fr/en/',
)

Variables utilisateur

array (
  'id' => '1',
  'group_id' => '3',
  'civility' => '0',
  'active' => '1',
  'username' => 'Guest',
  'lastname' => '',
  'firstname' => '',
  'password' => 'Guest',
  'salt' => NULL,
  'email' => '',
  'timezone' => 'Europe/Madrid',
  'language' => 'en',
  'registered' => '0',
  'registration_ip' => '0.0.0.0',
  'last_visit' => '1595008738',
  'activate_string' => NULL,
  'activate_key' => NULL,
  'title' => 'Invité',
  'perms' => 
  array (
  ),
  'group_type' => 'C',
  'logged' => '1603192495',
  'csrf_token' => '6bc7232890f6afb0db03d5a38e8ba5f3f198dd20',
  'prev_url' => 'https://www.hotel-lecanter.fr/es/promocion',
  'is_guest' => true,
  'is_admin' => false,
  'is_superadmin' => false,
  'tmp_id' => 'tmp_5f8ec70b9d62b',
)

#	type	fichier	ligne	classe	fonction	message
# 1	Error	/www/2013/03/sa601/www/oktInc/classes/db/class.oktMysqli.php	438	oktMysqli	seterror	MySQL : 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 '' at line 1 DELETE FROM oktopusV2_mod_resa_selection WHERE id_selection =
#0 oktMysqli->execute( called at [/oktInc/classes/core/class.oktDbUtil.php:63] #1 oktDbUtil::delete( called at [/oktModules/reservation/inc/classe/class.reservation.controller.php:343] #2 reservationController->reservationSchedule( called at [/oktInc/classes/router/class.oktRouter.php:302] #3 oktRouter->callRouteHanlder( called at [/oktopus.php:58]

type

fichier

ligne

classe

fonction

message

# 1

Error

/www/2013/03/sa601/www/oktInc/classes/db/class.oktMysqli.php

438

oktMysqli

seterror

MySQL : 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 '' at line 1

DELETE FROM oktopusV2_mod_resa_selection WHERE id_selection =

#0 oktMysqli->execute( called at [/oktInc/classes/core/class.oktDbUtil.php:63]

#1 oktDbUtil::delete( called at [/oktModules/reservation/inc/classe/class.reservation.controller.php:343]

#2 reservationController->reservationSchedule( called at [/oktInc/classes/router/class.oktRouter.php:302]

#3 oktRouter->callRouteHanlder( called at [/oktopus.php:58]


SET NAMES utf8
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url FROM
oktopusV2_core_users AS u INNER JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
LEFT JOIN oktopusV2_core_users_online AS o ON
o.ident='3.238.4.24' WHERE u.id=1
UPDATE oktopusV2_core_users_online SET logged=1603192587,
prev_url='https://www.hotel-lecanter.fr/en/reservation-online?send=1'
WHERE ident='3.238.4.24'
SELECT id_selection FROM oktopusV2_mod_resa_selection 
                      WHERE UNIX_TIMESTAMP(date) + 86400 <=
UNIX_TIMESTAMP() 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut = '1' AND c.moyen_paiement
IN('cheque','virement','telephone') ORDER BY
date_reservation DESC 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
cl.id_reservation_statut IN (1,11) ORDER BY date_reservation
DESC 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '81'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '80'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '79'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '78'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '76'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '75'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '74'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '73'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '72'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '39'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '37'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '26'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '24'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '23'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '21'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '20'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '19'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '18'  ORDER BY index_selection,
libelle 
 SELECT * 
                        FROM
oktopusV2_mod_resa_reservation_detail
						WHERE id_reservation = '15'  ORDER BY index_selection,
libelle 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'reservation_statut'
SELECT u.*, g.* FROM oktopusV2_core_users AS u LEFT JOIN
oktopusV2_core_users_groups AS g ON g.group_id=u.group_id
WHERE u.active != 3 ORDER BY u.username DESC 
 SELECT c.*, cl.*, cs.nom AS nomStatut, couleur,
                        DATE_FORMAT(cl.date_creation,
'%d/%m/%Y %H:%i:%s') AS date_creation_fr,
                        DATE_FORMAT(c.date_reservation,
'%d/%m/%Y %H:%i:%s') AS date_reservation_fr,
                        DATE_FORMAT(debut, '%d/%m/%Y') AS
debut_fr, 
                        DATE_FORMAT(fin, '%d/%m/%Y') AS
fin_fr
                        FROM oktopusV2_mod_resa_reservation
c, oktopusV2_mod_resa_reservation_statut_ligne cl,
oktopusV2_mod_resa_reservation_statut cs
                        WHERE c.id_reservation_statut_ligne
= cl.id_reservation_statut_ligne AND
cl.id_reservation_statut = cs.id_reservation_statut AND
acompte != 0 AND mail_2eme_paiement IS NULL AND
cl.id_reservation_statut = '11' ORDER BY date_reservation
DESC 
 SELECT * FROM oktopusV2_mod_resa_rubrique WHERE id_parent =
'0' AND actif = '1' ORDER BY position 
SELECT id, language, valeur FROM oktopusV2_mod_resa_locales
					  WHERE `table` = 'rubrique'
SELECT *, 
					   DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, 
					   DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr  
                       FROM oktopusV2_mod_resa_selection
WHERE id_client = 'tmp_5f8ec70b9d62b'
DELETE FROM oktopusV2_mod_resa_selection WHERE id_selection
=  
OPTIMIZE TABLE oktopusV2_mod_resa_selection 
 SELECT *  
						FROM oktopusV2_mod_resa_forfait WHERE 1 ORDER BY nom 
 SELECT * FROM oktopusV2_mod_resa_rubrique r WHERE 1 AND
r.actif = '1' AND r.id_parent = 0 ORDER BY nom
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/reservation-online?send=1',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC
SELECT p.*, pl.*,
                         DATE_FORMAT(p.debut, '%d/%m/%Y') as
debut_fr,
                         DATE_FORMAT(p.fin, '%d/%m/%Y') as
fin_fr,
                         DATE_FORMAT(p.date_creation,
'%d/%m/%Y %H:%i:%s') as date_creation_fr,
                         DATE_FORMAT(p.date_modification,
'%d/%m/%Y %H:%i:%s') as date_modification_fr
                      FROM oktopusV2_mod_home_popup p
                      LEFT JOIN
oktopusV2_mod_home_popup_locales pl ON pl.id_popup =
p.id_popup AND pl.language = 'en'
                      WHERE 1 AND (
                                        CURDATE() BETWEEN
p.debut AND p.fin
                                        OR (p.debut =
'0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00')
                                    )AND pl.content <> ''
AND (p.rubrique = '' OR
FIND_IN_SET('/en/reservation-online?send=1',
pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC

ID	Query	Time
1	`SET NAMES utf8`	0.00010
2	`SELECT u., g., o.logged, o.csrf_token, o.prev_url FROM oktopusV2_core_users AS u INNER JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id LEFT JOIN oktopusV2_core_users_online AS o ON o.ident='3.238.4.24' WHERE u.id=1`	0.00291
3	`UPDATE oktopusV2_core_users_online SET logged=1603192587, prev_url='https://www.hotel-lecanter.fr/en/reservation-online?send=1' WHERE ident='3.238.4.24'`	0.00024
4	`SELECT id_selection FROM oktopusV2_mod_resa_selection WHERE UNIX_TIMESTAMP(date) + 86400 <= UNIX_TIMESTAMP()`	0.00125
5	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00309
6	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00050
7	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut = '1' AND c.moyen_paiement IN('cheque','virement','telephone') ORDER BY date_reservation DESC	0.00209
8	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00011
9	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00014
10	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00022
11	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND cl.id_reservation_statut IN (1,11) ORDER BY date_reservation DESC	0.00390
12	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '81' ORDER BY index_selection, libelle`	0.00201
13	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '80' ORDER BY index_selection, libelle`	0.00056
14	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '79' ORDER BY index_selection, libelle`	0.00025
15	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '78' ORDER BY index_selection, libelle`	0.00028
16	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '76' ORDER BY index_selection, libelle`	0.00025
17	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '75' ORDER BY index_selection, libelle`	0.00023
18	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '74' ORDER BY index_selection, libelle`	0.00028
19	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '73' ORDER BY index_selection, libelle`	0.00180
20	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '72' ORDER BY index_selection, libelle`	0.00027
21	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '39' ORDER BY index_selection, libelle`	0.00028
22	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '37' ORDER BY index_selection, libelle`	0.00024
23	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '26' ORDER BY index_selection, libelle`	0.00027
24	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '24' ORDER BY index_selection, libelle`	0.00030
25	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '23' ORDER BY index_selection, libelle`	0.00026
26	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '21' ORDER BY index_selection, libelle`	0.00028
27	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '20' ORDER BY index_selection, libelle`	0.00024
28	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '19' ORDER BY index_selection, libelle`	0.00026
29	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '18' ORDER BY index_selection, libelle`	0.00025
30	`SELECT * FROM oktopusV2_mod_resa_reservation_detail WHERE id_reservation = '15' ORDER BY index_selection, libelle`	0.00024
31	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'reservation_statut'	0.00012
32	`SELECT u., g. FROM oktopusV2_core_users AS u LEFT JOIN oktopusV2_core_users_groups AS g ON g.group_id=u.group_id WHERE u.active != 3 ORDER BY u.username DESC`	0.00016
33	SELECT c., cl., cs.nom AS nomStatut, couleur, DATE_FORMAT(cl.date_creation, '%d/%m/%Y %H:%i:%s') AS date_creation_fr, DATE_FORMAT(c.date_reservation, '%d/%m/%Y %H:%i:%s') AS date_reservation_fr, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_reservation c, oktopusV2_mod_resa_reservation_statut_ligne cl, oktopusV2_mod_resa_reservation_statut cs WHERE c.id_reservation_statut_ligne = cl.id_reservation_statut_ligne AND cl.id_reservation_statut = cs.id_reservation_statut AND acompte != 0 AND mail_2eme_paiement IS NULL AND cl.id_reservation_statut = '11' ORDER BY date_reservation DESC	0.00320
34	`SELECT * FROM oktopusV2_mod_resa_rubrique WHERE id_parent = '0' AND actif = '1' ORDER BY position`	0.00160
35	SELECT id, language, valeur FROM oktopusV2_mod_resa_locales WHERE `table` = 'rubrique'	0.00069
36	`SELECT *, DATE_FORMAT(debut, '%d/%m/%Y') AS debut_fr, DATE_FORMAT(fin, '%d/%m/%Y') AS fin_fr FROM oktopusV2_mod_resa_selection WHERE id_client = 'tmp_5f8ec70b9d62b'`	0.00275
37	`DELETE FROM oktopusV2_mod_resa_selection WHERE id_selection =`	0.00013
38	`OPTIMIZE TABLE oktopusV2_mod_resa_selection`	0.00025
39	`SELECT * FROM oktopusV2_mod_resa_forfait WHERE 1 ORDER BY nom`	0.00146
40	`SELECT * FROM oktopusV2_mod_resa_rubrique r WHERE 1 AND r.actif = '1' AND r.id_parent = 0 ORDER BY nom`	0.00022
41	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/reservation-online?send=1', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00226
42	SELECT p., pl., DATE_FORMAT(p.debut, '%d/%m/%Y') as debut_fr, DATE_FORMAT(p.fin, '%d/%m/%Y') as fin_fr, DATE_FORMAT(p.date_creation, '%d/%m/%Y %H:%i:%s') as date_creation_fr, DATE_FORMAT(p.date_modification, '%d/%m/%Y %H:%i:%s') as date_modification_fr FROM oktopusV2_mod_home_popup p LEFT JOIN oktopusV2_mod_home_popup_locales pl ON pl.id_popup = p.id_popup AND pl.language = 'en' WHERE 1 AND ( CURDATE() BETWEEN p.debut AND p.fin OR (p.debut = '0000-00-00 00:00:00' AND p.fin = '0000-00-00 00:00:00') )AND pl.content <> '' AND (p.rubrique = '' OR FIND_IN_SET('/en/reservation-online?send=1', pl.rubrique_slug) > 0) ORDER BY p.rubrique DESC	0.00036

Mémoire utilisée par PHP : 9.98 MB
Pic mémoire allouée par PHP : 10.99 MB
Temps d'execution du script : 0.681 s

Lang : en
Path : reservation-online
Route : reservationSchedule

$okt->page->module : reservation
$okt->page->action :

_GET (2)
_SERVER (36)
_REQUEST (2)