I've recently deployed an Umbraco (7.2.5) site to Azure. Everything on the website works fine, except for the "Save and publish" button when editing nodes in the backoffice.
When I click the button, it fades out (it says "Publishing..." for a few seconds in the top corner) but no success or error message ever appears the button just remains faded out. There is nothing in my log either so have very little to go on with this error. The whole website works fine (publishing and all) on my localhost.
Has anyone else experienced this before?
I am using an Azure Web App and SQL database.
Thanks in advance anyone who can help! I've been searching around the web for ages and can't find anything that will fix this :(
Experienced a similar issue in the past when there was a problem with permissions and I didn't have write/edit permission on the root folder directory.
I added the relevent permission for the Application Pool identity. I wasn't using Asure but thought it might be something worth mentioning. Best of luck.
Is it possible to copy the response you get from the server (so the 500 error) from your networking tab.
I'll include a screenshot of how you cvan do that. First you need to open the developer tools. Than select the networking tab. Than click the clear button so you get a blanco screen.
Now if you click the publish buton, you should see "PostSave" in your network traffic. Normally it should be red because you get a 500 error. If you click on the PostSave request, you can select the Response tab on the right and there you should see the full error.
If not, I'm runnin out of ideas.
Have you tried to restart your website, recycle the application pool, checked if all mandatory fields are filled out...
Cannot insert the value NULL into column 'id', table 'HKUmbraco.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails.
The statement has been terminated.
For the benefit of anyone else with the same problem:
The "Tasks > Export Data..." function in SSMS doesn't work properly when moving to Azure. It only creates basic table structure and misses lots of things required for the Umbraco backoffice to work.
Cannot Save or Publish on Azure
Hi All,
I've recently deployed an Umbraco (7.2.5) site to Azure. Everything on the website works fine, except for the "Save and publish" button when editing nodes in the backoffice.
When I click the button, it fades out (it says "Publishing..." for a few seconds in the top corner) but no success or error message ever appears the button just remains faded out. There is nothing in my log either so have very little to go on with this error. The whole website works fine (publishing and all) on my localhost.
Has anyone else experienced this before?
I am using an Azure Web App and SQL database.
Thanks in advance anyone who can help! I've been searching around the web for ages and can't find anything that will fix this :(
Experienced a similar issue in the past when there was a problem with permissions and I didn't have write/edit permission on the root folder directory.
So did you not manage to find a solution?
Hi Chris,
I added the relevent permission for the Application Pool identity. I wasn't using Asure but thought it might be something worth mentioning. Best of luck.
Hi John,
Could you check your console if it shows any error? You can open the console by pressing F12 and then hit the "escape" button.
You could also go to the networking tab and hit the poublish button to see which requests are being sent to the server and what their response is.
POST ... 500 (Internal Server Error)$get.id @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:16o @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.g @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14j.promise.then.i @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14j.promise.then.i @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14(anonymous function) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$eval @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$digest @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$apply @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14(anonymous function) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:42x.event.dispatch @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:2x.event.add.y.handle @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:2 DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:12 TypeError: data.indexOf is not a function at DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:915 at DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:924 at DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14 at j.promise.then.o (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14) at j.promise.then.o (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14) at DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14 at Object.$get.e.$eval (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14) at Object.$get.e.$digest (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14) at Object.$get.e.$apply (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14) at j (DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14)(anonymous function) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:12$get @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:11j.promise.then.o @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14j.promise.then.o @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14(anonymous function) @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$eval @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$digest @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14$get.e.$apply @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14j @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:14r @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:15v.onreadystatechange @ DependencyHandler.axd?s=L3VtYnJhY28vbGliL2pxdWVyeS9qcXVlcnkubWluLmpzOy91bWJyYWNvL2xpYi9hbmd1bGFyLzE…:16
That is from my console...
Hi Chris,
That doesn't say much unfortunately.
Heve you already tried to publish by right clicking the node and selecting publish?
You could also try to republish your entire site by right clicking the root node from your site and selecting the option "publish all children..."?
Just tried that and the error I get is much the same, only differences are:
Still the same overall error of 500 (Internal Server Error)
Okay,
Is it possible to copy the response you get from the server (so the 500 error) from your networking tab.
I'll include a screenshot of how you cvan do that. First you need to open the developer tools. Than select the networking tab. Than click the clear button so you get a blanco screen.
Now if you click the publish buton, you should see "PostSave" in your network traffic. Normally it should be red because you get a 500 error. If you click on the PostSave request, you can select the Response tab on the right and there you should see the full error.
If not, I'm runnin out of ideas.
Have you tried to restart your website, recycle the application pool, checked if all mandatory fields are filled out...
This is the error it comes back with:
Cannot insert the value NULL into column 'id', table 'HKUmbraco.dbo.cmsContentVersion'; column does not allow nulls. INSERT fails. The statement has been terminated.
Looks as though SQL Server Management Studio may have messed up here... I am going to recreate my database from my local copy again.
When I script the cmsContentVersion table I get
However from my local db it is
Indeed, the identity is missing on the Id column.
Fixed this now. Thanks Jochen.
For the benefit of anyone else with the same problem:
The "Tasks > Export Data..." function in SSMS doesn't work properly when moving to Azure. It only creates basic table structure and misses lots of things required for the Umbraco backoffice to work.
It would appear the only way to correctly import databases to Azure is to use the import features outlined here: https://our.umbraco.org/forum/getting-started/installing-umbraco/42028-Migrating-to-Azure https://msdn.microsoft.com/en-us/library/azure/hh335292.aspx
is working on a reply...