Hello, I'm trying to upgrade from v2 to v3.
I did a clean reinstall and now try to import the exported database from my previous version.
I keep on getting errors when importing tables, even step by step.
Below you see 1 problem already.
How can I fix these or is there a database migration script?
You seem to have tracked down a bug from v3.0.2.0. As per the message indicates, you have missing fields on the database which, in this case, would be in the customer table. The approved field is missing or even perhaps this field should of been removed from the catalog/model/extension/payment/amazon_login_pay.php file in the addCustomer() method.
Let's assume it should of been added. In your PHPMyAdmin, click on your Opencart database. Then, in your SQL tab, execute the following query statement:
Note: change: `oc_ with your actual database table prefix name if using another one. Then, execute the query and refresh the page where the error message posted occurs to see if that rectifies the issue.
Let's assume it should of been added. In your PHPMyAdmin, click on your Opencart database. Then, in your SQL tab, execute the following query statement:
Code: Select all
ALTER TABLE `oc_customer` ADD `approval` INT(1) NOT NULL;
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
This issue has now been reported regarding the field name: Approval.
Dedication and passion goes to those who are able to push and merge a project.
Regards,
Straightlight
Programmer / Opencart Tester
Who is online
Users browsing this forum: No registered users and 105 guests