PDA

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



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

Suggestions?

TIA

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

fozzy71
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