3. Database Critical error

Database Critical error

  • H

    Hello,

    While cleaning my C: disk to make more room, i accidentally deleted the content of C:\Users\YourUsername\AppData\Roaming\Hand2Note\h2ndb\base.

    After that i am not able to open H2N cause i am receiving following error...

    System.InvalidOperationException: Failed to open database connection. Please, check your PostgreSQL database settings and reboot your computer. ---> Npgsql.PostgresException: 3D000: database "postgres" does not exist
    at Npgsql.NpgsqlConnector.<DoReadMessage>d__148.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult()
    at Npgsql.NpgsqlConnector.<Open>d__136.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.ConnectorPool.<AllocateLong>d__24.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnection.<Open>d__28.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Npgsql.NpgsqlConnection.Open() at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName) --- End of inner exception stack trace --- at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName) at Common.ConnectionExtensions.Open(ServerConnection sc) at Common.PgDatabaseHelper.DatabaseExists(String databaseName, ServerConnection sc) at Hand2NoteCore.Loader.<>c.<LoadAsync>b__1_0() at System.Threading.Tasks.Task1.InnerInvoke()
    at System.Threading.Tasks.Task.Execute()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Hand2NoteCore.Loader.<LoadAsync>d__1.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Hand2Note.App.<LoadAsync>d__4.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
    at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
    Inner exception
    Npgsql.PostgresException (0x80004005): 3D000: database "postgres" does not exist
    at Npgsql.NpgsqlConnector.<DoReadMessage>d__148.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Npgsql.NpgsqlConnector.<ReadMessage>d__147.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.ValueTaskAwaiter1.GetResult()
    at Npgsql.NpgsqlConnector.<Open>d__136.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.ConnectorPool.<AllocateLong>d__24.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult()
    at Npgsql.NpgsqlConnection.<Open>d__28.MoveNext()
    --- End of stack trace from previous location where exception was thrown ---
    at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
    at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
    at Npgsql.NpgsqlConnection.Open()
    at Common.ConnectionExtensions.Open(ServerConnection sc, String dbName)

    How can i fix it? Please help me out with that!

    Thank you

    0

  • keepcalm GLOBAL MODERATOR 23 Apr 2018, 15:11

    Please try to remove the file DbServer.cg that is located in the folder C:\Program Files\Hand2Note\ by default.

    GT-HUD for Hand2Note
    https://progt-pack.com
    alt text
    DYNAMIC HUD (video-preview)
    New Simple HUD (video-preview)
    POPUPs GT-HUD (video-preview)
    SpinFire HUD (video-preview)
    MTT-SNG Pack (video-preview)
    Shaolin HUD for PM
    Available test period for SpinFire HUD/Shaolin HUD
    Contact us:
    Skype: gt-pack
    E-mail: support@progt-pack.com

    0
  • H

    Deleted it but unfortunitely it did not fix the problem. Still getting the same error :(

    0
  • K
    Global Moderator

    In this case, try to proceed with full reinstallation:

    1. Check that you have installed all latest updates for Windows

    2. Remove your database. By default, it is located in the next folder:
      C:\Users\ <YourUsername>\AppData\Roaming\Hand2Note\h2ndb

    3. If you need to save your settings, copy Config and Notes folders in a safe place before uninstalling Hand2Note:
      FAQ. Moving Config

    4. Uninstall Hand2Note. After the uninstallation has finished please delete all files from the install directory (default folder is located in C:\Program Files\Hand2Note).

    5. Install the latest version of Hand2Note for PokerMaster:

    http://hand2note.com/

    1. Register your license key in Configuration->Other Options->License

    Then, run Hand2Note in the default configuration and check whether the issue persists.

    0
Log in to reply
 

Looks like your connection to Hand2Note was lost, please wait while we try to reconnect.