Copied to clipboard

Flag this post as spam?

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


These support forums are now closed for new topics and comments.
Please head on over to http://eureka.ucommerce.net/ for support.

  • egeek 40 posts 179 karma points
    Dec 15, 2013 @ 21:39
    egeek
    0

    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'.

    [/code]
  • Lars Horne-Mortensen 40 posts 184 karma points
    Dec 16, 2013 @ 12:46
    Lars Horne-Mortensen
    0

    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

  • egeek 40 posts 179 karma points
    Dec 27, 2013 @ 21:19
    egeek
    0

    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.

  • Jesper Nielsen 141 posts 498 karma points
    Jan 06, 2014 @ 10:11
    Jesper Nielsen
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft