Hi Dominik,

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

Regards

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.

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.

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

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"

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

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

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...

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?

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.

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

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.

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 OC2 migration script has been updated with these issues solved. Thanks for your feedback

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.