DenaliShop Posted April 27, 2023 Share Posted April 27, 2023 Just come across our first ever error using the 1 click upgrade module to move from v8.0.3 to v8.0.4 Error below. Resulting error causings a htpp 500 error across the site unless rolled back - throwing a upgrade database schema error - anyone else had this Link to comment Share on other sites More sharing options...
DenaliShop Posted April 27, 2023 Author Share Posted April 27, 2023 Updating database schema... An exception occurred while executing 'ALTER TABLE ps_psgdpr_consent CHANGE id_gdpr_consent id_gdpr_consent INT AUTO_INCREMENT NOT NULL, CHANGE id_mod ule id_module INT NOT NULL, CHANGE active active TINYINT(1) NOT NULL, CHANG E error error TINYINT(1) NOT NULL, CHANGE error_message error_message VARCH AR(255) NOT NULL': SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key In Exception.php line 18: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key In PDOConnection.php line 141: SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key 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]] [--] ---------------------------- Error during database upgrade. You may need to restore your database. Error upgrading Doctrine schema Link to comment Share on other sites More sharing options...
CMeier Software Posted April 28, 2023 Share Posted April 28, 2023 I've got the same issue from v8.0.2 to v8.0.4. Link to comment Share on other sites More sharing options...
planetarivs Posted October 11, 2023 Share Posted October 11, 2023 Anyone came across the solution? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now