Post by mcurtis » Fri Oct 10, 2014 9:14 pm

Not sure if this is possibly yet as i am not sure if the fields match up. But i am wondering if i can import my database of 700+ product store from 1.5.6 to 2.0? If so, is it better to copy the database over and just have 2.0 point to it or do an export and import? Thoughts?

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by beipink » Fri Oct 10, 2014 11:33 pm

There is no upgrade script as yet. The DB of OC 1.5.6 is different to OC2.0

Active Member

Posts

Joined
Tue Mar 20, 2012 7:43 pm

Post by mcurtis » Fri Oct 10, 2014 11:44 pm

Ok thank you. i will just wait.

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by dzastinaslt » Sat Oct 11, 2014 6:50 pm

Hello. I did it on clean 2.0 install by restoring from my current 1.5.6.4 and it worked! Just filled some missing fields. Old order list didn't went trough though... Also there was some strange bug when taxes weren't added to the price yesterday but I checked today and they work properly now (maybe some cache cleaning would help instantly) I have a banner problem though-

EDIT: apparentally there was some HTML content tabs in category layout that was causing this. I removed them and there's no more error.

Code: Select all

Notice: Undefined index: width in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 12Notice: Undefined index: height in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 13Notice: Undefined index: banner_id in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 17

New member

Posts

Joined
Mon Mar 05, 2012 6:01 pm

Post by beipink » Sat Oct 11, 2014 7:46 pm

DB tables differences between OC1.5.5.1 and OC2.0.0:

Code: Select all

oc_address
        Field company differs between databases for parameter 'Type'. oc1551 -> has 'varchar(32)' and oc20 -> has 'varchar(40)'.
        oc20 -> is missing field: company_id
        oc20 -> is missing field: tax_id
        Field country_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field zone_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        oc1551 -> is missing field: custom_field
    oc_affiliate
        Field company differs between databases for parameter 'Type'. oc1551 -> has 'varchar(32)' and oc20 -> has 'varchar(40)'.
    oc_banner_image
        oc1551 -> is missing field: sort_order
    oc_category
        Field parent_id differs between databases for parameter 'Key'. oc1551 -> has '' and oc20 -> has 'MUL'.
        Field parent_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field sort_order differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_category_description
        oc20 -> is missing field: cptitle
        oc1551 -> is missing field: meta_title
    oc_coupon
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_currency
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_custom_field
        oc20 -> is missing field: required
        Field location differs between databases for parameter 'Type'. oc1551 -> has 'varchar(32)' and oc20 -> has 'varchar(7)'.
        oc20 -> is missing field: position
        oc1551 -> is missing field: status
    oc_custom_field_to_customer_group
        oc20 -> is missing table: oc_custom_field_to_customer_group.
    oc_customer
        Field store_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field newsletter differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field address_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        oc1551 -> is missing field: custom_field
        oc1551 -> is missing field: safe
    oc_customer_field
        oc20 -> is missing table: oc_customer_field.
    oc_customer_group
        oc20 -> is missing field: company_id_display
        oc20 -> is missing field: company_id_required
        oc20 -> is missing field: tax_id_display
        oc20 -> is missing field: tax_id_required
    oc_customer_reward
        Field customer_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field order_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field points differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_download
        oc20 -> is missing field: remaining
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_geo_zone
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_information
        Field bottom differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field sort_order differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_information_description
        oc20 -> is missing field: cptitle
        oc1551 -> is missing field: meta_title
        oc1551 -> is missing field: meta_description
        oc1551 -> is missing field: meta_keyword
    oc_language
        Field sort_order differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_order
        Field invoice_no differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field store_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field customer_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field customer_group_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field payment_company differs between databases for parameter 'Type'. oc1551 -> has 'varchar(32)' and oc20 -> has 'varchar(40)'.
        oc20 -> is missing field: payment_company_id
        oc20 -> is missing field: payment_tax_id
        Field shipping_company differs between databases for parameter 'Type'. oc1551 -> has 'varchar(32)' and oc20 -> has 'varchar(40)'.
        Field order_status_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        oc1551 -> is missing field: custom_field
        oc1551 -> is missing field: payment_custom_field
        oc1551 -> is missing field: shipping_custom_field
        oc1551 -> is missing field: marketing_id
        oc1551 -> is missing field: tracking
    oc_order_download
        oc20 -> is missing table: oc_order_download.
    oc_order_field
        oc20 -> is missing table: oc_order_field.
    oc_order_fraud
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_order_history
        Field notify differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_order_option
        Field product_option_value_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_order_recurring
        oc20 -> is missing field: created
        oc20 -> is missing field: profile_id
        oc20 -> is missing field: profile_name
        oc20 -> is missing field: profile_description
        oc20 -> is missing field: profile_reference
        oc1551 -> is missing field: reference
        oc1551 -> is missing field: recurring_id
        oc1551 -> is missing field: recurring_name
        oc1551 -> is missing field: recurring_description
        oc1551 -> is missing field: date_added
    oc_order_recurring_transaction
        oc20 -> is missing field: created
        oc1551 -> is missing field: reference
        oc1551 -> is missing field: date_added
    oc_order_total
        oc20 -> is missing field: text
    oc_product
        Field isbn differs between databases for parameter 'Type'. oc1551 -> has 'varchar(13)' and oc20 -> has 'varchar(17)'.
        Field quantity differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field points differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_available differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0000-00-00'.
        Field weight_class_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field length_class_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field sort_order differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field status differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field viewed differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_product_description
        oc20 -> is missing field: cptitle
        oc1551 -> is missing field: meta_title
    oc_product_discount
        Field quantity differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_product_image
        Field product_id differs between databases for parameter 'Key'. oc1551 -> has '' and oc20 -> has 'MUL'.
        Field sort_order differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_product_option
        Field value differs between databases for parameter 'Null'. oc1551 -> has 'YES' and oc20 -> has 'NO'.
    oc_product_profile
        oc20 -> is missing table: oc_product_profile.
    oc_product_recurring
        oc20 -> is missing field: store_id
        oc1551 -> is missing field: recurring_id
        oc1551 -> is missing field: customer_group_id
    oc_product_reward
        Field product_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field customer_group_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field points differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_product_to_store
        Field store_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_profile
        oc20 -> is missing table: oc_profile.
    oc_profile_description
        oc20 -> is missing table: oc_profile_description.
    oc_return
        Field date_ordered differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0000-00-00'.
    oc_return_action
        Field language_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_return_reason
        Field language_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_return_status
        Field language_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_review
        Field status differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_setting
        Field store_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
    oc_tax_class
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_tax_rate
        Field geo_zone_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_user
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        oc1551 -> is missing field: image
    oc_voucher
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_zone_to_geo_zone
        Field zone_id differs between databases for parameter 'Default'. oc1551 -> has '' and oc20 -> has '0'.
        Field date_added differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
        Field date_modified differs between databases for parameter 'Default'. oc1551 -> has '0000-00-00 00:00:00' and oc20 -> has ''.
    oc_affiliate_activity
        oc1551 -> is missing table: oc_affiliate_activity.
    oc_api
        oc1551 -> is missing table: oc_api.
    oc_custom_field_customer_group
        oc1551 -> is missing table: oc_custom_field_customer_group.
    oc_customer_activity
        oc1551 -> is missing table: oc_customer_activity.
    oc_event
        oc1551 -> is missing table: oc_event.
    oc_layout_module
        oc1551 -> is missing table: oc_layout_module.
    oc_location
        oc1551 -> is missing table: oc_location.
    oc_marketing
        oc1551 -> is missing table: oc_marketing.
    oc_modification
        oc1551 -> is missing table: oc_modification.
    oc_order_custom_field
        oc1551 -> is missing table: oc_order_custom_field.
    oc_recurring
        oc1551 -> is missing table: oc_recurring.
    oc_recurring_description
        oc1551 -> is missing table: oc_recurring_description.
    oc_upload
        oc1551 -> is missing table: oc_upload.

Active Member

Posts

Joined
Tue Mar 20, 2012 7:43 pm

Post by jigeshgandhi » Mon Oct 13, 2014 10:28 pm

Notice: Undefined index: recurring_id in /home1/mahaasag/public_html/admin/model/catalog/product.php on line 117Warning: Cannot modify header information - headers already sent by (output started at /home1/mahaasag/public_html/admin/index.php:84) in /home1/mahaasag/public_html/system/library/response.php on line 12


this is what i got when i tried to add a product........

pls healp

Newbie

Posts

Joined
Fri Oct 10, 2014 1:11 pm

Post by pm-netti » Mon Oct 13, 2014 10:50 pm

beipink wrote:There is no upgrade script as yet. The DB of OC 1.5.6 is different to OC2.0
I have a pretty nice database updater. ;) It will also change the database image paths and creates new directories and copy the images and update the file config.php.
The program is still missing database drivers to change the path of (system/database/ > system/library/db/).
Should I bring it to a download? The enthusiasm of someone too early to update their own store to version 2.0?
Would someone like to test it?

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by kwton » Tue Oct 14, 2014 6:18 am

You could export the old database to XML, import it to the new database, it is a click of a mouse in PHPMyadmin.
Not the whole database, only the products.
Did not check it thought,
Last edited by kwton on Sat Jun 25, 2016 1:27 am, edited 1 time in total.

Newbie

Posts

Joined
Tue Oct 07, 2014 7:52 pm

Post by mcurtis » Tue Oct 14, 2014 8:31 am

pm-netti - i am willing to be your test subject. I have a stock 2.0 installed and we can give it a go to see how the importer works.

kwton - i don't think the fields line up and i have run into issues copying the database over. I tried to do a synchronize of the 2 databases and ran into the same issue. I have posted here on it.

http://forum.opencart.com/viewtopic.php?f=19&t=131904

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by i2Paq » Tue Oct 14, 2014 2:32 pm


Norman in 't Veldt
Moderator OpenCart Forums

_________________ READ and Search BEFORE POSTING _________________

Our FREE search: Find your answer FAST!.

[How to] BTW + Verzend + betaal setup.


User avatar
Global Moderator

Posts

Joined
Mon Nov 09, 2009 7:00 pm
Location - Winkel - The Netherlands

Post by pm-netti » Tue Oct 14, 2014 3:27 pm

mcurtis wrote:pm-netti - i am willing to be your test subject. I have a stock 2.0 installed and we can give it a go to see how the importer works.
Thank you, mcurtis. But I found already one tester on this the program.

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by mcurtis » Tue Oct 14, 2014 7:17 pm

Ok. If you need another one please contact me. Will this be a free or paid module once it is completed?

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by pm-netti » Tue Oct 14, 2014 9:20 pm

mcurtis wrote:Will this be a free or paid module once it is completed?
You have to look in more detail how to proceed with this. I do not know want to Opencart team of this extension for public distribution.

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by mcurtis » Tue Oct 14, 2014 9:46 pm

I am confused. I thought you were offering me A solution to my problem. Were you just telling us that you have a possible solution but won't share it?

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by pm-netti » Tue Oct 14, 2014 10:15 pm

mcurtis wrote:I am confused. I thought you were offering me A solution to my problem. Were you just telling us that you have a possible solution but won't share it?
Yes this is maybe a possible solution to the problem of database update.
It is affected by this: http://forum.opencart.com/viewtopic.php?f=181&t=132270
I do not want anyone to take unnecessary risk, if version 2.0 there is still a lot bugs.
Yes, this extension at some point comes to distribution. Patience :)

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by mcurtis » Wed Oct 15, 2014 6:44 am

I hope they get this resolved soon :(

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by pm-netti » Wed Oct 15, 2014 3:21 pm

mcurtis wrote:I hope they get this resolved soon :(
OSWorX proofreading that extension code and fixed it. It goes a little time, because the file is 2750 lines :)

Image
- - - OpenCart Upgrade Service - - -


User avatar
Active Member

Posts

Joined
Sat Apr 07, 2012 11:22 pm
Location - Kittilä-Finland

Post by mcurtis » Wed Oct 15, 2014 7:01 pm

ugh.. that is alot.

New member

Posts

Joined
Mon Dec 12, 2011 8:49 pm

Post by Cart2Cart Team » Fri Oct 24, 2014 9:39 pm

As an alternative you can upgrade your store to 2.0 with Cart2Cart. Firstly, you will have to install a fresh OpenCart 2.0 and then migrate all products, customers and orders from your current 1.5.6 to 2.0. You can find more detailed info here http://www.shopping-cart-migration.com/ ... -migration
Best Regards,
Cart2Cart Team

Cart2Cart - simple, fast and effective migration to OpenCart


User avatar
New member

Posts

Joined
Thu Feb 28, 2013 9:48 pm

Post by prie » Thu Nov 20, 2014 4:55 pm

dzastinaslt wrote:Hello. I did it on clean 2.0 install by restoring from my current 1.5.6.4 and it worked! Just filled some missing fields. Old order list didn't went trough though... Also there was some strange bug when taxes weren't added to the price yesterday but I checked today and they work properly now (maybe some cache cleaning would help instantly) I have a banner problem though-

EDIT: apparentally there was some HTML content tabs in category layout that was causing this. I removed them and there's no more error.

Code: Select all

Notice: Undefined index: width in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 12Notice: Undefined index: height in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 13Notice: Undefined index: banner_id in /home/adelelt/domains/adele.lt/public_html/shop/catalog/controller/module/slideshow.php on line 17
if you removed them, so you can't show the slideshow in your site..

Newbie

Posts

Joined
Thu Nov 20, 2014 4:46 pm
Who is online

Users browsing this forum: No registered users and 12 guests