I recently upgrade from 7.2.8 to the latest 7.4.1. Everything went smoothly besides a couple of queries I had to run.
If I try to move the database and files to my localhost (or vice versa to another host) then I'm constantly asked to AuthoriseUpgrade.
I have cleared the cache, modified the ClientDependancy config and also made sure the bin files are all fresh (for testing sake). The version in the web.config is as it should be (7.4.1).
Anyone know a way around this please as it's extremely frustrating.
If I do actually run the installer, I get this message:
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid object name 'umbracoMigration'. Please check log file for additional information (can be found in '/App_Data/Logs/UmbracoTraceLog.txt')
Looking in the database, I see the following, this looks strange right? I think that this is a DB issue?
Missed the screenshot in the original post.
It seems you ran the upgrade using a different user/schema on the sql server. The tables should be prefixed with dbo.
Makes sense Dave - Thanks for the clarification. I did think the prefix looked strange.
Is there any way to resolve this without having to go back and re-upgrade the older version? We have already made content updates to this instance of the website.
Not even sure how I would've caused this to be honest.
Managed to resolve this myself using the following script:
declare @sql varchar(8000), @table varchar(1000), @oldschema varchar(1000), @newschema varchar(1000)
set @oldschema = 'resuser'
set @newschema = 'dbo'
while exists(select * from sys.tables where schema_name(schema_id) = @oldschema)
begin
select @table = name from sys.tables
where object_id in(select min(object_id) from sys.tables where schema_name(schema_id) = @oldschema)
set @sql = 'alter schema ' + @newschema + ' transfer ' + @oldschema + '.' + @table
exec(@sql)
end
Moving website causes AuthorizeUpgrade loop
I recently upgrade from 7.2.8 to the latest 7.4.1. Everything went smoothly besides a couple of queries I had to run.
If I try to move the database and files to my localhost (or vice versa to another host) then I'm constantly asked to AuthoriseUpgrade.
I have cleared the cache, modified the ClientDependancy config and also made sure the bin files are all fresh (for testing sake). The version in the web.config is as it should be (7.4.1).
Anyone know a way around this please as it's extremely frustrating.
If I do actually run the installer, I get this message:
Looking in the database, I see the following, this looks strange right? I think that this is a DB issue?
http://prntscr.com/a7bvs7
Is your connectionstring pointing to the correct database ?
Dave
Hi Dave,
100% certain it is.
Can you check if the table umbracoMigration is in the database ? This should been added as part of the upgrade.
Dave
Yes, please check the screenshot here - http://prntscr.com/a7bvs7
Hi Devin,
Missed the screenshot in the original post. It seems you ran the upgrade using a different user/schema on the sql server. The tables should be prefixed with dbo.
So it is a SQL server issue.
Dave
Makes sense Dave - Thanks for the clarification. I did think the prefix looked strange.
Is there any way to resolve this without having to go back and re-upgrade the older version? We have already made content updates to this instance of the website.
Not even sure how I would've caused this to be honest.
Managed to resolve this myself using the following script:
Thanks for your help Dave.
Nice one..hope i remember this post when I run in to the same issue :-)
Dave
Devin - mate, you rock, I was at the "have another whiskey" stage on my new laptop and my websites not working.
Thank you so much for sharing...
Nigel
thank you Devin, this was exactly what I was looking for #h5yr
is working on a reply...