Im surprised that with so many Magento developers and users nobody has been able to help me.
Anyway, I have found the problem, fixed it and successfully upgraded to 220.127.116.11
The config.xml file alteration did not work in my case, but I would not advise that as a fix anyway as it just covers up database corruption.
Before Reading further, make sure everything is backed up sufficiently, website, and data and dont make changes to your live production database..and as always take precautions! I will not be held responsible for any problems caused… process at your own risk.
anyway. heres what I did…
Important to follow exactly,
Do a database backup, inside magento.
Download the database backup.
Import it into a new database.
Open new database in phpmyadmin.
Run the following query on the new copy database,
DO NOT RUN ON ACTIVE PRODUCTION DATABASE.. ONLY RUN ON COPY DATABASE!
Log into your FTP
Make a copy of local.xml under App, etc.
Open copied local.xml file, and change the database name, username, password to match your database copy credentials and name. (the database you just run the Truncate queries on).
Rename original local.xml file on FTP to local.xml.original
Upload modified local.xml
Access website admin/management area..(should now be running from the copy database and not the original)
Go to \"System\" \"Index Management\”
\"Select All\” --> \"Actions: Reindex all\” --> Submit
(Reason for opening up the website using the copied database, and running full index is to rebuild the index;s… I failed to do this first time, and what happened was my original error went and was replaced with another error during the upgrade installation.)
Once index complete, log back into your FTP.. rename local.xml to local.xml.modified, and rename local.xml.original to just local.xml in order to restore your website to using current production database.
Now website should still be running fine as it was before.
Next run 18.104.22.168 upgrade as normal, and when it asks for the database details, name, credentials etc… just enter details of your copy database which you run the truncate and re-index on… as this will become the upgraded 22.214.171.124 database.
Install should then complete properly
As a precautionary after step, I also always run the Magento Database Repair Tool to compare your upgraded database to a clean 126.96.36.199 database… in my case on this occasion it did find 1 or 2 problems and fixed them.. problems which it didnt find prior to the upgrade.
Now my website is working fine under 188.8.131.52 and database seems to be corruption free
Hope all the above helps!