Skip to content

Instantly share code, notes, and snippets.

@Zulgrib

Zulgrib/log.txt Secret

Created November 1, 2022 15:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Zulgrib/b92f318abacea4b679ec734867b74b1f to your computer and use it in GitHub Desktop.
Save Zulgrib/b92f318abacea4b679ec734867b74b1f to your computer and use it in GitHub Desktop.
Erreur migration bdd de 1.7.8.6 a 1.7.8.7
[OK] SQL 1.7.8.7 SET SESSION sql_mode=''
[OK] SQL 1.7.8.7 SET NAMES 'utf8mb4'
[OK] SQL 1.7.8.7 DELETE FROM `ps_smarty_cache`
Updating database schema...
Executing: ALTER TABLE ps_product_download CHANGE display_filename display_filename VARCHAR(255) DEFAULT NULL, CHANGE filename filename VARCHAR(255) DEFAULT NULL, CHANGE date_expiration date_expiration DATETIME DEFAULT NULL, CHANGE nb_days_accessible nb_days_accessible INT UNSIGNED DEFAULT NULL
Executing: ALTER TABLE ps_translation CHANGE theme theme VARCHAR(32) DEFAULT NULL
Executing: ALTER TABLE ps_stock_mvt CHANGE id_order id_order INT DEFAULT NULL, CHANGE id_supply_order id_supply_order INT DEFAULT NULL, CHANGE employee_lastname employee_lastname VARCHAR(32) DEFAULT NULL, CHANGE employee_firstname employee_firstname VARCHAR(32) DEFAULT NULL, CHANGE referer referer BIGINT DEFAULT NULL
Executing: ALTER TABLE ps_tab CHANGE module module VARCHAR(64) DEFAULT NULL, CHANGE route_name route_name VARCHAR(256) DEFAULT NULL, CHANGE icon icon VARCHAR(32) DEFAULT NULL, CHANGE wording wording VARCHAR(255) DEFAULT NULL, CHANGE wording_domain wording_domain VARCHAR(255) DEFAULT NULL
Executing: ALTER TABLE ps_feature_flag CHANGE state state TINYINT(1) DEFAULT '0', CHANGE label_wording label_wording VARCHAR(191) DEFAULT '', CHANGE label_domain label_domain VARCHAR(255) DEFAULT '', CHANGE description_wording description_wording VARCHAR(191) DEFAULT '', CHANGE description_domain description_domain VARCHAR(255) DEFAULT ''
Executing: ALTER TABLE ps_product_comment_criterion CHANGE id_product_comment_criterion id_product_comment_criterion INT AUTO_INCREMENT NOT NULL, CHANGE id_product_comment_criterion_type id_product_comment_criterion_type INT NOT NULL
Executing: ALTER TABLE ps_product_comment_report CHANGE id_product_comment id_product_comment INT NOT NULL, CHANGE id_customer id_customer INT NOT NULL
Executing: CREATE INDEX IDX_C2608AB0ACF38A54 ON ps_product_comment_report (id_product_comment)
Executing: DROP INDEX id_product ON ps_product_comment
Executing: DROP INDEX id_guest ON ps_product_comment
Executing: DROP INDEX id_customer ON ps_product_comment
Executing: ALTER TABLE ps_product_comment CHANGE id_product_comment id_product_comment INT AUTO_INCREMENT NOT NULL, CHANGE id_product id_product INT NOT NULL, CHANGE id_customer id_customer INT NOT NULL, CHANGE id_guest id_guest INT NOT NULL, CHANGE title title VARCHAR(64) NOT NULL, CHANGE customer_name customer_name VARCHAR(64) NOT NULL, CHANGE grade grade INT NOT NULL
Executing: ALTER TABLE ps_product_comment_grade CHANGE id_product_comment id_product_comment INT NOT NULL, CHANGE id_product_comment_criterion id_product_comment_criterion INT NOT NULL, CHANGE grade grade INT NOT NULL
Executing: CREATE INDEX IDX_A0128571ACF38A54 ON ps_product_comment_grade (id_product_comment)
Executing: ALTER TABLE ps_product_comment_grade RENAME INDEX id_product_comment_criterion TO IDX_A01285718375853C
16:21:04 ERROR [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "An exception occurred while executing 'ALTER TABLE ps_product_comment_grade RENAME INDEX id_product_comment_criterion TO IDX_A01285718375853C':
SQLSTATE[42000]: Syntax error or access violation: 1064 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 'INDEX id_product_comment_criterion TO IDX_A01285718375853C' at line 1" ["exception" => Doctrine\DBAL\Exception\SyntaxErrorException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => """ An exception occurred while executing 'ALTER TABLE ps_product_comment_grade RENAME INDEX id_product_comment_criterion TO IDX_A01285718375853C':\n \n SQLSTATE[42000]: Syntax error or access violation: 1064 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 'INDEX id_product_comment_criterion TO IDX_A01285718375853C' at line 1 """]
In AbstractMySQLDriver.php line 79:
An exception occurred while executing 'ALTER TABLE ps_product_comment_grade
RENAME INDEX id_product_comment_criterion TO IDX_A01285718375853C':
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'INDEX id_product_comment_criteri
on TO IDX_A01285718375853C' at line 1
In PDOConnection.php line 90:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'INDEX id_product_comment_criteri
on TO IDX_A01285718375853C' at line 1
In PDOConnection.php line 88:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near 'INDEX id_product_comment_criteri
on TO IDX_A01285718375853C' at line 1
prestashop:schema:update-without-foreign [-h|--help] [-q|--quiet] [-v|vv|vvv|--verbose] [-V|--version] [--ansi] [--no-ansi] [-n|--no-interaction] [-e|--env ENV] [--no-debug] [--id_shop [ID_SHOP]] [--id_shop_group [ID_SHOP_GROUP]] [--]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment