Dominik
Dominik
Offline
Hey guys

I'm tired of Opencart 2 and tried to import my database to Arastta. First, the extension download fails (I don't know if it really fails, I get an error message but it says it was successfulll...) as you can see in my arastta.jpg screenshot but it is installed after the error (at least I think it is). When I try to import my database I get the error on dbimport.JPG

Am I doing something wrong?

Thanks

Dom
Attachments:
Thursday, June 11 2015, 11:30 PM
Share this post:

Accepted Answer

Dominik
Dominik
Offline
Friday, June 12 2015, 09:11 PM - #Permalink
these are the columns i had to delete for the import to work:
oc_customer_group
company_id_display
company_id_required
tax_id_display
company_id_required
oc_language
filename
oc_order
payment_company_id
payment_tax_id
oc_order_total
text
oc_address
company_id
tax_id
oc_setting
group
The reply is currently minimized Show
Responses (15)
  • Accepted Answer

    Wednesday, June 17 2015, 04:15 PM - #Permalink
    Denis Dulici wrote:

    The OC2 migration script has been updated with these issues solved. Thanks for your feedback ;)


    For security reasons, some tables are not deleted from the database.
    These are OC 1.4.7 - 1.4.9.x versions tables product_option_description and product_option_value_description.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, June 17 2015, 04:01 PM - #Permalink
    The OC2 migration script has been updated with these issues solved. Thanks for your feedback ;)
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Wednesday, June 17 2015, 01:50 PM - #Permalink
    I don't think, that exist many shops on OC 2, because it's not usable for really business.
    So it's more important to make working converter from 1.5.
    The reply is currently minimized Show
  • Accepted Answer

    Dominik
    Dominik
    Offline
    Monday, June 15 2015, 08:54 PM - #Permalink
    I think migration from OC 1.5 would be really important. To get 2.x working you have to edit codes, fields in the database and so on, it's a pain.

    To migrate from 1.5 directly to Arassta would be great.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, June 15 2015, 07:13 PM - #Permalink
    We're working on this issue for OC2 https://github.com/arastta/arastta/issues/81

    But for OC1.5 I guess we need the help from @Pekka
    The reply is currently minimized Show
  • Accepted Answer

    Monday, June 15 2015, 05:18 PM - #Permalink
    Arastta is getting more and more attention because more answers on the OC-Forum from frustated users pointing partly directly to Arastta.
    Because of that it would be good to know that the migration from OC 1.5.x. and 2.x will work.
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Sunday, June 14 2015, 11:40 AM - #Permalink
    I've converted the OC 2 database into the Arastta. The following columns was deleted.

    ALTER TABLE `oc_address` DROP `company_id`;
    ALTER TABLE `oc_address` DROP `tax_id`;
    ALTER TABLE `oc_address` DROP `company_id`;
    ALTER TABLE `oc_address` DROP `tax_id`;
    ALTER TABLE `oc_language` DROP `filename`;
    ALTER TABLE `oc_order` DROP `payment_company_id`;

    It was also a problem with oc_customer_transaction table, but I simple cleared this table from backup.

    After the import it's needed to change path to languages in admin->localisation->languages from "english" to "en-GB".

    My OC 2 template and Russian language seems to be usable.

    In OC 2 I have an Ocmod, which adds/change some language variables in controllers and languages. How is better to do in Arastta - further use this ocmod or there is a better way?
    The reply is currently minimized Show
  • Accepted Answer

    Dominik
    Dominik
    Offline
    Friday, June 12 2015, 09:01 PM - #Permalink
    I am now dropping every column the importer does not like:
    oc_customer_group
    company_id_display
    company_id_required
    tax_id_display
    company_id_required
    oc_language
    filename
    oc_order
    payment_company_id
    +1
    oc_order_total
    text

    to be continued...
    The reply is currently minimized Show
  • Accepted Answer

    Friday, June 12 2015, 08:40 PM - #Permalink
    Dominik wrote:

    Hi

    same here like Andrey, same OC version 1, same OC version 2.

    Should I try to delete the columns tax_id, address and company_id?

    Thanks

    Dom

    Yes, if your version on OC 2.0.x.

    This issue is fixed my Migration:
    https://github.com/pekka2/opencart-migration-upgrade-tool/commit/3b254cdb085adf2428241d69b2e3c10010637f2c
    The reply is currently minimized Show
  • Accepted Answer

    Dominik
    Dominik
    Offline
    Friday, June 12 2015, 07:19 PM - #Permalink
    Hi

    same here like Andrey, same OC version 1, same OC version 2.

    Should I try to delete the columns tax_id, address and company_id?

    Thanks

    Dom
    The reply is currently minimized Show
  • Accepted Answer

    Friday, June 12 2015, 07:11 PM - #Permalink
    Andrey wrote:

    Hi, it was converted from 1.5.6 by Pekka's converter.
    I'll try to delete this column from my OC database.


    You delete also column "tax_id" from table "address"
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Friday, June 12 2015, 05:33 PM - #Permalink
    Hi, it was converted from 1.5.6 by Pekka's converter.
    I'll try to delete this column from my OC database.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, June 12 2015, 04:08 PM - #Permalink
    Andrey wrote:

    I have the same JSON error during importing my opencart 2 database

    SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
    OK
    <b>Notice</b>: Error: Unknown column 'company_id' in 'field list'Error No: 1054INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `company_id`, `tax_id`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`, `custom_field`) VALUES ('7', '6', '***', '***', '', '', '', '***', '***', '***', '***', '***', '***', '') in <b>/mnt/wwwhost/***/system/library/db/mysqli.php</b> on line <b>49</b>


    Opencart 2.0.3.1 and Arasta 1.0.5

    Extension was installed without any error.


    Hi.

    Are your store database structure clean OC 2 version? That column `company_id` is holdover from version 1.5.x.
    The reply is currently minimized Show
  • Accepted Answer

    Andrey
    Andrey
    Offline
    Friday, June 12 2015, 12:25 PM - #Permalink
    I have the same JSON error during importing my opencart 2 database

    SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data
    OK
    <b>Notice</b>: Error: Unknown column 'company_id' in 'field list'Error No: 1054INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `company_id`, `tax_id`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`, `custom_field`) VALUES ('7', '6', '***', '***', '', '', '', '***', '***', '***', '***', '***', '***', '') in <b>/mnt/wwwhost/***/system/library/db/mysqli.php</b> on line <b>49</b>


    Opencart 2.0.3.1 and Arasta 1.0.5

    Extension was installed without any error.
    The reply is currently minimized Show
  • Accepted Answer

    Friday, June 12 2015, 11:09 AM - #Permalink
    Hi Dominik,

    What is the exact OC version you're trying to upgrade from?

    Regards
    The reply is currently minimized Show
Your Reply