restored DB, hands listed as 3 hours earlier

Any support related posts should go here.

restored DB, hands listed as 3 hours earlier

Postby themightyjim2k » Wed Mar 12, 2008 12:29 am

So I just got a new latptop and installed PT. I restored my backed up DB from my desktop so that I would have stats on my opponents on my laptop. In the process I noticed a few weird changes in my numbers from my desktop to my laptop. A little further study showed that my laptop (restored DB) is listing my sessions as 3 hours earlier than they actually occurred. So things that happened 12:01 AM on March 1st are actually being listed as 9:01 PM on Feb 29th. And this seems fairly consistent for all of the sessions.

Any way I can fix this? Obviously I can just set the preferences for 3 hours difference, and I get the same numbers on both PCs. But it would be much easier to make sure I am getting all of my hands transferred back and forth if I could more easily compare databases without having to worry about that little glitch.
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am

Re: restored DB, hands listed as 3 hours earlier

Postby ptrack pat » Wed Mar 12, 2008 9:27 am

This is a PostgreSQL database you restored?? What version of PostgreSQL did you put on the new computer? Was it 8.2? PT would not have changed any dates in the database so this is some PostgreSQL issue that I'm not aware of.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: restored DB, hands listed as 3 hours earlier

Postby themightyjim2k » Wed Mar 12, 2008 11:22 am

[quote="ptrack pat"gez]This is a PostgreSQL database you restored?? What version of PostgreSQL did you put on the new computer? Was it 8.2? PT would not have changed any dates in the database so this is some PostgreSQL issue that I'm not aware of.[/quotegez]

pretty sure it was 8.2. I followed the links from the old PTH forum, and several of those threads mentioned that we should use 8.2 instead of 8.3 because of some compatibility issues.

I'll recheck this afternoon, and if I notice something different I'll post it.

thanks,

jim
themightyjim2k
 
Posts: 73
Joined: Mon Mar 10, 2008 11:14 am


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 0 guests