Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

moving to 2.0.4 Rate Topic   - - - - -

 
  • craiglove
  • Junior Member
  • Members
  • Join Date: 22-Nov 08
  • 21 posts

Posted 03 June 2009 - 08:14 AM #1

hi guys,

what is the best way to move upto the new version from 1.3.5?

do a fresh install and re-import the products, images, customers etc..?

Regards Craig
New Zealand

 
  • zeero6
  • Senior Member
  • Members
  • Join Date: 25-Jan 07
  • 649 posts

Posted 03 June 2009 - 02:27 PM #2

That's what i did.
I installed the new Version 2.04
Than exported products from version 1.5.3 along wiht all the descriptions
Exported Version 2.04 products to see the structure and copy and paste from 1.5.3 tables to 2.04 conresponding tables.
Than imported back into 2.04
Same way with users tables.
Always back up!!!!

Version 4.9.3 SP1


 
  • craiglove
  • Junior Member
  • Members
  • Join Date: 22-Nov 08
  • 21 posts

Posted 07 June 2009 - 04:29 AM #3

Great zeero6, will give that a go...

we imported all of Zen Cart the same way. would be nice to get a clean fresh install also.

Craig

 
  • virgvv
  • Junior Member
  • Members
  • Join Date: 17-Aug 07
  • 9 posts

Posted 11 June 2009 - 01:32 AM #4

Yes, that is the safest way to upgrade. There are enough significant changes to v2.0 that trying to migrate items from old database tables to the new ones can be a headache (I speak from experience :| ).

If you have fairly heavily customized templates (as I do), you will need to make changes to them. Some of the files have been reorganized into different directories, and the Smarty code has changed here and there.

 
  • CSCartSkins
  • Senior Member
  • Members
  • Join Date: 07-Jan 09
  • 195 posts

Posted 11 June 2009 - 02:15 PM #5

zeero6, would you mind writing a step by step guide on how to do this? I think that others would find it beneficial to know exactly what to do (like me).

 
  • zeero6
  • Senior Member
  • Members
  • Join Date: 25-Jan 07
  • 649 posts

Posted 11 June 2009 - 04:07 PM #6

These were my steps
This worked for me. May not work for everyone. I’m not an expert but it was fun doing it.
We only have 1000 products and it’s used only for Company and Franchise Purchasing. Not Public.

Installed version 2.04 in new directory called shop

Older version was on dir cart

My first step was to export users from Version 1.3.5

V. 2.04 - Imported users in Administration – Import data – users tab on right
All users and passwords worked.

Than exported products from version 1.3.5 along with all the descriptions.

Added a product to Version 2.04 than exported products from Administration – export data – products tab to see the structure.

Compared both and copy the tables from version 1.3.5 to corresponding tables in version 2.04 like Product code – Category and so on.

Than imported back to version 2.04 when all the fields matched.

By adding a product first you can tell also where the images are stored in version 2.04 and uploaded the images to that directory.

I did have to add some images manually since I did not have all my images in my backup folder since I was not using file system and wanted to use better images.

Also I exported Quantity discounts from 1.3.5 since I use different memberships and imported back to version 2.04 under Administration – import data – Qty discounts. Create the Memberships if you use this option.

After testing for a while and customizing did a temporary redirected from cart dir to go to shop directory, that way still have the old version as a backup. Eventually will move.

Always backup first

Version 4.9.3 SP1


 
  • CSCartSkins
  • Senior Member
  • Members
  • Join Date: 07-Jan 09
  • 195 posts

Posted 11 June 2009 - 07:36 PM #7

Awesome! Would you mind if this gets published elsewhere? Credit will be provided.

 
  • zeero6
  • Senior Member
  • Members
  • Join Date: 25-Jan 07
  • 649 posts

Posted 11 June 2009 - 08:17 PM #8

Not at all. Would be nice to see if anyone else has done it.

Version 4.9.3 SP1


 
  • rdr
  • Member
  • Members
  • Join Date: 02-Jun 08
  • 47 posts

Posted 12 June 2009 - 06:07 AM #9

user import is working ok for me, but the rest is rather chaotic... discarding some info allowed my self to import products but customer order's history wasn't imported.

not good...

 
  • rdr
  • Member
  • Members
  • Join Date: 02-Jun 08
  • 47 posts

Posted 14 June 2009 - 07:58 PM #10

upgrade script seems to be out, it was working for me
http://www.cscart-us...ade-135-to-204/

 
  • hans
  • Member
  • Members
  • Join Date: 29-Mar 06
  • 94 posts

Posted 14 June 2009 - 08:24 PM #11

...
Compared both and copy the tables from version 1.3.5 to corresponding tables in version 2.04 like Product code – Category and so on.
...

Instead of comparing the data I feel more comfortable exporting both database schemas only (no data, using DB Backup/Restore feature) before I transfer the data itself.

......

Just used the upgrade scripts (my 2.0.4 was still fresh, not touched) but I had no luck. There are no categories on the frontpage. Products are in the new database but are not linked to categories. When clicking on a product in the admin, I get the following SQL statement error:

Database error: Unknown column 'exception_id' in 'order clause' (1054)
Invalid query: SELECT * FROM cscart_product_options_exceptions WHERE product_id = 1 ORDER BY exception_id


 
  • roban
  • Senior Member
  • Moderators
  • Join Date: 23-Oct 06
  • 1132 posts

Posted 15 June 2009 - 01:21 PM #12

using the new upgrade script worked well for me. There are a few issues I have to resolve like a required checkout field for business or residential address but no field is displayed. I cannot get shipping same as billing to work but I'm working on it.

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 15 June 2009 - 05:32 PM #13

upgrade script seems to be out, it was working for me
http://www.cscart-us...ade-135-to-204/


Is this site run by CS-Cart? I normally look for my files in the File Area at CS-Cart.com.
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • TonyK
  • Member
  • Members
  • Join Date: 03-Mar 06
  • 1686 posts

Posted 15 June 2009 - 06:00 PM #14

That site is run by me and the upgrade script was written by CS-Cart.

I just posted the info.
Pimpin' skins since v1.0

 
  • tletourneau
  • Senior Member
  • Members
  • Join Date: 13-Apr 07
  • 179 posts

Posted 15 June 2009 - 07:36 PM #15

That site is run by me and the upgrade script was written by CS-Cart.

I just posted the info.


Cool, thanks for that!
Thanks,
Tom
Version - 3.0.4
Hosting - RangeHosting.us

 
  • hans
  • Member
  • Members
  • Join Date: 29-Mar 06
  • 94 posts

Posted 15 June 2009 - 07:42 PM #16

The update script made my new, corrupt DB 245 tables big. A fresh 2.0.4 install has 191. How come there's this difference? Are you guys having the same amount?

 
  • roban
  • Senior Member
  • Moderators
  • Join Date: 23-Oct 06
  • 1132 posts

Posted 15 June 2009 - 07:55 PM #17

That site is run by me and the upgrade script was written by CS-Cart.

I just posted the info.


Thanks for the work. It did just fine and the upgrade took about 15 minutes.

 
  • awolff
  • Junior Member
  • Members
  • Join Date: 07-Sep 08
  • 4 posts

Posted 16 June 2009 - 02:45 PM #18

I followed the instruction with the upgrade script and everything went ok, except no product, or other images are showing up. When I check where it calls the images from, it appears all the product images are renamed, so even if I move all my images over to that folder, I will still have to manually rename them all.

Is this how an upgrade is supposed to work?

 
  • TonyK
  • Member
  • Members
  • Join Date: 03-Mar 06
  • 1686 posts

Posted 16 June 2009 - 03:39 PM #19

What were the old names and what does the DB say is the new name?

Give several examples please.
Pimpin' skins since v1.0

 
  • Darius
  • Douchebag
  • Members
  • Join Date: 20-Apr 08
  • 3315 posts

Posted 16 June 2009 - 06:05 PM #20

Thanks for the work. It did just fine and the upgrade took about 15 minutes.


It took me approx 8 hours :D could not make 2.04 show images