I installed Umbraco 6.1.6 and uCommerce 4.0.6.13304 from local package. Everything went well, but opening the "Commerce" section, gives me a blank uCommerce menu - no content at all.
I'm running Windows 8.1 Pro (IIS 8.5) through Parallels. Refreshing the app pool didn't seem to do anything.
Below i've posted the tracelog. Any idea why SQL data seems to make throuble on a clean install?
[code]
2013-12-15 21:38:21,803 [7] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select TOP (1) role0_.RoleId as RoleId76_, role0_.Name as Name76_, role0_.ParentRoleId as ParentRo4_76_, role0_.ProductCatalogGroupId as ProductC5_76_, role0_.CultureCode as CultureC6_76_, role0_.PriceGroupId as PriceGro7_76_, role0_.ProductCatalogId as ProductC8_76_, role0_.RoleType as RoleType76_ from uCommerce_Role role0_
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
The database user HAS the right priviledes, otherwise I wouldn't be able to install Umbraco, right? I just tried with uCommerce 5.1.0.13354 and a fresh Umbraco 6.1.6, same problem.
ERROR NHibernate.AdoNet.AbstractBatcher
I installed Umbraco 6.1.6 and uCommerce 4.0.6.13304 from local package. Everything went well, but opening the "Commerce" section, gives me a blank uCommerce menu - no content at all.
I'm running Windows 8.1 Pro (IIS 8.5) through Parallels. Refreshing the app pool didn't seem to do anything.
Below i've posted the tracelog. Any idea why SQL data seems to make throuble on a clean install?
[code]
2013-12-15 21:38:21,803 [7] ERROR NHibernate.AdoNet.AbstractBatcher - Could not execute query: select TOP (1) role0_.RoleId as RoleId76_, role0_.Name as Name76_, role0_.ParentRoleId as ParentRo4_76_, role0_.ProductCatalogGroupId as ProductC5_76_, role0_.CultureCode as CultureC6_76_, role0_.PriceGroupId as PriceGro7_76_, role0_.ProductCatalogId as ProductC8_76_, role0_.RoleType as RoleType76_ from uCommerce_Role role0_
System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'uCommerce_Role'.
at System.Data.SqlClient.SqlConnection.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 NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd)
at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session)
at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies)
at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
ClientConnectionId:eed368fa-6382-4f04-b497-301dc3fce851
2013-12-15 21:38:21,803 [7] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_Role'.
2013-12-15 21:38:21,803 [7] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_Role'.
2013-12-15 21:38:21,803 [7] ERROR NHibernate.Util.ADOExceptionReporter - Invalid object name 'uCommerce_Role'.
Hi egeek,
It looks like the uCommerce tables didn't get created during the install. Make sure your database user has all the right security privileges.
You can test that easily by logging in with the user in the Management Studio, and try if you can create any tables.
Hope that helps,
Lars
Hej Lars,
The database user HAS the right priviledes, otherwise I wouldn't be able to install Umbraco, right?
I just tried with uCommerce 5.1.0.13354 and a fresh Umbraco 6.1.6, same problem.
Is there a script out there to create all the needed tables manually?
I created a gist witht he log: https://gist.github.com/anonymous/8152071
I'm pretty lost here why tables are not created.
Hello Egeek,
Are no uCommerce tables created in the database?
Could you please send a copy of the installation log? Something must go wrong during installation.
Kind regards,
Jesper
is working on a reply...