Page 1 of 1
import databse upgrade Version 2.0.1.1 to 3.0.2.0
Posted: Fri Oct 27, 2017 1:24 am
by godly75
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?
Re: import databse upgrade Version 2.0.1.1 to 3.0.2.0
Posted: Fri Oct 27, 2017 3:04 am
by straightlight
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:
Code: Select all
ALTER TABLE `oc_customer` ADD `approval` INT(1) NOT NULL;
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.
Re: import databse upgrade Version 2.0.1.1 to 3.0.2.0
Posted: Fri Oct 27, 2017 3:07 am
by straightlight
This issue has now been reported regarding the field name: Approval.
Re: import databse upgrade Version 2.0.1.1 to 3.0.2.0
Posted: Fri Apr 13, 2018 11:03 pm
by shablamy
Hi,
I have the same issue... However my error from the GUI is attached.
Process:
DB Backup from v2.0.1.1
Restore to new install of v3.0.2.0
Please help?