Martin C

Solved removed the buckaroo tables update Prestashop and added the Buckaroo tables again.

Probably the query is wrong: ALTER TABLE ps_bk_payment_methods CHANGE created_at created_at DATETIME NOT NULL DEFAULT 'current_timestamp()' This must be without quotes to be accepted by MariaDB: ALTER TABLE ps_bk_payment_methods CHANGE created_at created_at DATETIME NOT NULL DEFAULT current_timestamp() IS MySQL configured wrong or is it a prestashop upgrade bug?

Thanks but not not the same issue.

Yes i know that but i want to know which changes you have to make to fully update the database schema. I found out that the queries are made on the fly by the UpdateSchemaCommand.php file. Is it only the table ALTER TABLE ps_bk_payment_methods which fails or is the update script stepping out of the function because of the error and there are more tables which must be altered? Martin

Why does the update fail?

Update prestashop from 8.1.2 to 8.1.5 with 1-Click Upgrade module version 5.0.1. Updating database schema fails: Mariadb version 10.6.17. How can i manually execute the queries to update the database schema? Where can i find the queries? Updating database schema... Executing: ALTER TABLE ps_feature_flag CHANGE state state TINYINT(1) DEFAULT '0' Executing: AtTER TABLE ps_tab DROP hide_host_mode Executing: ALTER TABLE ps_translation CHANGE `key` `key` TEXT NOT NULL COLLATE `utf8_bin` Executing: ALTER TABLE ps_bk_payment_methods CHANGE created_at created_at DATETIME NOT NULL DEFAULT 'current_timestamp()' , CHANGE updated_at updated_at DATETIME NOT NULL 19:32:17 CRITICAL [console] Error thrown while running command "prestashop:schema:update-without-foreign --env=prod". Message: "An exception occurred while executing 'ALTER TABLE ps_C CHANGE created_at created_at DATETIME NOT NULL DEFAULT 'current_timestamp()' , CHANGE updated_at updated_at DATETIME NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_at'" ["exception" => Doctrine\DBAL\Exception\DriverException { …},"command" => "prestashop:schema:update-without-foreign --env=prod","message" => """ An exception occurred while executing 'ALTER TABLE ps_bk_payment_methods CHANGE created_at created_at DATETIME NOT NULL DEFAULT 'current_timestamp()' , CHANGE updated_at updated_at DATETIME NOT NULL':\n \n SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'created_at' """] In AbstractMySQLDriver.php line 128: An exception occurred while executing 'ALTER TABLE ps_bk_payment_methods CH ANGE created_at created_at DATETIME NOT NULL DEFAULT 'current_timestamp()' , CHANGE updated_at updated_at DATETIME NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default val ue for 'created_at' In Exception.php line 18: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default val ue for 'created_at' In PDOConnection.php line 141: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default val ue for 'created_at' 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]] [--]

Thank you for your reply Lamya. I will try that.

I think i have to wait for the 8.1.3 version. I'm not skilled enough to solve this issue. Martin

PHP 7.4.33. Because it must be compatible with the production shop which runs 1.7.8.2

Prestashop 8,1,2. When I edit the text of a product image, an error occurs: function(){return r&&o(s,r),(e.migrateIsPatchEnabled(s)?i:a||e.noop).apply(this,arguments)}

Prestashop 8.1.2. When I edit the text of a product image, an error occurs: function(){return r&&o(s,r),(e.migrateIsPatchEnabled(s)?i:a||e.noop).apply(this,arguments)} Can anyone tell me what's going on and how I can fix this error? Martin

Can somebody tell me how to skip notice "Errors" in debug mode.

I have a strange issue which i don't understand. When i edit a product the product will dissapear from the search result in the frontend of the shop. Automatic reindex of the product is "on" in the backend . After a manual reindexation the product is searchable. But of course i prefer automatic reindex after editing an product. Who can help me with this issue? I'm running Prestashop 1.7.6.1. Martin

But what did Crezzur to get rid of the error message?

I have the same problem. Anybody with a solution?