Outdated Database Format/Error Content Failed Match

    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      PokerStrategy.com Elephant version number: 0.105
      Please fill in the current version number, e.g. v0.69

      Which operating system:
      (X) XP
      ( ) Vista
      ( ) Windows 7

      Which poker room:
      (X) PartyPoker
      ( ) PokerStars
      ( ) Full Tilt Poker
      ( ) iPoker Network (e.g. William Hill Poker, Titan Poker, Mansion Poker, etc.)
      ( ) Everest Poker
      ( ) Others: ______________

      Which game type:
      (X) Cash Game (NL 0.05/0.10, 0.01/0.02)
      (X) Tourney (Poker strategy freeroll etc...)

      Have you searched the FAQ:
      See: FAQ
      (X) Yes (but the problem isn't listed)
      ( ) No

      Relevant screenshot available:
      (X) Yes
      ( ) No (a screenshot is irrelevant concerning the problem)

      Error messages in the logfile:
      Where can I find the logfile on my computer? See here
      (X) Yes (Please don't forget to post the logfile's content)
      ( ) No

      In case of problems related to the database:
      Was the PostgreSQL Database Service installed separately?
      (X) Yes
      ( ) No (the Elephant has installed Postgres)

      Have you read the database section in the FAQ?
      See: here
      (X) Yes (but the problem isn't listed)
      ( ) No

      Problem description:

      Installed the poker elephant regularly with Postgres intallation. Right after the installation and database creation a message appears.

      "Outdated database Format

      You are trying to use a database that is incompatible to the current version of the PokerStrategy.com Elephant. In order to retain your hand histories, we will automatically export all of them to your harddisk, update the databe, and then reimport your data into the new database. After successfull reimport, the exprted files will be deleted.

      You can click here to open the upgrade folder."

      Tried to click it but nothing happened.

      I tried to automatically and manually import the files but I get the same error in the uploaded files.

      "Error content failed to match."

      Uninstalled and reinstalled again but ended up with the same problem.
      Installed a new version of PostgresSQL in the website with the same results.

      Please help.



      Logfiles
      _____________________________________-----


      2012-01-11 02:51:24,953 - [1] 2484 INFO : -------------------- Launching 'Elephant.exe' (Version: 0.105.40920.2) --------------------
      2012-01-11 02:51:53,421 - [3] 30953 INFO : -------------------- System Info --------------------
      2012-01-11 02:51:53,453 - [3] 30984 INFO : CPU: Intel(R) Atom(TM) CPU N280 @ 1.66GHz at 1661 Mhz with 2 cores (x86 Family 6 Model 28 Stepping 2)
      2012-01-11 02:51:53,453 - [3] 30984 INFO : OS : Microsoft Windows XP Home Edition (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2012-01-11 02:51:53,453 - [3] 30984 INFO : RAM: 1.99GB
      2012-01-11 02:51:53,453 - [3] 30984 INFO : Culture info: en-US
      2012-01-11 02:53:10,734 - [1] 108265 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 709
      - Routine: InitPostgres
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2012-01-11 02:53:21,343 - [1] 118875 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 709
      - Routine: InitPostgres
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2012-01-11 02:53:21,437 - [1] 118968 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 709
      - Routine: InitPostgres
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2012-01-11 02:53:48,687 - [1] 146218 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.2291861(00:00:00.0052948/00:00:00.0003235)
      2012-01-11 02:54:04,921 - [1] 162453 WARN : Cannot find the version table - will export schema now.
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.Repositories.VersionHistoryRepository.GetHighestVersion()
      at PSE.Database.Controller.ElephantDatabaseController.TryUpdateDatabase()
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - SqlString: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
      at NHibernate.Impl.CriteriaImpl.List(IList results)
      at NHibernate.Impl.CriteriaImpl.List[T]()
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetElementList(MethodCallExpression call, Int32 count)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.HandleFirstCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.VisitMethodCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetResults(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.RootVisitor.HandleImmediateResultsCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.RootVisitor.VisitMethodCall(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.TranslateInternal(Expression expression)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.Translate(Expression expression, QueryOptions queryOptions)
      at NHibernate.Linq.NHibernateQueryProvider.TranslateExpression(Expression expression)
      at NHibernate.Linq.NHibernateQueryProvider.Execute(Expression expression)
      at NHibernate.Linq.QueryProvider.System.Linq.IQueryProvider.Execute[T](Expression expression)
      at System.Linq.Queryable.First[TSource](IQueryable`1 source)
      at PS.Database.nHibernate.Repositories.VersionHistoryRepository.<>c__DisplayClass4.<GetHighestVersion>b__3()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42P01: relation "pse_versionhistory" does not exist
      - Severity: ERROR
      - Code: 42P01
      - BaseMessage: relation "pse_versionhistory" does not exist
      - Detail:
      - Hint:
      - Position: 81
      - Where:
      - File: .\src\backend\parser\parse_relation.c
      - Line: 857
      - Routine: parserOpenTable
      - ErrorSql: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit ((1)::int4)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null>1 items
      actual-sql-query - actual-sql-query
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.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)
      2012-01-11 02:54:40,796 - [1] 198328 INFO : Installed PostgreSQL version: PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 32-bit
      2012-01-11 02:54:40,796 - [1] 198328 INFO : MainForm.UseDatabase took 00:00:52.8047371
      2012-01-11 02:55:43,953 - [1] 261484 INFO : MainForm.Init - before LoadSettings - 00:00:00.0003816
      2012-01-11 02:55:46,484 - [1] 264015 INFO : MainForm.Init - before StartPatchDatabase - 00:00:02.5276941
      2012-01-11 02:55:46,687 - [1] 264218 INFO : MainForm.Init - before UseDatabase - 00:00:02.7422795
      2012-01-11 02:55:46,859 - [1] 264390 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.0851233(00:00:00.0007785/00:00:00.0000036)
      2012-01-11 02:55:46,906 - [1] 264437 INFO : Installed PostgreSQL version: PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 32-bit
      2012-01-11 02:55:46,906 - [1] 264437 INFO : MainForm.UseDatabase took 00:00:00.2205453
      2012-01-11 02:55:46,906 - [1] 264437 INFO : MainForm.Init - before InitTables - 00:00:02.9641110
      2012-01-11 02:55:46,921 - [1] 264453 INFO : MainForm.Init - before ReadPortalDesc - 00:00:02.9658934
      2012-01-11 02:55:48,796 - [1] 266328 INFO : MainForm.Init - before GenerateExistingPortalsAndPlayersList - 00:00:04.8461486
      2012-01-11 02:55:48,984 - [1] 266515 INFO : MainForm.Init took 00:00:05.0296920
      2012-01-11 02:55:50,968 - [1] 268500 INFO : MainForm._Loaded took 00:00:01.6910453
      2012-01-11 02:55:51,250 - [1] 268781 INFO : Starting background version check...
      2012-01-11 02:55:54,500 - [15] 272031 INFO : Background version check finished.
      Latest Version: 0.102.40520.2
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2012-01-11 02:58:07,312 - [1] 404843 INFO : Initializing shutdown (shutting down controllers).
      2012-01-11 02:58:10,953 - [1] 408484 INFO : Finalising shutdown.

      _________________________________________________


      2012-01-10 05:02:29,890 - [1] 359 INFO : -------------------- Launching 'Elephant.exe' (Version: 0.105.40920.2) --------------------
      2012-01-10 05:02:31,218 - [3] 1687 INFO : -------------------- System Info --------------------
      2012-01-10 05:02:31,218 - [3] 1687 INFO : CPU: Intel(R) Atom(TM) CPU N280 @ 1.66GHz at 1662 Mhz with 2 cores (x86 Family 6 Model 28 Stepping 2)
      2012-01-10 05:02:31,218 - [3] 1687 INFO : OS : Microsoft Windows XP Home Edition (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2012-01-10 05:02:31,218 - [3] 1687 INFO : RAM: 1.99GB
      2012-01-10 05:02:31,218 - [3] 1687 INFO : Culture info: en-US
      2012-01-10 05:02:37,281 - [1] 7750 INFO : -------------------- System Info --------------------
      2012-01-10 05:02:37,296 - [1] 7765 INFO : CPU: Intel(R) Atom(TM) CPU N280 @ 1.66GHz at 1662 Mhz with 2 cores (x86 Family 6 Model 28 Stepping 2)
      2012-01-10 05:02:37,296 - [1] 7765 INFO : OS : Microsoft Windows XP Home Edition (Microsoft Windows NT 5.1.2600 Service Pack 3)
      2012-01-10 05:02:37,296 - [1] 7765 INFO : RAM: 1.99GB
      2012-01-10 05:02:37,296 - [1] 7765 INFO : Culture info: en-US
      2012-01-10 05:03:33,703 - [1] 64171 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 387
      - Routine: InitPostgres
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2012-01-10 05:03:33,937 - [1] 64406 ERROR: Exception caught in Boolean PBN.Database.PostgreSQL.InitializeConnection(System.String ByRef)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: FATAL: 3D000: database "elephantdb" does not exist
      - Severity: FATAL
      - Code: 3D000
      - BaseMessage: database "elephantdb" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\utils\init\postinit.c
      - Line: 387
      - Routine: InitPostgres
      - ErrorSql:
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null><none>
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum)
      at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context)
      at Npgsql.NpgsqlConnector.Open()
      at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection)
      at Npgsql.NpgsqlConnection.Open()
      at PBN.Database.PostgreSQL.InitializeConnection(String& in_sBinPath)
      2012-01-10 05:03:38,984 - [1] 69453 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.2299758(00:00:00.0086804/00:00:00.0002793)
      2012-01-10 05:03:49,359 - [1] 79828 WARN : Cannot find the version table - will export schema now.
      -------------------- PS.Common.Database.DatabaseException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Void CallDatabase(System.Action)
      - HelpLink: <null>
      - Source: PS.Common.Database
      - InnerException: NHibernate.ADOException<none>
      - StackTrace:
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      at PS.Database.nHibernate.Repositories.VersionHistoryRepository.GetHighestVersion()
      at PSE.Database.Controller.ElephantDatabaseController.TryUpdateDatabase()
      -------------------- NHibernate.ADOException --------------------
      - Message: could not execute query
      [ SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0 ]
      [SQL: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0]
      - SqlString: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit :p0
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: System.Collections.IList DoList(NHibernate.Engine.ISessionImplementor, NHibernate.Engine.QueryParameters)
      - HelpLink: <null>
      - Source: NHibernate
      - InnerException: Npgsql.NpgsqlException<none>
      - StackTrace:
      at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters)
      at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes)
      at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results)
      at NHibernate.Impl.CriteriaImpl.List(IList results)
      at NHibernate.Impl.CriteriaImpl.List[T]()
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetElementList(MethodCallExpression call, Int32 count)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.HandleFirstCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.VisitMethodCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.ImmediateResultsVisitor`1.GetResults(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.RootVisitor.HandleImmediateResultsCall(MethodCallExpression call)
      at NHibernate.Linq.Visitors.RootVisitor.VisitMethodCall(MethodCallExpression expr)
      at NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateExpressionVisitor.Visit(Expression exp)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.TranslateInternal(Expression expression)
      at NHibernate.Linq.Visitors.NHibernateQueryTranslator.Translate(Expression expression, QueryOptions queryOptions)
      at NHibernate.Linq.NHibernateQueryProvider.TranslateExpression(Expression expression)
      at NHibernate.Linq.NHibernateQueryProvider.Execute(Expression expression)
      at NHibernate.Linq.QueryProvider.System.Linq.IQueryProvider.Execute[T](Expression expression)
      at System.Linq.Queryable.First[TSource](IQueryable`1 source)
      at PS.Database.nHibernate.Repositories.VersionHistoryRepository.<>c__DisplayClass4.<GetHighestVersion>b__3()
      at PS.Common.Database.Controller.DatabaseWorker.CallDatabase(Action databaseAction)
      -------------------- Npgsql.NpgsqlException --------------------
      - Message: ERROR: 42P01: relation "pse_versionhistory" does not exist
      - Severity: ERROR
      - Code: 42P01
      - BaseMessage: relation "pse_versionhistory" does not exist
      - Detail:
      - Hint:
      - Position:
      - Where:
      - File: .\src\backend\catalog\namespace.c
      - Line: 273
      - Routine: RangeVarGetRelid
      - ErrorSql: SELECT this_.InstallDate as InstallD1_16_0_, this_.Version as Version16_0_ FROM PSE_VersionHistory this_ ORDER BY this_.Version desc limit ((1)::int4)
      - Errors: System.Collections.ArrayList
      - ErrorCode: -2147467259
      - Data: System.Collections.ListDictionaryInternal
      - TargetSite: Boolean MoveNext()
      - HelpLink: <null>
      - Source: Npgsql
      - InnerException: <null>1 items
      actual-sql-query - actual-sql-query
      - StackTrace:
      at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
      at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject()
      at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
      at Npgsql.ForwardsOnlyDataReader.NextResult()
      at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
      at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
      at Npgsql.NpgsqlCommand.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)
      2012-01-10 05:03:51,984 - [1] 82453 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2012-01-10 05:03:52,000 - [1] 82468 INFO : MainForm.UseDatabase took 00:00:13.4167716
      2012-01-10 05:03:57,000 - [1] 87468 INFO : MainForm.Init - before LoadSettings - 00:00:00.0003682
      2012-01-10 05:04:00,687 - [1] 91156 INFO : MainForm.Init - before StartPatchDatabase - 00:00:03.6835648
      2012-01-10 05:04:00,765 - [1] 91234 INFO : MainForm.Init - before UseDatabase - 00:00:03.7705146
      2012-01-10 05:04:00,953 - [1] 91421 INFO : Poker.PlayerCache.PlayerCacheLineCollection PokerStrategyElephant.Database.Caching.GetCache(System.String) took 00:00:00.0806275(00:00:00.0007917/00:00:00.0000036)
      2012-01-10 05:04:01,015 - [1] 91484 INFO : Installed PostgreSQL version: PostgreSQL 8.3.0, compiled by Visual C++ build 1400
      2012-01-10 05:04:01,015 - [1] 91484 INFO : MainForm.UseDatabase took 00:00:00.2414273
      2012-01-10 05:04:01,015 - [1] 91484 INFO : MainForm.Init - before InitTables - 00:00:04.0131203
      2012-01-10 05:04:01,015 - [1] 91484 INFO : MainForm.Init - before ReadPortalDesc - 00:00:04.0144174
      2012-01-10 05:04:02,562 - [1] 93031 INFO : MainForm.Init - before GenerateExistingPortalsAndPlayersList - 00:00:05.5583994
      2012-01-10 05:04:02,687 - [1] 93156 INFO : MainForm.Init took 00:00:05.6814198
      2012-01-10 05:04:04,015 - [1] 94484 INFO : MainForm._Loaded took 00:00:01.0737445
      2012-01-10 05:04:04,234 - [1] 94703 INFO : Starting background version check...
      2012-01-10 05:04:10,828 - [10] 101296 INFO : Background version check finished.
      Latest Version: 0.102.40520.2
      NewVersionAvail: False
      IgnoreUpdateVersion:

      2012-01-10 05:14:17,812 - [1] 708281 INFO : Initializing shutdown (shutting down controllers).
      2012-01-10 05:14:18,703 - [1] 709171 INFO : Finalising shutdown.
  • 22 replies
    • Silicernium
      Silicernium
      Bronze
      Joined: 22.12.2009 Posts: 3,203
      Hallo!

      If I understand it right, it is not necessary to do something. You can use the elephant also with this message.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      I need help since elephant cannot use the imported files to do anything because it thinks that the PostGresSQL is not updated. And imported files have content match error.

      I need a solution so I could use the software to at least read the files.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      I need help because elephant can't read my party poker hands database due to the problems stated above.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      Hi can anyone help me?
    • Silicernium
      Silicernium
      Bronze
      Joined: 22.12.2009 Posts: 3,203
      Originally posted by jetocumen
      Hi can anyone help me?
      Come on, it is not necessary to push your thread 3 times!! If anyone knows anything, he will helps you.

      And Freerolls are not supportet.

      Postgre is running?
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      I'm sorry i just felt like i did'nt communacate my question correctly. I have been playing Cash games but it still says that the content failed match. Yes postgres is running i have tried to install 8 version with .105 elephant also tried the latest version from postgres website but it still says that the database is outdated whenever I start elephant. I also tried to install elephant .106 but nothing changed.

      I'm starting out and just really excited to start using the software and maximize the free trial days.
    • Silicernium
      Silicernium
      Bronze
      Joined: 22.12.2009 Posts: 3,203
      OK, let us do it slowly, maybe we can find the fault. :)

      The message "Outdated Database Format" is not important and you can go ahead.

      If you start your elephant and open a table at Partypoker, does the elephant import the hands?

      Or do you want to import other HHs?
    • mrk1988
      mrk1988
      Bronze
      Joined: 04.02.2007 Posts: 13,337
      Alright - as Silicernium suggested - let's roll this up.

      Create a new database via databasemanagement.

      Open up the configuration page and press "Rescan".

      Try adding autoimport folders manually in case your hand history folders are not recognized automatically.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      @ Silicernium > Yes elephant imports the data when I play.

      @ mrk1988 > I tried it, but it didn't work. Same error, the files are imported but when you look at the file there is still a content failed match error.
    • WpgJets
      WpgJets
      Bronze
      Joined: 13.12.2011 Posts: 34
      I have the same problem. Could it be because I have a newer verison i.e., 9.1 (the opposite of an outdated version) of postgre installed than the 8.X that I think Elephant wanted to use? I'm also using Windows 7, 64 bit version.
    • mrk1988
      mrk1988
      Bronze
      Joined: 04.02.2007 Posts: 13,337
      No, your postgreSQL version does not matter.

      @jetocumen; Your PartyPoker hand history is saved in english? (I'm not aware that it's possible to change this, but maybe you are not playing on a regional client or something like that?)
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      Yes. My party poker hand history is saved in english, what do you mean by regional client?
    • Silicernium
      Silicernium
      Bronze
      Joined: 22.12.2009 Posts: 3,203
      Originally posted by jetocumen
      Yes. My party poker hand history is saved in english, what do you mean by regional client?
      I think he means cou do not play on partypoker.dk for example.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      I just play i partypoker.com, I have seen threads where thwy advised the player to adjust the regional setting to EST in PostgresSQL. I tried to find out how to do it but it is not a normal click and select setting. Every command must be written, does anyone know how to adjust the time, language and regiomnin pOstgres this might be the solution?
    • mrk1988
      mrk1988
      Bronze
      Joined: 04.02.2007 Posts: 13,337
      This shouldn't not be a language / time issue.

      As long as your hand history language is set to english you should be fine.

      Please post one of the hands that's not imported properly. (content failed to match)
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      Originally posted by mrk1988
      This shouldn't not be a language / time issue.

      As long as your hand history language is set to english you should be fine.

      Please post one of the hands that's not imported properly. (content failed to match)
      Here is a sample hand. I'm sure its in English though.

      Game #11300001001 starts.

      #Game No : 11300001001
      ***** Hand History for Game 11300001001 *****
      $2 USD NL Texas Hold'em - Friday, January 13, 01:09:27 CT 2012
      Table Table 201217 (No DP) (Real Money)
      Seat 9 is the button
      Total number of players : 9/9
      Seat 7: AKamm609 ( $2 USD )
      Seat 6: ChPiP ( $1.75 USD )
      Seat 3: Cottofott ( $2.01 USD )
      Seat 5: Kettwurst ( $1.73 USD )
      Seat 9: emefece ( $1.34 USD )
      Seat 2: jetocumen ( $2 USD )
      Seat 4: tomeczek1910 ( $3.83 USD )
      Seat 1: wowka10 ( $2 USD )
      Seat 8: zironka501 ( $1.26 USD )
      wowka10 posts small blind [$0.01 USD].
      jetocumen posts big blind [$0.02 USD].
      ** Dealing down cards **
      Dealt to jetocumen [ 4d 8d ]
      tomeczek1910 raises [$0.08 USD]
      Kettwurst folds
      ChPiP folds
      AKamm609 folds
      zironka501 folds
      emefece folds
      wowka10 folds
      jetocumen calls [$0.06 USD]
      ** Dealing Flop ** [ 7d, 9s, 7h ]
      jetocumen checks
      tomeczek1910 bets [$0.12 USD]
      jetocumen folds
      tomeczek1910 does not show cards.
      tomeczek1910 wins $0.29 USD
      Kettwurst has left the table.
    • mrk1988
      mrk1988
      Bronze
      Joined: 04.02.2007 Posts: 13,337
      Hey,

      I can import this hand just fine. Please update to version 0.106 from here: http://elephant.pokerstrategy.com and try it again.
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      Originally posted by mrk1988
      Hey,

      I can import this hand just fine. Please update to version 0.106 from here: http://elephant.pokerstrategy.com and try it again.
      Hi mrk198 I already upgraded to that version and I still have the same problem. I also noticed that the imported hands no duration. Does this info help?
    • jetocumen
      jetocumen
      Bronze
      Joined: 26.12.2011 Posts: 48
      Hi any news on this problem? I still can't find a solution although there is one session that was uploaded in the elephant all others are still not loading well.
    • 1
    • 2