"Invalid column name 'controlId'.". when I try to restore my local db in server sql server
Hi,
Today I have tried to publish all my local development copy to the server. But After I have uploaded my code when i try to run the project,
I have got invalid object name "umbracoUser". Then I restored my local db to main (run the sql script in the empty server database) , it asked for Umbraco update. when i clicked continue its throwing error as "Invalid column name 'controlId'." When i checked the local db there is no column with ControlId.
I can assure you that I fixed my issue without having to re-run the installler. Clearing cookies solved it for me. I have seen the issue again on a separate installation and this fix worked there too.
Hi Bill, I had the real problem ;-) on the production server may be it's not the same version I'm on 7.3.5 and exactly the same error message. The only solution was the above. It's strange anyway that it's launching the install when you migrate the site.
"Invalid column name 'controlId'.". when I try to restore my local db in server sql server
Hi,
Today I have tried to publish all my local development copy to the server. But After I have uploaded my code when i try to run the project,
I have got invalid object name "umbracoUser". Then I restored my local db to main (run the sql script in the empty server database) , it asked for Umbraco update. when i clicked continue its throwing error as "Invalid column name 'controlId'." When i checked the local db there is no column with ControlId.
Does anyone know what i am doing it wrong here?
I'm getting this too - did you figure it out please?
Cheers
Bill
If this is useful to anyone - clearing browser cookies fixed this
Clearing cookies is not fixing this for me. Any other ideas? Umbraco 7.3.5
The REAL solution is to remove the umbraco version number in web.config and rerun Install
This actually fixed it for me ... I've searched a good 4 hours to come to this solution while trying everything else which was recommended before.
I can assure you that I fixed my issue without having to re-run the installler. Clearing cookies solved it for me. I have seen the issue again on a separate installation and this fix worked there too.
Maybe you didn't have the REAL problem? ;)
Hi Bill, I had the real problem ;-) on the production server may be it's not the same version I'm on 7.3.5 and exactly the same error message. The only solution was the above. It's strange anyway that it's launching the install when you migrate the site.
Had this issue after a DB restore.
Initially got an error about SQL permissions.
Fixed that, then got the above error.
Tried lots of things including removing all cookies.
Final fix was to restart the app pool. Strangely, we also had to restart the app pools on all the distributed umbraco servers as well as the master.
App pool restart helped me with this problem :)
is working on a reply...