SOLVED: Restore Database after screwed up upgrade

Hi all,

I am in deep trouble with my wife! I was upgrading her store to version 2 today for the mobile friendly thing and it has all gone to ruin! I followed the instructions in the upgrade text as per normal but once I tried to run the upgrade script it went to ruins reporting all sorts of errors. Anyway, I though no problem, I'll restore the overwritten files and forget it for a while. That failed and to cut a long story short, I am now down to a blank store back in version 1.5.6.4 which was the version I was trying to upgrade from up to 2.1.0.1.

What happens is when I try to restore the database from the admin panel I get the below error which I could really do with resolving urgently if anyone can help. If not all the products will have to be re-entered and we will will have lost our customer database too . :-( I thought I had it covered by backing everything up. What can I do to get my database restored? By the way, all those table exist in the database.
Can anyone offer any help?

if you tried to 'upgrade' an operating Software & DB, without either:

1. installing a NEW Version Shop in it's own, temporary created, subdirectory, as well as it's new DB
2. creating a FULL Backup, by use of the Server Admin MySql Admin Manager

then, you screwed up, by ignoring all 'rules', bound to such tasks, so, possibly even 'infecting'
your existing V.1.5.6.x DB with V.2.x Content, and, as a consequence of this, your V.1.5.6.4
Software is probably not longer able to handle the DB.

Consequence:
One has to, manually, check/compare a Copy of the 'infected' DB, with a v.1.5.6. Stock Version,
(or then, you have a BACK-UP DB, created not too long ago), in addition to check on your Mod's,
used, possibly adding some content to the DB. Then, create a running Version of all this,
upload it to the server, or, eventually delete the existing DB and create a new one again,
to include the fixed DB-Content.

If would be some hours of work, by a Pro, be allowed full ACCESS to your Site and Site Admin Section, I assume.
It's the Price, one has to pay, trying to take a Short Cut Road, without Map and/or GPS on board. AT NIGHT!
Good Luck
Ernie
openshop.li/cart/
Your Wife will love you for this, I assume...

Thanks for the reply Ernie. I do have the backup I took before the upgrade to V2 was attempted which includes all the files in /public_html and the database which was taken from within the admin console. I was trying to restore the database it to a brand new clean install of 1.5 the same version as original. Surely I should be able to simply restore the data to a clean install. Although, I have read somewhere that the upgrade process is "dirty" and does not clean up as it goes thus I have stray tables or such like now causing the problem.
Yours baffled,
Neil

UPDATE: Problem Solved
It was just a case of studying the error, adding the missing field and two more tables including their relevant fields correlating to the errors on import. Fix one part, reimport to get a new error and so on.
What's scary is that the missing tables shouldn't be missing in the first place if you ask me on a fresh install.

Version 1.5.6.4
The Tables and fields missing were:
Within Table Order: 'reward` field was missing.
Table: 'product tag' was missing and the 4 rows inside it.
Table: 'return_product' and the 11 rows inside it.

I hope this useful to someone else in the future.

I imagine the version 2 upgrade could have been solved in the same way too.

Hi splitpink

I'm about to upgrade soon, so your post has been very helpful.

I wonder if they will read your post and make the changes so that some of us who are still using OC 1 will upgrade to version 2.

I know I want to within the next few weeks.

Thanks again

If I had the skills in MySql I could write a script to create the missing tables. I am back where I started now at 1.5.6.4 - I will try to build a clean new V2 system and restore to it. Then I can test it and move it to root position once I am happy. If I manage to write the SQL to add the tables automatically I will make them available. I have another site I am working on at the moment which I could write the script for. The only problem will be the difference in other peoples prefixes I guess.

Glad my post helped.

I assume, it won't be possible, to keep the Folks from trying to naivly 'upgrade' working v.1.5.6.4 Version to v.2.1.x TEST VERSIONS, for whatever reason ever. Despite of the Fact, that this Place is getting Complaints, on an steady increassing level, and less and lesser Peoples, obviously eager and willing, to assist those any longer, foolishly getting themselfs into self-created Trouble.

But that's the way, it is, when using weekly updated v.2.1.x (stated!) Test-Prototypes, it seems to be the most important THING to do, despite of the known FACT, already, that it only raises Problems. it MUST be some FORCE, in the Brain, urging so many, to try to BELONG to the FIRST.

Lucky OC, they don't have to care about all those fools, because they don't charge, for the Software, so, they don't have a real obligation, to care about all those 'Believers', seemengly unable to wait, until the thing realy works. Therefore, it's for sure NOT OC's fault, when/that so many fail.

But most won't succeed anyway, in longer terms, I assume, because they have no knowledge, in the first place, to get a Business working, and to be successfull. Therefore, I guess, what the hell, let them play around, it's of no use, to keep 'em from failing, they will fail anyway...

This is, what makes the difference, between successfull Sellers, and Loosers, seemengly trying to beat the system, by expecting a free Online Shop Software to make 'em rich quick. without requiring ANY technical Background...

Sounds harsh? Just check the Postings, to find out!

I also assume, that v.2 already has ended a former OC Tradition, and as higher the Version Numbers get's, the less FREE will be Part of it anyway. Reason: Why should DEV's longer care about others, more and more obviously just unable to even understand the most simple logics, but expecting everything to be PRO, and finished, and just waiting to be taken, uploaded, and used, matched to meet all specific NEEDS, and all this for FREE!?

OC is a tool, designed for those, capable and able to handle it, as it comes. Just like a Car. But if one does not understand, how a Car functions, one should NOT try to work on the Engine, to mock it up, but use it, by default.

Or then, get someone, who know's, what he's doing..., anything else is a plain Gamble.
But such does usually not come for free! This should be understud, by ALL, trying to make a BUCK by Use of OC!

Good Luck, no offense, just my very personal View on this!
Ernie
openshop.li/cart/

The image attached may help you understand why people are trying to upgrade to version 2 from 1.5. The point here is, if you have used OpenCart through several updates and need to rebuild your 1.5.6.4 version from a backup, you will have errors. It's a problem that with the previous upgrades removing product tags and customer reward options from the system but not the database in later versions in my opinion. (I'm not desperate to know and I'm technical but not a developer) The two ways to fix it are remove the offending fields/tables from the database you want to import, or add them to the database you are importing to. Either way, the upgrade process wasn't clean historically and you can not by default restore your system from a backup database if you have had your store for several versions previous.



Quote:
"This is, what makes the difference, between successfull Sellers, and Loosers, seemengly trying to beat the system, by expecting a free Online Shop Software to make 'em rich quick. without requiring ANY technical Background..."

I don't think I fall in to your difference between "succesfull" Sellers (successful?) and "Looser" (loser?) group "seemengly" (seemingly?) of people somehow, I have solved the problem after all.

No offense meant of course.

I rest my case.

no offense taken, I don't take anything personal, I understand your Point. By nature of things, Experimental THINGS should have fully separated the Developer/Tester- Sections from the RETAIL FRONT, completely, in order to avoid, what shows up to be the unfortunate consequence, offering obviously pre-release Tester Software to the broad Public, without sufficient Information enclosed to it, on, how to handle it. In Addition, there is UPGRADE/UPDATE Software available, ok, but WHO KNOW's, what works, under wich circumstances ? It's a plain Gamble, to find out, by Trail and Error. And absolutely NO CONTROL, either, anyone is able to add an Extension to the Board, regardless, if it functions, or not.
---
The good Part, a LOT OF IT comes for free. Anyone, familiar with Coding, is able to use it, modify it, enhance it, without spending a single Cent on Software ! And noone is forced, ever, to download/use this piece of Software. So, it's not OC's fault, or Problem, in the first Place, if NON-Coders screw up, comparably with MANUALLY trying to overwrite an existing WIN XP, by use on an Filemover Tool, with WIN7 Source, and even expecting it to still function, as before !

But I don't plan to speak for, or against, OC, it's not my business, so, I have no bases, or reason, or right, to be critical, in any way. I'm just playing around, for the fun of it, and trying, to get a little smarter on Coding, especially on things, I did not use, until I met OC. Still, an Upgrade should be considered, here and there, it should NOT be so hard, to make this place here, as well, a little smarter, and so better, for everbody, involved in OC. OC also depends heavy on free Contributors, of all kinds, in order to succeed. To forget, or ignore such, could be a painful experience, in the longer terms.
---
I have been publishing a Post, explaining, how I did it.

http://forum.opencart.com/viewtopic.php ... 44#p581784

Good Luck
Ernie
openshop.li/shop/