How to upload sqlCE local database to live server (I am using dailyrazor.com, the ASP.NET hosting)
I have recently created a website using Umbraco CMS in the local evironment , I used the default database which was set when I installed umbraco (If I remmebmer right it was the sqlCE).
When I published the website and transfer all the files to the root directory on my server the website is not loading because of the connection string.
So the question is what's the easiest way to upload my umbraco.sdf to my server.
It did work as a temporary solution but I must have done something wrong on my life environment. Basically I have an issue where I can not longer create any document types as it comes up with an error for missing model. I am using a models builder = Dll
I have tried to re-generated the models in the back office but then it doesn't display the rest of the website. It comes up with a message more than one type to be model for accreditation (it's one of my pages/doc types).
Sorry for taking your time but I am really having a hard time in here. Appreciate your effort.
If I delete the '~/bin/Umbraco.Web.PublishedContentModels.dll' library it will fix the error for the created document type but the rest of the website is not working anymore.
I always remove the <contentmodels.Homepage> bit from my templates, it always causes issues. I'm guessing it doesn't when you have a very specific setup with modelsbuilder.
No worries, glad my experience could be of some use to you Pavel.
My understanding is that in different scenarios the model builder makes an object for each template, but the modelbuilder has to be setup to do this when using visual studio.
I have never seen a guide on how this works that covers or resolves this issue. So I figured I just wouldn't use the local template model and it worked.
Can you mark my answer correct please, so others know what helped.
Umbraco sdf Database to live server
Hi Everybody,
How to upload sqlCE local database to live server (I am using dailyrazor.com, the ASP.NET hosting) I have recently created a website using Umbraco CMS in the local evironment , I used the default database which was set when I installed umbraco (If I remmebmer right it was the sqlCE).
When I published the website and transfer all the files to the root directory on my server the website is not loading because of the connection string.
So the question is what's the easiest way to upload my umbraco.sdf to my server.
Thanks
Hi Pavol
The easiest way is to use FTP, just upload your database file to App_Data folder of your website.
Thanks,
Alex
Hi Alex, thanks for your time.
I believe that sorted my issue. However, a new issue has arise now.
Do you think it's something to do with the database?
Thanks
I can log into the backoffice and everything is fine there.
Try to rebuild Models, go to Developer section -> Models Builder -> red button -> Generate models
Thanks,
Alex
Hi Alex,
It did work as a temporary solution but I must have done something wrong on my life environment. Basically I have an issue where I can not longer create any document types as it comes up with an error for missing model. I am using a models builder = Dll
I have tried to re-generated the models in the back office but then it doesn't display the rest of the website. It comes up with a message more than one type to be model for accreditation (it's one of my pages/doc types).
If I use PureLive, different issue.
Thank and any help appreciated.
Hi Pavol
If you are using "PureLive" mode, you have to remove '~/bin/Umbraco.Web.PublishedContentModels.dll' library. It will fix the error.
Thanks,
Alex
Hi Alex,
Sorry for taking your time but I am really having a hard time in here. Appreciate your effort.
If I delete the '~/bin/Umbraco.Web.PublishedContentModels.dll' library it will fix the error for the created document type but the rest of the website is not working anymore.
It displays message:
Hi Pavol
What version of Umbraco are you using?
Are you using render controllers?
Thanks,
Alex
Hi Alex,
Version : Umbraco version 7.7.2
And I am not using render controllers, at least I am not aware of it.
Please not I have solved the solution by removing the
Not sure why that helps but it did.
Many thanks for you help.
I always remove the
<contentmodels.Homepage>
bit from my templates, it always causes issues. I'm guessing it doesn't when you have a very specific setup with modelsbuilder.So the top of your template page should be:
Not
Hi Damien,
Believe or not but this solution helped me to resolve the issue. Still don't understand why it is causing an issue in first place.
I just removed the
Thanks
No worries, glad my experience could be of some use to you Pavel.
My understanding is that in different scenarios the model builder makes an object for each template, but the modelbuilder has to be setup to do this when using visual studio.
I have never seen a guide on how this works that covers or resolves this issue. So I figured I just wouldn't use the local template model and it worked.
Can you mark my answer correct please, so others know what helped.
is working on a reply...