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.
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. |
yes |
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? |
already answered this somewhere db ===> profiles scroll down you'll see the warning about nickname2 or nickname3 it'll tell you to remove one |
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? |
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 |
Thank you Alex, this is the answer I was looking for, I will feel more happy to upgrade now. |