Help with dolphin 7.0.3

Yea finnaly i got stucked !

I updated all the way and i've never had any problem but now am in a mess when i wanted to upgrade i got this :

ALTER TABLE `Profiles` DROP INDEX `NickName_3`;: Can't DROP 'NickName_3'; check that column/key exists

Please i need help !

Thanks

Hello

The default installation of Dolphin 7.0.2 has two identical indexes NickName_2 and NickName_3 in Profiles table. Upgrade tool tries to remove one of them because it's redundant. If you are trying to use upgrade tool the second time or applied some tickets from Dolphin Trac, the index was removed. In this case some other conflicts may appear. Could you please describe the issue in more details? What exactly did you do? And we will try to help you.

First of all when i tried to upgrade i had a my sql error something about TIME OUT , can't locate your ip and a long long database sql where i can locate the error ( so i ignore it ) i know it's my fault ! then i tried the second time and i had a message : Update can not be applied ! so i tried to change thing's in the check up like 7.0.2 to 7.0.3 so it did show that the upgrade available but when i click on upgrade i got this :

ALTER TABLE `Profiles` DROP INDEX `NickName_3`;: Can't DROP 'NickName_3'; check that column/key exists

Please i need your help even if i can pay i mean a fear a mounte :) , i've never had any problem , i always upgraded fine and no hassle , until today !

Thanks.

db.
go to profiles scroll down you'll see a red msg.. saying that NickName_2 or NickName_3 something like that just remove one and try again

db ? where about ? is it in phpmyadmin ?

thanks .

eli

any more help ????

You can administer your database from within phpMyAdmin.

Yea magnusoft you are right but i want to find out where is the ---> ALTER TABLE `Profiles` DROP INDEX `NickName_3`;: Can't DROP 'NickName_3'; check that column/key exists

I mean where i can find the NickName_3 , am getting a bit annoyed !

:(

any help with be appreciate it.

Thanks.

my site is gone baby lol the door for voluntreering is open ...who wanna help

 Did you make a full backup of your DB and Installation before proceeding with the update?

i didn'T !

outch.... backups are important B4 upgrading anything, I learned the hard way ... BUT rest assured all is not lost, I am upgrading as we speak or at least trying to... you can do a complete install if need OR see if you are lucky to have a server side back up....

my host did a server back up , i asked them and they are restoring it now , hopefully it will be back as it was !

My site back the way it was ! thanks Ardicus for mentioning side server back up , you are a star Man ! , you saved my day !

So now am not going to touch the bloody thing ! as i need a volunteer to help me out !

Peace.

ELi

I have this same problem.

ALTER TABLE `Profiles` DROP INDEX `NickName_3`;: Can't DROP 'NickName_3'; check that column/key exists

Could anyone give me specific instructions on how to go into my phpadmin and recreate this NickName_3 so the upgrade script can drop it.

http://www.boonex.com/unity/forums/topic/7-03-upgrade-question.htm

Okay, that worked Alex...thank you...

but now I'll I'm getting is:

Fatal error: Allowed memory size of 262144 bytes exhausted (tried to allocate 122880 bytes) in /home/ustillup/public_html/inc/security.inc.php on line 71

Please try http://www.ustillup.com