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 :
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.
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.
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
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:
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 :)
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)
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
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)
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.
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.
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
Right now im trying to rollling everything back database/files to try and reinstall it.
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.
on install i can see that im getting this bug :
And this one afterwards:
seems to be the same issue here :
http://our.umbraco.org/projects/website-utilities/tea-commerce/tea-commerce-support/57657-Support-for-Azure-SQL
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
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.
Cool - that sounds like a much better option! :)
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
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" />
But the database is a copy from the azure sql so gussing it has the same settings as an azure sql.
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
Ive added this as a constring instead, uninstalled and reinstalled but still nothing:
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
Exception Details: System.ArgumentNullException: Value cannot be null. Parameter name: The treeType query string parameter was not found but is required
Stack Trace:
So when installing the DB tables isnt installed even if you use an online azure DB?
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.
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 :
Another test.
Clean installed 7.2.1 with SQL CE and then went to install tc 3 and almost the same bug :
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.
is working on a reply...