7.03 upgrade question

Is it possible to upgrade from 7.02 to 7.03 even if my current installation of 7.02 is an upgrade from 6.14 to 6.16 to 7.01 to 7.02? any advice would be appreciated as I would like to upgrade but am hesitant at the moment.

Quote · 30 Sep 2010

yes

Quote · 30 Sep 2010

OK thanks, then can you answer this, having checked the upgrade script, I found this line in the sql "

ALTER TABLE `Profiles` DROP INDEX `NickName_3`; "  But my 'Profiles' table does not contain and index 'NickName_3' it only has the index 'NickName' so maybe this will cause the upgrade to fail?

Quote · 30 Sep 2010

already answered this somewhere

db  ===> profiles         scroll down you'll see the warning about nickname2 or nickname3 it'll tell you to remove one

Quote · 30 Sep 2010

Thanks for your reply, but what I am saying is that there is no index of Nickname_2 or Nickname_3 in my profiles table, there is only 'Nickname' therefore I would assume that it would be safe to remove the command "ALTER TABLE `Profiles` DROP INDEX `NickName_3`;" from the sql script before applying the patch otherwise I will probably get sql error INDEX 'NickName_3 not found. Is this correct?

Quote · 30 Sep 2010

If you have no such index in the table - then upgrade will fail.

You can manually remove the following line:

ALTER TABLE `Profiles` DROP INDEX `NickName_3`

from upgrade/files/7.0.2-7.0.3/sql.sql file, so upgrade will not stop on this line.

 

OK thanks, then can you answer this, having checked the upgrade script, I found this line in the sql "

ALTER TABLE `Profiles` DROP INDEX `NickName_3`; "  But my 'Profiles' table does not contain and index 'NickName_3' it only has the index 'NickName' so maybe this will cause the upgrade to fail?

 

Rules → http://www.boonex.com/terms
Quote · 30 Sep 2010

Thank you Alex, this is the answer I was looking for, I will feel more happy to upgrade now.

Quote · 1 Oct 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.