View Full Version : Can't access DB after restore: Error 42P07

12-11-2009, 11:17 AM
I ran out of disk space on my laptop so I backed up my DB to an external HD.

I restored it seemingly successfully, but when I try to run HM, I get the error

An error occurred while updating your DB
(Tourney Number): ERROR: 42P07: relation
"optimizedplayers" already exists

Please close down any programs accessing
the database and relaunch Holdem manager.



12-11-2009, 01:44 PM
I have forwarded this thread to the developer for a reply.

12-11-2009, 01:48 PM
Quote from the developer:

It happens because part of his DB was updated and part wasn’t due to the disk space issues. He could try deleting the optimizedplayers table and then it should continue and recreate it