I have created an Umbraco v7 website with sql ce that works perfectly fine in development environment.
However, when moving it to production, it gives below error.
I would find it strange that Umbraco7 does not support sql ce, so can anyone tell me how to fix this?
Big thanks beforehand!
Manu
Server Error in '/' Application.
Keyword not supported: 'flush interval'.
Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code.
Exception Details:
System.ArgumentException: Keyword not supported: 'flush
interval'.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Sounds like the hosting provider doesn't support the latest version of SQL CE. The keyword was added in 4.0 and your host seems to be using 3.5 instead. It MIGHT work if you remove Flush Interval=1; from the connection string in your web.config.. but absolutely NO guarantees and it could corrupt your database if the hoster's installed version is different.
Thanks for all your replies.
I'm hosting my website without any additional packages or anything on Godaddy servers.
Currently I've put it on full trust as it doesn't seem to work on medium trust.
It's working on ASP.NET 4.0.30319.18408 (just checking in Parallels Plesk).
Preferably don't want to try to remove the Flush interval as I'm looking for a constructive solution that is not prone to error.
Manu, did you install Umbraco into Visual Studio via NuGet?
Did you publish your site with Visual Studio, FTP, or WebMatrix? Or did GoDaddy install Umbraco for you from one of their web app installers?
Is your "development environment" on your computer or on a GoDaddy server? Have you tried publishing a bare bones Umbraco site with SQL CE to your production environment as a test?
Website was created in Visual Studio via NuGet (as I needed MVC capabilities).
Publishing however was done via Webmatrix as I feel this goes faster.
As such, it's actually just a Web Deploy file upload to the Umbraco server.
The website I made on Umbraco v6 is working perfectly also with SQL CE, but Umbraco v7 sites all seem to give the same error as I tried multiple v7 sites.
No bare bones install done yet. If this would help localize the issue then I will try that first thing tomorrow.
Any other ideas on what I did wrong?
Okay. I don't think you are doing anything wrong. I am currently not able to publish an Umbraco SQL CE project from Visual Studio. WebMatrix publishes the same project fine though. That seems to be what you are doing...
Below some things I've tried with no success:
@Sebastiaan: Removing the Flush Interval = 1 in the connection string does not help as I then get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
This seems to be a connection string issue which is very strange.
Moreover, I recently discovered that for some reason Webmatrix is not copying the umbraco.sdf database to the AppData folder when I do my Web Deploy (despite the fact that it's in my project and clicked on to publish too). Haven't had this issue before. Nevertheless, even after copying it to AppData folder myself, the error still remains.
Any other ideas from someone on how to troubleshoot this?
I don't have anything against SQL Express as such, but I'm a hobby programmer that hasn't worked a lot with databases/SQL Server Management Studio etc. Therefore, using SQL CE is a good out-of-the-box solution that doesn't require setup with database migration, connection string setup etc... Anyway, viewing SQL CE does not seem to be supported in production, I guess I'll have to make the jump to SQL Express.
I've been reading some documentation meanwhile and managed to convert my umbraco.sdf to an umbraco.mdf database.
Now I still need to get it working with a correct connection string, but haven't found a solution yet.
Can anyone give me an example of their web.config settings on public hosting to connect to a database?
Did you ever find a solution for this? My SqlCE had the same issue when using Plesk. All permissions were set correctly with the same version of .NET. I really don't want to use SQL or other DB, but I guess I can, just the ease of using SqlCE that is just supposed to work. Works in local but not on the production server.
Umbraco 7 not possible in production with sql ce?
I have created an Umbraco v7 website with sql ce that works perfectly fine in development environment.
However, when moving it to production, it gives below error.
I would find it strange that Umbraco7 does not support sql ce, so can anyone tell me how to fix this?
Big thanks beforehand!
Manu
Server Error in '/' Application.
Keyword not supported: 'flush interval'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentException: Keyword not supported: 'flush interval'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18447
Hi Manu
Has the production environment been setup with the neccessary frameworks, permissions etc. that is required in order for Umbraco to work?
Has the IIS website been set up properly etc. etc.?
Is it a dedicated server or shared hosting? If it's shared hosting what company is it and do they support Umbraco in full trust?
/Jan
Hi Manu
Have you installed some packages on the production server that you don't use on the local version btw?
/Jan
Sounds like the hosting provider doesn't support the latest version of SQL CE. The keyword was added in 4.0 and your host seems to be using 3.5 instead. It MIGHT work if you remove
Flush Interval=1;
from the connection string in your web.config.. but absolutely NO guarantees and it could corrupt your database if the hoster's installed version is different.Hi everyone,
Thanks for all your replies. I'm hosting my website without any additional packages or anything on Godaddy servers. Currently I've put it on full trust as it doesn't seem to work on medium trust. It's working on ASP.NET 4.0.30319.18408 (just checking in Parallels Plesk).
Preferably don't want to try to remove the Flush interval as I'm looking for a constructive solution that is not prone to error.
Hopefully the above helps to identify the issue.
Thanks again! Manu
Manu, did you install Umbraco into Visual Studio via NuGet?
Did you publish your site with Visual Studio, FTP, or WebMatrix? Or did GoDaddy install Umbraco for you from one of their web app installers?
Is your "development environment" on your computer or on a GoDaddy server? Have you tried publishing a bare bones Umbraco site with SQL CE to your production environment as a test?
DaveC,
Website was created in Visual Studio via NuGet (as I needed MVC capabilities). Publishing however was done via Webmatrix as I feel this goes faster.
As such, it's actually just a Web Deploy file upload to the Umbraco server. The website I made on Umbraco v6 is working perfectly also with SQL CE, but Umbraco v7 sites all seem to give the same error as I tried multiple v7 sites.
No bare bones install done yet. If this would help localize the issue then I will try that first thing tomorrow. Any other ideas on what I did wrong?
Thanks! Manu
Manu,
Okay. I don't think you are doing anything wrong. I am currently not able to publish an Umbraco SQL CE project from Visual Studio. WebMatrix publishes the same project fine though. That seems to be what you are doing...
Dave
Hi everyone,
Below some things I've tried with no success: @Sebastiaan: Removing the Flush Interval = 1 in the connection string does not help as I then get the following error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
This seems to be a connection string issue which is very strange. Moreover, I recently discovered that for some reason Webmatrix is not copying the umbraco.sdf database to the AppData folder when I do my Web Deploy (despite the fact that it's in my project and clicked on to publish too). Haven't had this issue before. Nevertheless, even after copying it to AppData folder myself, the error still remains.
Any other ideas from someone on how to troubleshoot this?
Thanks! Manu
Seems like everyone suggests SQL Express or better for production. Any reason not to?
Hey Matthew,
I don't have anything against SQL Express as such, but I'm a hobby programmer that hasn't worked a lot with databases/SQL Server Management Studio etc. Therefore, using SQL CE is a good out-of-the-box solution that doesn't require setup with database migration, connection string setup etc... Anyway, viewing SQL CE does not seem to be supported in production, I guess I'll have to make the jump to SQL Express.
I've been reading some documentation meanwhile and managed to convert my umbraco.sdf to an umbraco.mdf database. Now I still need to get it working with a correct connection string, but haven't found a solution yet. Can anyone give me an example of their web.config settings on public hosting to connect to a database?
Thanks! Manu
Hey Manu,
Did you ever find a solution for this? My SqlCE had the same issue when using Plesk. All permissions were set correctly with the same version of .NET. I really don't want to use SQL or other DB, but I guess I can, just the ease of using SqlCE that is just supposed to work. Works in local but not on the production server.
is working on a reply...