Andrey
Andrey
Offline
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:

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>
Thursday, June 18 2015, 02:56 PM
Share this post:
Responses (30)
  • Accepted Answer

    Friday, September 02 2016, 12:05 AM - #Permalink
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 04:43 PM - #Permalink
    No, it's not for OC 1.5. Then you must upgrade to OC 2 first, before migrating to Arastta from there.
    Go for the migration service, going directly from OC 1.5 to Arastta, and save us all a lot of trouble. ;)
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 04:37 PM - #Permalink
    Actually my OC is 1.5.6. I assumed the extention would onlu work with v2 since it had 2 in it's name, but can it also be used on v1.5?

    If not, I might try the paid option
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 04:08 PM - #Permalink
    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.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 04:02 PM - #Permalink
    I've installed the one from the markedplace, but it fails like in the OP... The changes on the extention in the GitHub repo seems to only have fixed some semantics?
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 03:51 PM - #Permalink
    @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
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, September 01 2016, 03:45 PM - #Permalink
    @Dennis Dulici, could you send me your code? I can PM you my email, but since you're admin I suppose you can already see it? ;)
    The reply is currently minimized Show
  • Accepted Answer

    Monday, March 14 2016, 12:13 PM - #Permalink
    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 ...
    The reply is currently minimized Show
  • Accepted Answer

    Friday, March 04 2016, 09:50 PM - #Permalink
    Tested the latest version of the migrator, and it failed with quite many errors.
    Found this topic and tested the file from Andrey, and it worked after removing Google Analytics code and
    TRUNCATE TABLE `__modification`;
    from the backup file.
    Hm ...
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Wednesday, July 15 2015, 08:34 PM - #Permalink
    No problem, please do it.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, July 15 2015, 06:52 PM - #Permalink
    If you allow me to upload your code, I can do that from my account.
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Tuesday, July 14 2015, 07:14 PM - #Permalink
    I've tried to do it. I'm not sure, because I'm not familiar with Git.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, July 13 2015, 07:55 AM - #Permalink
    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
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Sunday, July 12 2015, 04:12 PM - #Permalink
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, July 12 2015, 04:14 AM - #Permalink
    Strange.. Can you please upload to file sharing sites and past the download link here so we could see it's content?
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Saturday, July 11 2015, 11:14 PM - #Permalink
    25 Kb or 4Kb in zip
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, July 11 2015, 11:12 PM - #Permalink
    What is the file size?
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Saturday, July 11 2015, 10:44 PM - #Permalink
    The same. Click on Reply and nothing happens.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, July 11 2015, 07:32 PM - #Permalink
    Have you tried to ZIP the file?
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Saturday, July 11 2015, 12:51 PM - #Permalink
    I couldn't attach the file and forum banned me for a day :(
    The reply is currently minimized Show
Your Reply