PDA

View Full Version : Error 42P01



ice_w0lf
11-14-2010, 11:14 AM
I started getting this error this morning while using 1.11.05a.... I was trying to filter my tournaments....

http://img832.imageshack.us/img832/7985/errorrx.jpg

Started looking around the forum and noticed there was a new beta version available.. so I downloaded and installed that. Same problem, whenever I click anything on the left other than Import.. I get the error. So I uninstalled/reinstalled both postgres and hem (in that order.. uninstalled both, then reinstalled both) and still get the error. After clicking ok on the error.. I get this popup:


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 do.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.4206 (VistaSP2GDR.050727-4200)
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.11.4.2806
Win32 Version: 1.11.04.2806
CodeBase: file:///C:/Program%20Files%20(x86)/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.4016 (NetFxQFE.050727-4000)
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------

Help :)

ice_w0lf
11-14-2010, 11:30 AM
I started searching around google for this problem.. and came across a similar problem on the old hem forum on 2+2.. and found fozzy's reply... the guy came to the problem a different way.. but had the same error:


Something was damaged when performing maintenance. Was this the first time (ever) performing maintenance on this database? If you perform regular maintenance the chances of it damaging your database is slim to none, but if you have been using the database for a long time and never performed those steps, the first time can sometimes ruin your database.

You could try performing a general Reindex of the database from the PGAdmin Maintenance menu. but if that doesn't work you will need to create a new database.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - FAQ - Hold'em Manager Poker Tracking Software :: Reinstalling on a new PC - Backup Tips (http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips)

I tried this and it did not work.

ice_w0lf
11-14-2010, 12:49 PM
Was able to uninstall/reinstall everything again.. and it seems to be working at the moment.