Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • MBE 236 posts 817 karma points
    Jan 14, 2020 @ 18:31
    MBE
    0

    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:

         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?

    // Mike

  • Matt Brailsford 2758 posts 13973 karma points MVP 7x c-trib
    Jan 14, 2020 @ 19:58
    Matt Brailsford
    1

    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

  • MBE 236 posts 817 karma points
    Jan 14, 2020 @ 20:26
    MBE
    0

    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

    2020-01-14 21:20:17,849 [P130972/D2/T1] 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)
    

    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

  • Matt Brailsford 2758 posts 13973 karma points MVP 7x c-trib
    Jan 15, 2020 @ 07:53
    Matt Brailsford
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft