Unable to execute query

[Treizee]

today i have made some register clean of my broken .dll files and deleted some of them with CGcleaner and since then my PT4 isnt working i get this error

[ img ]

Uploaded with ImageShack.us

[WhiteRider]

You could try re-running the PT3 installer in case any of the PT3 files were removed, but that looks as if one or more of the files which make up your database may have been removed.
Are you able to roll-back the changes to see if that recovers your database?

You could try running Database > Housekeeping with the ReIndex option, or doing the following:
You can set PostgreSQL to ignore errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.
However, if there is a file missing from your database then I wouldn't expect either of these to help.
In that case you may need to recover from a backup, or create a new database and re-import your hands.

[Treizee]

i did an update of my PT4 and this didnt help and i cant even make update of databese i get another error
i am not able to rollback changes since i didnt make any backup :/

where can i find housekeeping in PT4?
i set SQL to ignore errors but didnt help

but it looks like my PT4 is running fine because it shows me my hands which i played today but when i set it to show me hands from yesterday i get this error

[kraada]

You can find Housekeeping in PT4 by clicking the Database menu item at the top of the screen, and then Database Management. Housekeeping is the second button from the right on the bottom row. Click on it and run Reindex and that will likely help.

[Treizee]

hosuekeeping doesnt work i get another error :/ unable to execute query

[kraada]

Then set PostgreSQL to ignore errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Make sure there is NOT a # in front of the line. After you save and close the file restart your computer and then try again.

[Treizee]

didnt work :(

but it looks like something is wrong with my SQL from what i found out to me it looks like previous hands are blocked and i dont have rights to load them

[kraada]

Please report this problem and we'll investigate further and help you get everything set up again properly.