PDA

View Full Version : ERROR: 42P01 / No Backup or Export possible



NoCluBoutCPU
01-31-2011, 06:08 PM
Hi!

I'm using XP Home SP3 / HM release 1.11.05e. / PostgreSQL 8.3.

Avira Antivir recently found a trojan horse in my HM folder (after reading i think a false positive notice) which I deleted without further thinking about. Since then I can't access anything in cash game related in my database always getting the mentioned error ("ERROR: 42P01: missing FROM-clause entry from table "td""). Strangely the tourney part works absolutely fine, HUD and importing as well.

Today I wanted to either Backup my files or at least export my hands to reinstall HM hoping the error would be gone then. Well, the B&R Wizard tells me "could not find PostgreSQL installation directory" and stops immediately while clicking on export in the database management brings "currently you can only export hands from a Holdem Manager database".

All these popup messages just cause my "WTF-Face" as they don't even seem to be logical. So that's it, HM appears to be f***ed and as of now it seems that I can't even save my stuff. Or become a MTT/SNG pro...

HELP please!
------------
After closing the error box I receive another box talking about an "unhandled exception in my application" providing this details:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at dp.a(Object A_0, RunWorkerCompletedEventArgs A_1)
at System.ComponentModel.BackgroundWorker.OnRunWorker Completed(RunWorkerCompletedEventArgs e)
at System.ComponentModel.BackgroundWorker.AsyncOperat ionCompleted(Object arg)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3615 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.11.5.3160
Win32 Version: 1.11.05.3160
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3614 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 8.3.0.0
Win32 Version: 8.3.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.2.2000.0
Win32 Version: 3.2.2000.3813
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3618 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
WindowsFormsIntegration
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.1427 built by: SP
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/WindowsFormsIntegration/3.0.0.0__31bf3856ad364e35/WindowsFormsIntegration.dll
----------------------------------------
PresentationCore
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: GDR
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/PresentationCore/3.0.0.0__31bf3856ad364e35/PresentationCore.dll
----------------------------------------
WindowsBase
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: GDR
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.13.0
Win32 Version: 2.0.13.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.17
Win32 Version: 1.0.0.17
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 2.0.6.0
Win32 Version: 2.0.6.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/Mono.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.1.4.31904
Win32 Version: 5.1.4.31904
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/ZedGraph.DLL
----------------------------------------
PresentationFramework
Assembly Version: 3.0.0.0
Win32 Version: 3.0.6920.4016 built by: GDR
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/PresentationFramework/3.0.0.0__31bf3856ad364e35/PresentationFramework.dll
----------------------------------------
SitNGoWizard.1.1
Assembly Version: 1.0.2.19
Win32 Version: 1.0.2.019
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/SitNGoWizard.1.1.EXE
----------------------------------------
SitNGoWizard.Localization.2.0
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/SitNGoWizard.Localization.2.0.DLL
----------------------------------------
log4net
Assembly Version: 1.2.10.0
Win32 Version: 1.2.10.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/log4net.DLL
----------------------------------------
HoldemVision
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/HoldemVision.DLL
----------------------------------------
LeakBuster2.5
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/LeakBuster2.5.DLL
----------------------------------------
LeakBuster2.5 Limit
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/LeakBuster2.5%20Limit.DLL
----------------------------------------
HEMGUI
Assembly Version: 1.0.9.163
Win32 Version: 1.0.9.163
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/HEMGUI.DLL
----------------------------------------
Acid Library
Assembly Version: 1.3.2734.23020
Win32 Version: 1.3.2734.23020
CodeBase: file:///C:/Programme/RVG%20Software/Holdem%20Manager/Acid%20Library.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

NoCluBoutCPU
01-31-2011, 07:39 PM
Looked around on the forum....found/installed the 1.11.06_Internal, created a new DB, reimported some test hands > not working

Patvs
01-31-2011, 11:20 PM
The Backup & Restore wizard currently only supports SQL 8.4
Try updating your SQL from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

NoCluBoutCPU
02-26-2011, 05:38 PM
That PostgrSQL website is a nightmare when your name is "NoCluBoutCPU"...how about a link to some FAQ on how to do this upgrade without messing something up?!?

netsrak
02-27-2011, 08:15 AM
Postgresql is not the reason for your problem.
I think there is something wrong with your reports.

Please overwrite the files in your reports subfolder with the contents of this zip archive: http://www.holdemmanager.com/downloads/Reports.zip

If that doesn't help you need to uninstall and reinstall the full holdemmanager installer without postgresql (make sure that its unchecked during the installation) but start with a fresh configuration.