Updating Data base

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

[DrByte]

The entire upgrade process is intended to be driven around upgrading an existing database, not copying selective data from an old database and only moving certain pieces of it forward. This is so that all data is kept in sync.

However, in limited cases this may be necessary, so the procedure is:
- backup old database
- install a fresh v1.3.x site into YET ANOTHER new clean unused database
- test it
- restore old database overtop of new database
- run zc_install process *again* against new database, and upgrade it to latest structure.
- NOW DO YOUR SELECTIVE BACKUP of just the tables you think you need
Use this selective backup for porting data forward to your new site which I assume you have installed in another database somewhere else. Or, now do another fresh clean database install and only import the tables you want.

[sparktronic]

I hear you and appreciate your comments, but I am no genius. I am stumbling through this like many others. I do not understand why I can't take my data from my customer section, product section and anywhere else I have inputted data and insert or update a data base. I did not reprogram any files, nor do I wish to because you guys are the experts and have done a superb job in making this catalog program. I do not think that you are telling me I have to put a whole new catalog up because that is what I did in the first place. I put ver 1.3 in a new folder, then upgraded it according to zc_install procedures. If I do that I would think I would just get the same results. I have seen other threads with a similar problem and no answer so thats why I put up different ones. I ran into snags and was working until I got an answer and some of the problems I solved. I am not looking to put the structure or anything in that section in the new data base, juust the customers, orders and products with their attributes. Can I, or can I not take data already inputed in another data base and insert it into a clean data base. I do not want to belabor this for you, but If I have a new version with the "can't delete bug and its not working, I wanted to try to avoid starting from scratch.