Updating Data base

[sparktronic]

Is there a procedure anywhere as to what can be safely taken from a 1.27 data base and dump just the data part into the new 1.31 data base? I am having a difficult time trying to delete any products entered. People who order cannot get past stage 2 to the payment methold. I put a fresh copy of 1.3 and them upgraded it with 1.31 and only put the data base data from address, customers, products, and orders. Everything show as it should, but as I said I cannot delete products or get the catalog to go to payment.

[DrByte]

Sounds like you skipped a number of steps in the upgrade, and would be better off going through all the upgrade steps again.

Upgrading only the database can be done via zc_install/index.php and choose the Database Upgrade option (which is of course detailed in the upgrade instructions...)

[sparktronic]

So I can get an answer on this. I DID NOT UPGRADE FROM 1.27. I put a fresh copy of 1.3 in a new folder with a new data base. I then took my many hours of data that was in the 1.27 ver went to mysql and just got the data from that data base and put it in the new. I then saw that there was a 1.31 version, which I upgraded the 1.3 ver as it is supposed to be done with zc_install. It was supposed to fix the "can't delete". It did not, so I went through the upgrade process again. Still the same thing. I do not have a 1.27 to 1.31 situation. I have a fresh 1.3 and upgrade. I am trying to find out why this is happening. It is on a unix sever which the 1.27 ver worked fine. I also wanted to know if there is a list of the DATA that can be extracted to use in the new version because I can't see spending another week entering data if I can transfer it. Thanks

[DrByte]

There is much history on your upgrade:
http://www.zen-cart.com/forum/showthread.php?t=32737
http://www.zen-cart.com/forum/showthread.php?t=37201

It seems you have had troubles with code not working while installing upgraded PHP files for v1.3.0.1
It seems you've had troubles copying selective data from old database to new.


This is a harsh statement, but must be said: it seems you think the upgrade instructions are a waste of time ... but yet when you follow another approach, you want us to fix your mistakes.



Now ... if you wish to continue along your own line of upgrading in this manner, why not install a fresh v1.3.0.1 site, and selectively move your data to IT ?

In fact, try a fresh install of v1.3.0.1 with demo data, and check to see whether deletes work or not. If they do, then clearly your cases of deletes not working are related to files on your server not being up to date..... which it would seem to me is the problem.

[DrByte]

As to transferring selective data from old database to new, the following post should help:

http://www.zen-cart.com/forum/showthread.php?t=27393

[sparktronic]

I did do the upgrade the way the instructions said. That is my quandry. The only thing I did that I did not see on the instructions. is how to get the data, not the dat structure, into the new data base. I will check the links, but I did not see anything on taking your old dat information and upgrading that. I followed the zc_install upgrade instruvctions for the program though.