danke für Tip 2
wie ich bereits erwähnte habe ich leider keine Ahnung, ich bin bloß ein blöder user.
Ich weiß nicht warum du so agressiv rüber kommst?
Wenn hier Leute nur mit einem Informatikstudium posten dürfen, schreibt so etwas doch bitte groß auf Seite 1.
-Mit google hatte du natürlich recht
-Virensoftware fand ich bis gerade eben noch wichtig?
-repariert habe ich Sie weil sie sich “aufgehängt” hatte. Tut man so etwas nicht?
- Die Heinies von der " kommerziellen Software" haben aufgeben und mir den Link von hier geschickt. Die hasse ich wirklich!
Zum Logfile:
Dieses sollte sich in meinem Temp Ordner befinden, tut es aber nicht?
Weder install-postgresql.log noch bitrock_installer.log or bitrock_installer_xxx.log
Aber ich habe in pg_log dies gefunden letzter Eintrag)
_“2010-02-04 22:22:49 CET LOG: database system was shut down at 2010-02-04 22:21:51 CET
2010-02-04 22:22:49 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:22:49 CET FATAL: the database system is starting up
2010-02-04 22:22:49 CET LOG: database system is ready to accept connections
2010-02-04 22:22:49 CET LOG: autovacuum launcher started
2010-02-04 22:22:50 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:24:51 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:24:59 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:25:00 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:25:08 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:25:37 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:29:07 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:29:45 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:30:02 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:38:12 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:42:49 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:43:18 CET LOG: loaded library “$libdir/plugins/plugin_debugger.dll”
2010-02-04 22:48:56 CET LOG: received fast shutdown request
2010-02-04 22:48:56 CET LOG: aborting any active transactions
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET LOG: autovacuum launcher shutting down
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET CONTEXT: SQL statement “select P.PlayerName,(Select netamountwon from playerhandscashkeycolumns where playerhandscashkeycolumns.pokerhand_id = PKH.pokerhand_ID and playerhandscashkeycolumns.Player_ID = PVP.player_id) as NetAmountWon,(select holecard1int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard1int, (select holecard2int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard2int, (select coalesce(holecard3int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard3int, (select coalesce(holecard4int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard4int from pokerhands PKH, playervsplayer PVP join Players p on pvp.player_id = p.player_id where PKH.Pokerhand_Id = PVP.PokerHand_id and PVP.Amount = (Select Max(Amount) from PLayerVsPlayer where pokerhand_id = PKH.PokerHand_ID) and PKH.Pokerhand_id = $1 limit 1”
PL/pgSQL function “getwinningplayerjoincashver2” line 4 at SQL statement
2010-02-04 22:48:56 CET STATEMENT: select PH.PokerHand_ID,PH.PreFlopPlayerActionType_ID,PH.StreetWentAllin,PH.HandTimeStamp,GT.GameTypeDescription, GT.PokerGame,PH.holecard1int,PH.holecard2int,PH.holecard3int,PH.holecard4int,PKH.FlopCard1int,PKH.flopcard2int,PKH.flopcard3int,PKH.TurnCardint,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,(case when PH.StreetWentAllIn > 0 then (Select SklanskyBucks from AllInSituations where ph.playerhand_id = allinsituations.playerhand_id) else 0 end) as SklanskyBucks,(case when PH.StreetWentAllIn > 0 then (Select EquityPct from AllInSituations where ph.playerhand_id = allinsituations.playerhand_id) else 0 end) as EquityPct,getwinningplayerjoincashver2(ph.pokerhand_id) as winningplayerjoin from playerhandscashkeycolumns_hero ph join pokerhands_hero pkh on ph.pokerhand_id = pkh.pokerhand_id join players pl on (pl.player_id = ph.player_id) join playerhandscashmisc_hero phmisc on phmisc.playerhand_id = ph.playerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations_hero ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 945 or ph.player_id = 4431 or ph.player_id = 60 or ph.player_id = 20103 or ph.player_id = 43503 or ph.player_id = 137576) and (ph.gametype_id = 1 or ph.gametype_id = 2 or ph.gametype_id = 3 or ph.gametype_id = 13 or ph.gametype_id = 14 or ph.gametype_id = 22 or ph.gametype_id = 27 or ph.gametype_id = 39 or ph.gametype_id = 40 or ph.gametype_id = 41 or ph.gametype_id = 48 or ph.gametype_id = 61 or ph.gametype_id = 62 or ph.gametype_id = 66 or ph.gametype_id = 67 or ph.gametype_id = 68 or ph.gametype_id = 69 or ph.gametype_id = 78 or ph.gametype_id = 82 or ph.gametype_id = 84 or ph.gametype_id = 85 or ph.gametype_id = 86 or ph.gametype_id = 88 or ph.gametype_id = 106 or ph.gametype_id = 130) and ph.handtimestamp > to_timestamp(‘01/01/2010 00:24:00’,‘mm/dd/yyyy hh24:mi:ss’) and gt.pokergame = 1 order by PH.HandTimeStamp desc limit 100
2010-02-04 22:48:56 CET FATAL: terminating connection due to administrator command
2010-02-04 22:48:56 CET CONTEXT: SQL statement “select P.PlayerName,(Select netamountwon from playerhandscashkeycolumns where playerhandscashkeycolumns.pokerhand_id = PKH.pokerhand_ID and playerhandscashkeycolumns.Player_ID = PVP.player_id) as NetAmountWon,(select holecard1int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard1int, (select holecard2int from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard2int, (select coalesce(holecard3int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard3int, (select coalesce(holecard4int,0) from PlayerHandsCashKeyColumns PHC where PHC.PokerHand_ID = PKH.PokerHand_ID and PHC.Player_ID = PVP.Player_ID) as HoleCard4int from pokerhands PKH, playervsplayer PVP join Players p on pvp.player_id = p.player_id where PKH.Pokerhand_Id = PVP.PokerHand_id and PVP.Amount = (Select Max(Amount) from PLayerVsPlayer where pokerhand_id = PKH.PokerHand_ID) and PKH.Pokerhand_id = $1 limit 1”
PL/pgSQL function “getwinningplayerjoincashver2” line 4 at SQL statement
2010-02-04 22:48:56 CET STATEMENT: select ph.pokerhand_id,ph.preflopplayeractiontype_id,ph.streetwentallin,ph.handtimestamp,gt.gametypedescription, gt.pokergame,ph.holecard1int,ph.holecard2int,ph.holecard3int,ph.holecard4int,pkh.flopcard1int,pkh.flopcard2int,pkh.flopcard3int,pkh.turncardint,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.sklanskybucks,ev.equitypct,getwinningplayerjoincashver2(ph.pokerhand_id) as winningplayerjoin from playerhandscashkeycolumns_hero ph join pokerhands_hero pkh on pkh.pokerhand_id = ph.pokerhand_id join gametypes gt on gt.gametype_id = ph.gametype_id left join allinsituations_hero ev on ph.playerhand_id = ev.playerhand_id where (ph.player_id = 945 or ph.player_id = 4431 or ph.player_id = 60 or ph.player_id = 20103 or ph.player_id = 43503 or ph.player_id = 137576) and (ph.gametype_id = 1 or ph.gametype_id = 2 or ph.gametype_id = 3 or ph.gametype_id = 13 or ph.gametype_id = 14 or ph.gametype_id = 22 or ph.gametype_id = 27 or ph.gametype_id = 39 or ph.gametype_id = 40 or ph.gametype_id = 41 or ph.gametype_id = 48 or ph.gametype_id = 61 or ph.gametype_id = 62 or ph.gametype_id = 66 or ph.gametype_id = 67 or ph.gametype_id = 68 or ph.gametype_id = 69 or ph.gametype_id = 78 or ph.gametype_id = 82 or ph.gametype_id = 84 or ph.gametype_id = 85 or ph.gametype_id = 86 or ph.gametype_id = 88 or ph.gametype_id = 106 or ph.gametype_id = 130) and ph.handtimestamp > to_timestamp(‘12/01/2009 10:46:47’,‘mm/dd/yyyy hh24:mi:ss’) and gt.pokergame = 1 order by ph.handtimestamp desc limit 100
2010-02-04 22:48:56 CET LOG: shutting down
2010-02-04 22:48:56 CET LOG: database system is shut down”
_
Ist das das Gesuchte?
ist jetzt Tip 3 ist nötig?
buhuuu