Copied to clipboard

Flag this post as spam?

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


  • Martin 278 posts 662 karma points
    Jul 05, 2012 @ 13:55
    Martin
    0

    Tea Commerce Start Kit Problem - Backend

    Hi, Ive just installed the starter kit on a server.

    im having some issues with the backedn of tea commerce, with the tea commerce tab showing the error below.

     

    Invalid object name 'dbo.TeaCommerce_EmailTemplate'.
    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.Data.SqlClient.SqlException: Invalid object name 'dbo.TeaCommerce_EmailTemplate'.
    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: 
    [SqlException (0x80131904): Invalid object name 'dbo.TeaCommerce_EmailTemplate'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073550
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064508
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
       System.Data.SqlClient.SqlDataReader.get_MetaData() +86
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
       System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
       System.Data.Common.DbCommand.ExecuteReader() +12
       System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult) +1266
       System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries) +113
       System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +344
       System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +34
       System.Linq.Enumerable.ToDictionary(IEnumerable`1 source, Func`2 keySelector, Func`2 elementSelector, IEqualityComparer`1 comparer) +151
       TeaCommerce.Data.EmailTemplate.<GetEmailTemplatesDictionary>b__e() +2408
       Tea.Web.Extension.CacheTools.GetOrAdd(Cache cache, String key, Func`1 retriveValue, CacheDependency dependencies, DateTime absoluteExpiration, TimeSpan relativeExpiration, CacheItemPriority priority, CacheItemRemovedCallback onRemoveCallback) +97
       Tea.Web.Extension.CacheTools.GetOrAdd(Cache cache, Func`1 retriveValue, TimeSpan ttl, String key) +96
       TeaCommerce.Data.EmailTemplate.GetEmailTemplatesDictionary() +138
       TeaCommerce.Admin.Umbraco.plugins.TeaCommerce.Settings.Orders.EditGenerelSettings.OnLoad(EventArgs e) +275
       System.Web.UI.Control.LoadRecursive() +74
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

     

     

     

    I have renamed the hostname on the "en" node, but I am getting parseing errors on the macros.

    Any ideas would be great.

     

    Martin

     

     

  • Anders Burla 2560 posts 8256 karma points
    Jul 05, 2012 @ 14:50
    Anders Burla
    0

    Hi Martin

    How did you install the starter kit? Using the installtion guide? It is not a package for Umbraco - it is more a starting point. DB + websites files and all. So you should use it as your entire starting point. Not install Umbraco first.

    Kind regards
    Anders

  • Martin 278 posts 662 karma points
    Jul 05, 2012 @ 15:00
    Martin
    0

    Hi Anders, 

    I followed the install steps from the Starter Kit.

    I created a temp domain on shared hosted server and followed the steps from there.

    You can have a look at it on tea.e-vps.net and see the debug.

  • Anders Burla 2560 posts 8256 karma points
    Jul 05, 2012 @ 15:07
    Anders Burla
    0

    Could you look at the datase and see if all tables is installed? And maybe also the dbo thing.

    Try look at this:
    http://our.umbraco.org/projects/website-utilities/tea-commerce/tea-commerce-support/32667-SQL-query-in-starterkit-2101

    Kind regards
    Anders

Please Sign in or register to post replies

Write your reply to:

Draft