looking for suggestions for making massive database changes

[delia]

That's not knowable but arose from this other thread: https://www.zen-cart.com/showthread....comments-field
All I know is that I proved the issue is caused by the database and not the template.

[gilby]

That's not knowable but arose from this other thread: https://www.zen-cart.com/showthread....comments-field
All I know is that I proved the issue is caused by the database and not the template.

I can't see how "fixing" this database will have any effect on the problems in your other thread.
I suspect you are heading down the wrong rabbit hole.
Hope others can offer better suggestions. ....

[mc12345678]

So here's thing. Unless the page is literally prepopulsted with the undesirable content as the text is going to the browser, the only database related information would likely be something that is also otherwise modifying the pre-existing html.

Using a browser/system that is not suffering with this auto-fill capability, I would take a snapshot of the html for both database versions. I would also consider the possibility that there is something in the headers being sent.

Otherwise your browser doesn't know squat about the database or even really the php code that is on the server.

If not mistaken, the same filesets (meaning no additional template overrides) have been used with two database "versions" (the fresh for one and the upgraded for the other).

Now unfortunately, even once the page's html is compared between the two, it wouldn't surprise me to think that even more of the database should be reviewed to potentially account for whatever flaws were abused on that older environment.

[delia]

and so I still have no good answers to the question.

So what would you do?
1) edit fields one by one
2) merge with a recent default database
3) set up new database and only transfer over pertinent tables

[chadlly2003]

Just some more insight on your issue.

As far as editing products you could use easy populate and export the information and edit it from an excel file. (its a very simple process)

As far as the database goes, I would download a new zencart and install it on your local machine and compare it to the old database. As was mentioned already.