So I'm still having the problem where I'm being logged out randomly when navigating in the backend and creating products. I went to check my log and found the usual:
ERROR TeaCommerce.Api.Persistence.Installation.PersistenceInstaller - Error executing script. Schema version: 8
System.Data.SqlServerCe.SqlCeException (0x80004005): Invalid column ID. [ FirstNamePropertyAlias ]
at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
at TeaCommerce.Api.Persistence.Database.Execute(Sql Sql)
at TeaCommerce.Api.Persistence.Installation.PersistenceInstaller.ExecuteScript(Database database, SqlScript sqlScript, Boolean updateDatabaseVersion)
But underneath it, I found this fella which is weird since I have a license:
TeaCommerce.Api.Infrastructure.Licensing.LicenseException: Tea Commerce isn't licensed. You can only have 20 finalized orders in the test version. Reset the "CurrentOrderNumber" variable to 0 or buy a license at http://www.teacommerce.net
at TeaCommerce.Api.Models.Order.Save()
at TeaCommerce.Api.Web.TeaCommerceHelper.GetCurrentOrder(Int64 storeId, Boolean autoCreate)
at TeaCommerce.Api.Web.TeaCommerceHelper.AddOrUpdateOrderLine(Int64 storeId, String productIdentifier, Nullable`1 quantity, IDictionary`2 properties, Boolean overwriteQuantity, String bundleIdentifier, String parentBundleIdentifier)
at TeaCommerce.Api.Web.FormPostHandler.AddOrUpdateOrderLine(Int64 storeId, IDictionary`2 formFields, IDictionary`2 settings)
at TeaCommerce.Api.Web.FormPostHandler.FormPost()
In my /bin/ folder I do have the .lic file. Do you have an idea what this could be?
This should only occur if you are modifying the order either on a different domain to which it's licensed, or out of a HTTP context. Doe you have any scripts that run outside of a web context that modify orders?
Failing that, did you ever resolve the issue last time? I believe my suggestion was to increase your server resources as I think you were running out of cpu/memory. Did you ever try this?
I don't use any kind of magic beside what is default in Umbraco.
I have just upgraded to 7.15.3 hoping it does some kind of improvement.
I just noticed the license error and thought I'd ask just to be sure :) I did another test purchase and so far, I'm not seeing it in the logs. But I'll keep and eye out for it.
However, regarding the other issue I did upgrade the hosting plan to "Business plan" but nothing has changed.
Are you actually running your site on SQL CE? It’s not usually recommended for a live site, but saying that you shouldn’t be getting an error.
Clearly the installer scripts keep running and failing which I don’t know why. Best I could suggest is maybe pull our demo site from GitHub and then manually verify the database schema. Also checking the Tc version table as it’s this which controls re-running the install scripts if things aren’t on the latest version (again, compare that with the demo store dB)
Tea Commerce isn't licensed.
Hey guys,
So I'm still having the problem where I'm being logged out randomly when navigating in the backend and creating products. I went to check my log and found the usual:
But underneath it, I found this fella which is weird since I have a license:
In my /bin/ folder I do have the .lic file. Do you have an idea what this could be?
// Mike
Hi Mike,
This should only occur if you are modifying the order either on a different domain to which it's licensed, or out of a HTTP context. Doe you have any scripts that run outside of a web context that modify orders?
Failing that, did you ever resolve the issue last time? I believe my suggestion was to increase your server resources as I think you were running out of cpu/memory. Did you ever try this?
Matt
Hey Matt!
I don't use any kind of magic beside what is default in Umbraco. I have just upgraded to 7.15.3 hoping it does some kind of improvement.
I just noticed the license error and thought I'd ask just to be sure :) I did another test purchase and so far, I'm not seeing it in the logs. But I'll keep and eye out for it.
However, regarding the other issue I did upgrade the hosting plan to "Business plan" but nothing has changed.
I did find this thread which seems to cover my problem: https://our.umbraco.com/forum/using-umbraco-and-getting-started/80488-recurring-application-shutdown-issue-on-umbraco-753
Some are claiming the IIS restarts if more than X errors occours in X minutes. I do seem to get the
a whole lot within a second so that might be why it restarts.
I might need to look for a new host. I'm currently using UnoEuro.
// Mike
Hmm, it is strange indeed.
Are you actually running your site on SQL CE? It’s not usually recommended for a live site, but saying that you shouldn’t be getting an error.
Clearly the installer scripts keep running and failing which I don’t know why. Best I could suggest is maybe pull our demo site from GitHub and then manually verify the database schema. Also checking the Tc version table as it’s this which controls re-running the install scripts if things aren’t on the latest version (again, compare that with the demo store dB)
Hope this helps
Matt
is working on a reply...