Dans le log, j'ai un fichier nommé 20251103_exception.log avec ce contenu :
*ERROR* 2025/11/03 - 21:43:32: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`...' at line 18
CREATE TABLE `ps_customer` (
`id_customer` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(11) unsigned DEFAULT NULL,
`id_default_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_lang` int(11) unsigned DEFAULT NULL,
`id_risk` int(11) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(64) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`phone` varchar(32) DEFAULT NULL,
`passwd` varchar(128) NOT NULL,
`md5_control` varchar(32) DEFAULT NULL
`secret_key` varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`last_passwd_modified` timestamp NOT NULL DEFAULT current_timestamp(),
`temp_key` varchar(64) DEFAULT NULL,
`last_temp_key` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`code` int(6) NULL,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(40) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(11) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`),
KEY `temp_key` (`temp_key`),
KEY `active` (`active`)
KEY `md5_control` (`md5_control`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci
*ERROR* 2025/11/03 - 21:45:58: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`...' at line 18
CREATE TABLE `ps_customer` (
`id_customer` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(11) unsigned DEFAULT NULL,
`id_default_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_lang` int(11) unsigned DEFAULT NULL,
`id_risk` int(11) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(64) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`phone` varchar(32) DEFAULT NULL,
`passwd` varchar(128) NOT NULL,
`md5_control` varchar(32) DEFAULT NULL
`secret_key` varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`last_passwd_modified` timestamp NOT NULL DEFAULT current_timestamp(),
`temp_key` varchar(64) DEFAULT NULL,
`last_temp_key` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`code` int(6) NULL,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(40) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(11) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`),
KEY `temp_key` (`temp_key`),
KEY `active` (`active`)
KEY `md5_control` (`md5_control`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci
*ERROR* 2025/11/03 - 21:46:03: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`...' at line 18
CREATE TABLE `ps_customer` (
`id_customer` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(11) unsigned DEFAULT NULL,
`id_default_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_lang` int(11) unsigned DEFAULT NULL,
`id_risk` int(11) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(64) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`phone` varchar(32) DEFAULT NULL,
`passwd` varchar(128) NOT NULL,
`md5_control` varchar(32) DEFAULT NULL
`secret_key` varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`last_passwd_modified` timestamp NOT NULL DEFAULT current_timestamp(),
`temp_key` varchar(64) DEFAULT NULL,
`last_temp_key` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`code` int(6) NULL,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(40) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(11) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`),
KEY `temp_key` (`temp_key`),
KEY `active` (`active`)
KEY `md5_control` (`md5_control`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci
*ERROR* 2025/11/03 - 21:46:06: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`...' at line 18
CREATE TABLE `ps_customer` (
`id_customer` int(11) unsigned NOT NULL AUTO_INCREMENT,
`id_shop_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_shop` int(11) unsigned NOT NULL DEFAULT 1,
`id_gender` int(11) unsigned DEFAULT NULL,
`id_default_group` int(11) unsigned NOT NULL DEFAULT 1,
`id_lang` int(11) unsigned DEFAULT NULL,
`id_risk` int(11) unsigned NOT NULL DEFAULT 1,
`company` varchar(64) DEFAULT NULL,
`siret` varchar(64) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
`firstname` varchar(32) NOT NULL,
`lastname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
`phone` varchar(32) DEFAULT NULL,
`passwd` varchar(128) NOT NULL,
`md5_control` varchar(32) DEFAULT NULL
`secret_key` varchar(48) DEFAULT NULL,
`tfa` tinyint(1) unsigned NOT NULL DEFAULT 0,
`last_passwd_gen` timestamp NOT NULL DEFAULT current_timestamp(),
`last_passwd_modified` timestamp NOT NULL DEFAULT current_timestamp(),
`temp_key` varchar(64) DEFAULT NULL,
`last_temp_key` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`code` int(6) NULL,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT 0,
`ip_registration_newsletter` varchar(40) DEFAULT NULL,
`newsletter_date_add` datetime DEFAULT NULL,
`optin` tinyint(1) unsigned NOT NULL DEFAULT 0,
`website` varchar(128) DEFAULT NULL,
`outstanding_allow_amount` decimal(20,6) NOT NULL DEFAULT 0.000000,
`show_public_prices` tinyint(1) unsigned NOT NULL DEFAULT 0,
`max_payment_days` int(11) unsigned NOT NULL DEFAULT 60,
`secure_key` varchar(32) NOT NULL DEFAULT '-1',
`note` text DEFAULT NULL,
`active` tinyint(1) unsigned NOT NULL DEFAULT 0,
`is_guest` tinyint(1) NOT NULL DEFAULT 0,
`deleted` tinyint(1) NOT NULL DEFAULT 0,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
KEY `id_customer_passwd` (`id_customer`,`passwd`),
KEY `id_gender` (`id_gender`),
KEY `id_shop_group` (`id_shop_group`),
KEY `id_shop` (`id_shop`,`date_add`),
KEY `temp_key` (`temp_key`),
KEY `active` (`active`)
KEY `md5_control` (`md5_control`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci
