本网站使用Cookie来改善您的浏览体验。继续浏览本网站即表示您接受这种Cookie功能。欲了解详情或更改您的设置,请访问Cookie政策隐私政策页面。关闭

PT3问题

    • RedMoon5
      RedMoon5
      铜牌
      从: 2012.05.22 帖子: 226
      玩大发的6人桌本来正常使用中,突然只显示2个人的HUD,而且不再更新HUD了,一直显示出问题前的数据。
      然后看到PT3软件下面的ImportStatus窗口里一直出:
      iPoker: Unable to import hand (#3450361694). Reason: Unable to execute query: COPY holdem_hand_player_statistics FROM STDIN;; Reason: Fatal Error (ERROR: invalid page header in block 523 of relation base/16395/16418 CONTEXT: COPY holdem_hand_player_statistics, line 1:

      好像是什么文件错了,不知怎么办
      重新启动电脑,上大发换其他桌玩,也只显示几个玩家的数据并且不更新。仍然显示上面的错误。

      求帮忙
  • 6 回复
    • RedMoon5
      RedMoon5
      铜牌
      从: 2012.05.22 帖子: 226
      不行我就重新安装吧
    • xxiaoping
      xxiaoping
      铜牌
      从: 2009.11.22 帖子: 1.413
      一般情况遇到这种不知名的错误,我一般建议重装PT3 和SQL。你看看行不。

      另外我已经发信个PT3 查询这个情况了,有消息回复你
    • RedMoon5
      RedMoon5
      铜牌
      从: 2012.05.22 帖子: 226
      多谢版主
      已经连操作系统带扑克室软件都重装了,只是牌局记录都没了很可惜,现在都OK了
    • xxiaoping
      xxiaoping
      铜牌
      从: 2009.11.22 帖子: 1.413
      强烈建议保持原始牌局,这样 无论SQL出问题还是系统出问题,都能简单的处理。用SQL备份很烦人感觉。
    • xxiaoping
      xxiaoping
      铜牌
      从: 2009.11.22 帖子: 1.413
      原作: RedMoon5
      多谢版主
      已经连操作系统带扑克室软件都重装了,只是牌局记录都没了很可惜,现在都OK了
      Hello,

      Thank you for contacting PokerTracker Support. The error that you are experiencing is due to a corrupted database which is typically caused by crashes or faulty hardware.

      The first thing to try is to run housekeeping (Database -> Database Management -> Housekeeping) and choose "Reindex". Please see if doing so resolves the problem.

      If it doesn't you can try to configure PostgreSQL to ignore this error and remove the bad data.

      Browse to "C:\Program Files\PostgreSQL\8.x\data" and right-click the file called "postgresql.conf" and choose "Run as administrator".

      At the very bottom of this file add the following line:

      zero_damaged_pages = on

      Save the file (File->Save) and then go Start->Programs->PostgreSQL->Reload Configurations or restart your computer to reload the configuration.

      This should resolve your issue. After the error has been resolved, it is recommended that you go back into your PostgreSQL config file and remove the line that you just added.

      If you're still experiencing the same problems, please make sure that logging is enabled (Configure -> Options -> "Enable logging" should be ticked), reproduce the problem and attach the "PokerTracker4" log file (text document) located in your PT4 user folder to this ticket. You can find the file by going File -> "Open User Data Folder" in PT4. Please also attach your five latest PostgreSQL log files available in your C:/Program Files/PostgreSQL/8.x/data/pg_log folder.

      Best Regards,
      David Nilsson


      以上是扑克室的回复。大概意思是同学的SQL出问题了,看起来也很麻烦的样子,既然同学定了就好。希望手气长虹哈哈~
    • allentry
      allentry
      铜牌
      从: 2011.12.29 帖子: 200
      我也遇到过类似的问题,hud不显示,在PT3官网论坛上还问了的,也是像BZ那样的类似的解释Database -> Database Management -> Housekeeping) and choose "Reindex".
      Reindex反正就那里的3个选项都试了一下,然后就好了!
      看来我来晚了!!