OC 2.3.1 with a database imported from OC 1.5.6 with latest Pekka's migration tool.
Clean Arastta 1.0.6 with freshly installed extension.
If I try to import a database I get an error:
Clean Arastta 1.0.6 with freshly installed extension.
If I try to import a database I get an error:
SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
OK
<b>Notice</b>: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1Error No: 1064INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`, `custom_field`) VALUES ('9', '8', '***', '***', '', '***', '', '***', '***', '***'; in <b>/mnt/wwwhost/****/system/library/db/mysqli.php</b> on line <b>49</b>
In Extensions
Share this post:
Responses (30)
-
Accepted Answer
You can btw take a look at this old post too: https://arastta.org/forum/tip-how-to-upgrade-update-opencart-2-migrate-it-to-arastta -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
Then you have the code available, and if needed you can try to fix it and make a PR on GitHub.
But I would rater used the migration service, especially if your OC is newer than 2.0.x
Edit! Last time I used the script it had to be adjusted because extensions had added fields to tables etc, so they didn't match. Really not worth the hassle when there is a more automated service handling most of those issues. -
Accepted Answer
-
Accepted Answer
@Jørn, the code is available at the Marketplace (install directly from admin) and GitHub.
Here: https://extensions.arastta.pro/tools/opencart-2-migration
And here: https://github.com/arastta/addons/tree/master/tools/ext_opencart2_arastta
But you could also save you some possible trouble, and go for: https://arastta.org/migrate -
Accepted Answer
-
Accepted Answer
A few things I have noticed with the latest version:
In _address and _order table, it doesn't handle commas and parenthesis (brackets) in the address fields.
In _order table it doesn’t handle all browser and language info (user_agent and accepted_language).
Also in _order table it fails on shipping_method data like 'Norway (Weight: 0.30kg)', probably the parenthesis again.
Plus it fails if Google Analytics code is set in settings.
For databases migrated from OC 1.5.6.4 to 2.1.0.1 it seems like it fails because of different field ordering in _order table.
If modifications has added extra fields, it will probably fail also then, had to delete one in products table, added by a well known options extension ... -
Accepted Answer
-
Accepted Answer
-
Accepted Answer
-
Accepted Answer
That seems to be filtered by our firewall because of being a PHP file.
Andrey, can you please send a Pull Request via GitHub so that we could evaluate it?
https://github.com/arastta/addons/tree/master/tools/ext_opencart2_arastta
Regards -
Accepted Answer
Your Reply
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here.
Register Here »