j1nx
09-30-2008, 06:30 PM
Hi, I read about a lot of database problems lately and offcourse today it happend to me as well.
Just closed HM the normal way, import was still running though but I clicked the OK button to stop it for me. Then i forgot to save my graph so started HM again. To my suprise; everything was empty????? No reports, no sessions, no graphs, nothing.
So I updated to the latest beta version to see if that worked. Started HM, no license found?? Had to go through the whole registering procedure, but I can live with that. Still everything is empty except the session tab. No reports, no graphs what so ever.
The log file looks like this;
The Error: ERROR: 42P01: relation "allinsituations" does not exist
Occurred when running ExecuteNonQuery with this query: Select PlayerHand_ID from allinsituations limit 1
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 42P01: table "temppurge" does not exist
Occurred when running ExecuteNonQuery with this query: DROP TABLE temppurge
The Error: ERROR: 42703: column "icon_id" does not exist
Occurred when running ExecuteNonQuery with this query: Select icon_id from hemplayernotes limit 1
This is annoying and I think nobody can deny the increased corrupted databases lately. I really think something is seriously wrong in the last couple of versions. I'm a way above avarage coputer user, so I know my way around. This happened without doing anything wrong what so ever.
EDIT: Oh and "$0.02/0.04 NL" is NOT an integer! So I seriously hope this integer thing isn't talking about the string "$0.02/0.04 NL"
Just closed HM the normal way, import was still running though but I clicked the OK button to stop it for me. Then i forgot to save my graph so started HM again. To my suprise; everything was empty????? No reports, no sessions, no graphs, nothing.
So I updated to the latest beta version to see if that worked. Started HM, no license found?? Had to go through the whole registering procedure, but I can live with that. Still everything is empty except the session tab. No reports, no graphs what so ever.
The log file looks like this;
The Error: ERROR: 42P01: relation "allinsituations" does not exist
Occurred when running ExecuteNonQuery with this query: Select PlayerHand_ID from allinsituations limit 1
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.01/0.02 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.01/0.02 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 03' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 22P02: invalid input syntax for integer: "$0.02/0.04 NL"
Occurred when running GetDataTable with this query: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.S treetWentAllin,PH.HandTimeStamp,GT.GameTypeDescrip tion,PH.holecard1int,PH.holecard2int,PKH.FlopCard1 int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCard int,PKH.RiverCardint,PH.flopplayerActionType_ID,PH .turnplayerActionType_ID,PH.riverplayerActionType_ ID,PH.NetAmountWon,GT.BigBlind,PH.PositionType_ID, PH.preflopaction_id,PH.didpfr,PH.didvpip,EV.Sklans kyBucks,EV.EquityPct from playerhandscashkeycolumns ph join pokerhands pkh on ph.pokerhand_id = pkh.pokerhand_id left join allinsituations ev on ph.playerhand_id = ev.playerhand_id join players pl on (pl.player_id = ph.player_id) join gametypes gt on gt.gametype_id = ph.gametype_id where (ph.player_id = 4) and (ph.gametype_id = 1 or ph.gametype_id = 11 or ph.gametype_id = 12 or ph.gametype_id = 13) and ph.numberofplayers <'7' and GT.GameTypeDescription = '2008 04' and GT.BigBlind = '$0.02/0.04 NL' order by PH.HandTimeStamp desc limit 100
The Error: ERROR: 42P01: table "temppurge" does not exist
Occurred when running ExecuteNonQuery with this query: DROP TABLE temppurge
The Error: ERROR: 42703: column "icon_id" does not exist
Occurred when running ExecuteNonQuery with this query: Select icon_id from hemplayernotes limit 1
This is annoying and I think nobody can deny the increased corrupted databases lately. I really think something is seriously wrong in the last couple of versions. I'm a way above avarage coputer user, so I know my way around. This happened without doing anything wrong what so ever.
EDIT: Oh and "$0.02/0.04 NL" is NOT an integer! So I seriously hope this integer thing isn't talking about the string "$0.02/0.04 NL"