Outdated Database Format/Error Content Failed Match

Joined: 26.12.2011

10.01.2012, 20:26 0

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.

Reply

Quote

22 replies

_Anonymous_

10.01.2012, 20:43 0

Hallo!

If I understand it right, it is not necessary to do something. You can use the elephant also with this message.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

11.01.2012, 00:19 0

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.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

11.01.2012, 00:56 0

I need help because elephant can't read my party poker hands database due to the problems stated above.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

11.01.2012, 11:53 0

Hi can anyone help me?

Reply

Quote

_Anonymous_

11.01.2012, 11:58 0

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?

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

12.01.2012, 17:47 0

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.

Reply

Quote

_Anonymous_

12.01.2012, 20:09 0

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?

Reply

Quote

mrk1988

Joined: 04.02.2007

Posts: 1,614

13.01.2012, 22:30 0

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.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

14.01.2012, 06:45 0

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

Reply

Quote

WpgJets

Joined: 13.12.2011

Posts: 34

15.01.2012, 19:46 0

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.

Reply

Quote

mrk1988

Joined: 04.02.2007

Posts: 1,614

16.01.2012, 08:04 0

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?)

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

16.01.2012, 17:45 0

Yes. My party poker hand history is saved in english, what do you mean by regional client?

Reply

Quote

_Anonymous_

17.01.2012, 09:08 0

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.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

17.01.2012, 19:22 0

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?

Reply

Quote

mrk1988

Joined: 04.02.2007

Posts: 1,614

18.01.2012, 11:32 0

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)

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

21.01.2012, 06:11 0

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.

Reply

Quote

mrk1988

Joined: 04.02.2007

Posts: 1,614

23.01.2012, 15:59 0

Hey,

I can import this hand just fine. Please update to version 0.106 from here: http://elephant.pokerstrategy.com and try it again.

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

24.01.2012, 02:13 0

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?

Reply

Quote

jetocumen

Joined: 26.12.2011

Posts: 48

11.02.2012, 15:51 0

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.

Reply

Quote