Help, forum broken during upgrade

[furnitureman]

Help.

My forum was running ok as 1.1.14. I decided to upgrade to 2.0 using Webupdater. The upgrade crashed halfway through saying a corruption in the datatase. I can't go backward or forward without losing things - help!
I have tried loading both 1.1.14 and 2.0 on my little local server (I have both now running) but I can't import the .sql file back into either using phpMyAdmin as it says there is a duplication error. My only hope is to find out what version the sql file is (before the tables were renamed) and load all the tables back into the new forum individually to produce a clean backup sql file, then import this into my main site. I tried this with 1 table and it worked. This will take ages. The majority of data are names of banned individuals but there are only about 300 comments which I don't want to loose, the zipped sql file is file 440k.
Is there a better way of fixing this and what tools are available?
Thanks

[Norv]

Can you please tell what exactly was the error given by the upgrade script?

Also, what is the entire message phpmyadmin gives, when you try to import the backup file?

If I understand correctly, you have a database backup sql file of 1.1.14 as it was, before starting to run the upgrade script?

Also, when you start the upgrade, the script asks you to backup your database. Did you have that option chosen? If yes, then in the database on the live forum, you should now already have a copy of all tables of 1.1.14, with the prefix backup_.

[furnitureman]

I think my only hope is to fix the .sql file. The error I get when trying to import it into 1.1.14 with phpMyAdmin is:

SQL query:

-- -- Dumping data for table `smf_ban_groups` -- INSERT INTO `smf_ban_groups` (`ID_BAN_GROUP`, `name`, `ban_time`, `expire_time`,

`cannot_access`, `cannot_register`, `cannot_post`, `cannot_login`, `reason`, `notes`) VALUES (1, 'advadamma', 1265123408, NULL, 1, 0, 0, 0,

'Trojans links in posts', ''), (2, 'beinlewigue', 1265131958, NULL, 1, 0, 0, 0, 'Trojans in posts', ''), (3, 'Dimkalavipo', 1265135234,

NULL, 1, 0, 0, 0, 'BDSM pornography in posts and spamming.', ''), (5, 'Preersebiag', 1265186512, NULL, 1, 0, 0, 0, 'Trojans in posts', ''),

(6, 'TankBolosoina', 1265444874, NULL, 1, 0, 0, 0, 'Posts pornographic sites', ''), (7, 'Filliger', 1265912760, NULL, 1, 0, 0, 0, 'Trojans

in posts', ''), (8, 'Redanberry', 1265915335, NULL, 1, 0, 0, 0, 'Trojans in messages', ''), (9, 'Lingomfeller', 1265923525, NULL, 1, 0, 0,

0, ' Trojans in posts', ''), (10, 'Cossettini', 1265923566, NULL, 1, 0, 0, 0, 'Trojan links in posts', ''), (11, 'Aspios', 1265988698,

NULL, 1, 0, 0, 0, 'Trojan links', ''),[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1
-------------------------------------------------------------------
There are a few thousand banned members and spammers. I could loose these if worst comes to worst.

[furnitureman]

After spending all day on this, I got my 1.1.13 forum back by re-installing it on my ISP, dropping the database, , recreating it with the same name, reimporting the .sql file into phpMyAdmin and it ran again. I have just had 1 last try to upgrade my (working) 1.1.13 forum using webinstall.php. I uploaded it to my host, ran it and it crashed the whole lot again with the following error yet again:

Warning: Cannot modify header information - headers already sent by (output started at /home/xxxxxx/public_html/forum/webinstall.php:2) in

/home/xxxxxx/public_html/forum/webinstall.php on line 916
-----------------------------------------------------------------------------
I'm worried about "webinstall.php". I can't get this to work. Still, at least I can get my 1.1.13 back after a lot of work. Looks like I'll have to stick with this version of forum.

[Illori]

you should try a normal upgrade without the webinstall, it does not work on all servers. Upgrading SMF