PT Freezes when trying to repair database

[lemonhead77]

Hi,I have been trying to repair my database in the utilities section. Im doing this in response to the link you sent me the other day regarding messages popping up when using PT. when i trey to repair the database,my cursor changes to an egg timer and it saysdown the bottom of PT that it is making a back up of files but it just freezes. When i try to click on anything the border up the ttop of PT turns white and it says "not Responding"

Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
No changes made to database.
INSERT INTO hand_histories ( game_number, site_id, hand_history, import_date ) VALUES (

[ptrack pat]

It's not frozen, you need to let it run, if the db is large then it takes a while to do the repair and if you are killing the program then you risk corrupting the database.

[lemonhead77]

hi Pat,i tried this again. I closed all other applications and opened PT. Selected utilities and then repair database. I then left the computer for an hour while it said making back up of database etc. When i came back the whole screen was white and said up the top"not responding". What else can i do to try repair this???

[WhiteRider]

Let it finish.
As Pat said, it will take a long time.

[lemonhead77]

How long is a long time its size is around 305MB

[WhiteRider]

That really depends on your PC.
I'm not familiar with database repair, so I don't know what sort of work it's doing, but something like compacting a large database can take a few hours on my old-ish PC.

[ptrack pat]

The repair is being done by calling a Windows API, it's not PT doing it so I can't give you a time it would take all I know is you need to let it run. I can't believe a file of only 300MB would take that long to repair unless it may be corrupted.