problems with cache
Posted:
Fri Mar 06, 2009 3:50 pm
by ab1183
First thing I need to say is that I am a 100% idiot when it comes to this stuff. Please speak slowly for me lol. I have been trying to create a database cache with PAHUD for a few days now and I can not get it to work. My PT2 database got so big that I couldnt impot anymore, and I had to use SQL or whatever. That alone took 3 days to install. Now I dont know if that is even done correctly, but it at least imports my HHs and stuff. Whenever I try to create the database cache I get an error that says "Error executing "SELECT gp.player_id, g.game_level_id, g.number_of_players,...." etc. What am I doing wrong? Thanks in advance for any responses.
Re: problems with cache
Posted:
Fri Mar 06, 2009 3:54 pm
by kraada
What version of PostgreSQL are you using: 8.2 or 8.3?
Re: problems with cache
Posted:
Fri Mar 06, 2009 4:56 pm
by kraada
PAHUD's cache creation requires PostgreSQL 8.2, it won't work with 8.3 which is what's causing your issue.
Re: problems with cache
Posted:
Fri Mar 06, 2009 5:03 pm
by ab1183
kraada wrote:PAHUD's cache creation requires PostgreSQL 8.2, it won't work with 8.3 which is what's causing your issue.
Ok, where can I get 8.2? What will I need to do with my DB now? Will it need to be converted or changed in some way?
Re: problems with cache
Posted:
Sat Mar 07, 2009 11:12 am
by kraada
You'll need to backup your database and restore it in 8.2, as there isn't a more simple conversion method. You can find PostgreSQL 8.2
here.