Copied to clipboard

Flag this post as spam?

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


  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:35
    Rasmus Fjord
    0

    Installing issues TC 3 on Umbraco 7.1.8

    Hey 

    We are adding a webshop to an already running solution. Its a Umbraco 7.1.8. Ive just installed the package, TC3. It dosnt appear on the sidebar, its not under the user config(to be added) if i force the URL :

    http://localhost:1367/umbraco#/teacommerce

    i get to the section but when i click on anything it doesnt load anything just keep spinning. No logs are thrown in either the browser or the log files. If i look in network it just says 302 found and nothing is returned. Ive tried to update to 719 but rolled back because it gave nothing actually.

     

  • Maff 141 posts 465 karma points
    Feb 03, 2015 @ 10:38
    Maff
    0

    Hi Rasmus,

    Check the permissions for your user - you may have to give them access to the Tea Commerce module in order for them to see it.

    Cheers,

    Maff

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:39
    Rasmus Fjord
    0

    Right now im trying to rollling everything back database/files to try and reinstall it.

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:40
    Rasmus Fjord
    0

    Hey maff thanks for posting :) 

    As i wrote i already checked under the user config and it wasnt there. Tried emptying cache, and all that jazz. I can force my way to the section but nothing works when clicking it.

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:51
    Rasmus Fjord
    0

    on install i can see that im getting this bug : 

     

    2015-02-03 09:31:33,679 [45] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 29] Error loading package action 'GrantPermissions' for package Tea Commerce
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'TeaCommerce_Store'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at TeaCommerce.Api.Persistence.Database.<Query>d__c`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetInternal(String sql, Object[] args)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetAll()
       at TeaCommerce.Api.Services.StoreService.GetCachedList()
       at TeaCommerce.Api.Services.StoreService.GetAll()
       at TeaCommerce.Umbraco.Install.PackageActions.GrantPermissions.Execute(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.RunPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    ClientConnectionId:588591db-2d9f-4b70-9fb3-42cdb3d305a7
    Error Number:208,State:1,Class:16
  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:52
    Rasmus Fjord
    0

    And this one afterwards:

    2015-02-03 10:09:43,317 [16] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 35] Error undoing package action 'AddTree' for package Tea Commerce
    System.NullReferenceException: Object reference not set to an instance of an object.
       at TeaCommerce.Umbraco.Install.PackageActions.AddTree.Undo(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.UndoPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    2015-02-03 10:09:43,317 [16] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 35] Error undoing package action 'AddTree' for package Tea Commerce
    System.NullReferenceException: Object reference not set to an instance of an object.
       at TeaCommerce.Umbraco.Install.PackageActions.AddTree.Undo(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.UndoPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    2015-02-03 10:09:43,317 [16] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 35] Error undoing package action 'AddTree' for package Tea Commerce
    System.NullReferenceException: Object reference not set to an instance of an object.
       at TeaCommerce.Umbraco.Install.PackageActions.AddTree.Undo(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.UndoPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    2015-02-03 10:09:43,317 [16] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 35] Error undoing package action 'AddTree' for package Tea Commerce
    System.NullReferenceException: Object reference not set to an instance of an object.
       at TeaCommerce.Umbraco.Install.PackageActions.AddTree.Undo(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.UndoPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    2015-02-03 10:09:43,707 [16] ERROR TeaCommerce.Umbraco.Configuration.Infrastructure.Logging.LoggingProvider - [Thread 35] System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "TeaCommerce_OrderAmountRuleAmount" because it does not exist or you do not have permissions.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at TeaCommerce.Api.Persistence.Database.Execute(Sql Sql)
       at TeaCommerce.Api.Persistence.Installation.PersistenceInstaller.ExecuteScript(Database database, SqlScript sqlScript, Boolean updateDatabaseVersion)
    ClientConnectionId:9fb52dfb-81ac-480e-8ab9-b285905049b7
    Error Number:4902,State:1,Class:16
    System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "TeaCommerce_OrderAmountRuleAmount" because it does not exist or you do not have permissions.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at TeaCommerce.Api.Persistence.Database.Execute(Sql Sql)
       at TeaCommerce.Api.Persistence.Installation.PersistenceInstaller.ExecuteScript(Database database, SqlScript sqlScript, Boolean updateDatabaseVersion)
    ClientConnectionId:9fb52dfb-81ac-480e-8ab9-b285905049b7
    Error Number:4902,State:1,Class:16
  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 10:58
  • Maff 141 posts 465 karma points
    Feb 03, 2015 @ 11:17
    Maff
    0

    Ah ok - yes that's because SQL Azure doesn't support the 'on primary' which is referring to the database file location on the server.

    One option would be to create a local SQL DB and install Umbraco/TC and then move the DB up to SQL Azure. I wrote a 'how to' in this article (about half way through the article) which details moving a local DB to Azure:

    http://maffrigby.com/how-to-deploy-umbraco-7-to-an-azure-website-using-visual-studio-online/

    Cheers,

    Maff

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 11:26
    Rasmus Fjord
    0

    Hey Maff


    Yea that is an option of course. Ive talked with TC and they will add a solution to this post, so hoping for a SQL script.

  • Maff 141 posts 465 karma points
    Feb 03, 2015 @ 11:29
    Maff
    0

    Cool - that sounds like a much better option! :)

  • Anders Burla 2560 posts 8256 karma points
    Feb 03, 2015 @ 12:14
    Anders Burla
    0

    How does your connection string for the DB looks like? I think PetaPoco doesnt know that you are using Azure and is trying to run the MS sql scripts.

    Kind regards
    Anders

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 12:15
    Rasmus Fjord
    0

    Actually i moved the SQL to a total standard local sql server for development.

       <remove name="umbracoDbDSN" />

        <add name="umbracoDbDSN" connectionString="server=mymachine\SQLEXPRESS;database=dbname;user id=sqladmin;password=somerandomshit" providerName="System.Data.SqlClient" />

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 12:21
    Rasmus Fjord
    0

    But the database is a copy from the azure sql so gussing it has the same settings as an azure sql.

  • Anders Burla 2560 posts 8256 karma points
    Feb 03, 2015 @ 12:29
    Anders Burla
    0

    That is why. PetaPoco thinks its a normal SQL db because it doesn't start with tcp: at the start. Could you try and install Tea Commerce with the DB online and a tcp: address that an sql azure might have in its address - havent used azure so dont know :)

    Kind regards
    Anders

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 12:50
    Rasmus Fjord
    0

    Ive added this as a constring instead, uninstalled and reinstalled but still nothing:

      <add name="umbracoDbDSN" connectionString="Data Source=tcp:Codemonkey\SQLEXPRESS;Initial Catalog=somedb;User ID=sqladmin;Password=fasdfsadsad sa dasda sas da;Trusted_Connection=False;Encrypt=False;Connection Timeout=30;" providerName="System.Data.SqlClient" />
    
       

    Still the same though, The above is just like an azure, and since it needs to work at local aswell. When ive installed with the above and try to create a shop in the TC panel i get this :

     

    Value cannot be null. Parameter name: The treeType query string parameter was not found but is required

    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.ArgumentNullException: Value cannot be null. Parameter name: The treeType query string parameter was not found but is required 

    Stack Trace: 

    at Umbraco.Web.FormDataCollectionExtensions.GetRequiredString(FormDataCollection items, String key)
       at Umbraco.Web.Trees.LegacyTreeController.GetTree(FormDataCollection queryStrings)
       at Umbraco.Web.Trees.LegacyTreeController.GetTreeNodes(String id, FormDataCollection queryStrings)
       at Umbraco.Web.Trees.TreeControllerBase.GetNodes(String id, FormDataCollection queryStrings)
       at lambda_method(Closure , Object , Object[] )
       at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass13.<GetExecutor>b__c(Object instance, Object[] methodParameters)
       at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
       at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.<>c__DisplayClass5.<ExecuteAsync>b__4()
       at System.Threading.Tasks.TaskHelpers.RunSynchronously[TResult](Func`1 func, CancellationToken cancellationToken)
  • Anders Burla 2560 posts 8256 karma points
    Feb 03, 2015 @ 12:58
    Anders Burla
    0

    So when installing the DB tables isnt installed even if you use an online azure DB?

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 14:31
    Rasmus Fjord
    0

    Havnt tried on an online azure database just tried on local edition. 

    But the tabels gets somewhat created dunno if this is all of them.

     

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 16:11
    Rasmus Fjord
    0

    So ive tried alot of things now. Ive dropped installing it directly nothing works its like the same error just keeps comming up. 

    So i tried installing a CLEAN umbraco 7.2.1 on a CLEAN sql database. Nothing azure no nothing. 

    The sql version is quite default and is this one : 

     

    And still its the same pattern, install the package, set permissions on my user opens TC area, creates a new store and it just keeps spinning on the load. No errors in the browser console. When i click on the store it gives me this in the network view:

    And in the log on install is this error throw again :

    2015-02-03 15:57:49,423 [21] ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 16] Error loading package action 'GrantPermissions' for package Tea Commerce
    System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'TeaCommerce_Store'.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
       at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at TeaCommerce.Api.Persistence.Database.<Query>d__c`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetInternal(String sql, Object[] args)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetAll()
       at TeaCommerce.Api.Services.StoreService.GetCachedList()
       at TeaCommerce.Api.Services.StoreService.GetAll()
       at TeaCommerce.Umbraco.Install.PackageActions.GrantPermissions.Execute(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.RunPackageAction(String packageName, String actionAlias, XmlNode actionXml)
    ClientConnectionId:32f34461-2397-47ff-b79c-a6d280163eef
    Error Number:208,State:1,Class:16

     

     

  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 03, 2015 @ 16:51
    Rasmus Fjord
    0

    Another test.

    Clean installed 7.2.1 with SQL CE and then went to install tc 3 and almost the same bug :

    ERROR umbraco.cms.businesslogic.packager.PackageAction - [Thread 12] Error loading package action 'GrantPermissions' for package Tea Commerce
    System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ TeaCommerce_Store ]
       at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
       at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
       at System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior)
       at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
       at TeaCommerce.Api.Persistence.Database.<Query>d__c`1.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetInternal(String sql, Object[] args)
       at TeaCommerce.Api.Persistence.Repositories.StoreRepository.GetAll()
       at TeaCommerce.Api.Services.StoreService.GetCachedList()
       at TeaCommerce.Api.Services.StoreService.GetAll()
       at TeaCommerce.Umbraco.Install.PackageActions.GrantPermissions.Execute(String packageName, XmlNode xmlData)
       at umbraco.cms.businesslogic.packager.PackageAction.RunPackageAction(String packageName, String actionAlias, XmlNode actionXml)
  • Rasmus Fjord 675 posts 1566 karma points c-trib
    Feb 04, 2015 @ 15:57
    Rasmus Fjord
    100

    Gonna close this one myself :) 

    With help from anders we figured out together that my chrome(my primary browser) was not update på everything was working in chrome. because of some Cookie handling issue.

Please Sign in or register to post replies

Write your reply to:

Draft