Cannot import cake tournament histories
| |
cirobonano | Date: Wednesday, 2010-02-24, 7:48 AM | Message # 1 |
Private
Group: Users
Messages: 9
Status: Offline
| It's been a while since I tried a program to import cake histories; HM doesn't seem to work either. Downloaded the latest version, made a new database. When I configure an import folder and click "import now" it does nothing; 0 hands imported. When I select Utilities->Cake TournamentImport Utility I get a crash with Code
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text ************** Npgsql.NpgsqlException: column "hand_archive.raw_hand" must appear in the GROUP BY clause or be used in an aggregate function Severity: ERROR Code: 42803 at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 835 at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1138 at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1154 at Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1340 at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1004 at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 591 at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 572 at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 519 at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at SSLibrary.clsCPNTourney.ImportTourney() in E:\Programming\Projects\SharpStats Personal Tracker\SSLibrary\mConverters.cs:line 2699 at SharpStats_Personal_Tracker.fclsMain.btnTRImpCPN_Click(Object sender, EventArgs e) in E:\Programming\Projects\SharpStats Personal Tracker\SharpStats Personal Tracker\Form1.cs:line 2751 at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e) at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e) at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e) at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ToolStrip.WndProc(Message& m) at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
|
|
| |
redlotus | Date: Thursday, 2010-02-25, 9:32 AM | Message # 2 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| Thanks for reporting this. The Cake Tournament Import Utility will be fixed in the official release, which will be released today. However, the utility still will not work if you don't have any hands imported. As for the "0 hands imported" issue, I recommend that you uninstall SharpStats, delete the Program Files\SharpStats Personal Tracker folder, delete the My Documents\SSPT folder, then install the latest version from scratch. If you are still having issues after doing this, let me know. Thank you, -red ****Important Edit**** Make sure that you move all of your archived hand histories out of the My Documents\SSPT\Archive folder before deleting any folders.
|
|
| |
cirobonano | Date: Thursday, 2010-02-25, 11:01 AM | Message # 3 |
Private
Group: Users
Messages: 9
Status: Offline
| Thanks for your reply. I removed all old versions, the My Docments\SSPT folder, all old databases and installed the latest version (SharpStats v1.01 Official); the import still doesn't do anything. Is there any way of turning on debugging? I can't see if it cannot find the files or if there is some error importing. What's exactly the difference between importing hands "the normal way" and using the Tournament Import Utility? Thanks again for all your work; if this finally works I'd be very happy.
|
|
| |
redlotus | Date: Thursday, 2010-02-25, 10:37 PM | Message # 4 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| Quote (cirobonano) Is there any way of turning on debugging? I can't see if it cannot find the files or if there is some error importing. I can definitely come up with something to work this out. Let me try and get something that would help but not be annoying and I'll post back here. Quote (cirobonano) What's exactly the difference between importing hands "the normal way" and using the Tournament Import Utility? In-line importing (the "normal way") reads the last line of the hand history file that contains the "player finished x out of y players" to determine the place. Using the utility, SharpStats attempts to do the same thing except it reads the final hand of a tournament from the database (not the original file). Therefore, the hands must be imported prior to using the utility. -red
|
|
| |
cirobonano | Date: Friday, 2010-02-26, 1:56 AM | Message # 5 |
Private
Group: Users
Messages: 9
Status: Offline
| Quote (redlotus) I can definitely come up with something to work this out. Let me try and get something that would help but not be annoying and I'll post back here. Well it can be annoying as long as there's some button somewhere to turn it on/off. Is there anything else I can do? Should I email you the hand histories?
|
|
| |
redlotus | Date: Friday, 2010-02-26, 9:30 AM | Message # 6 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| Quote (cirobonano) Is there anything else I can do? Should I email you the hand histories? I have uploaded a debug version to the Downloads section. This version adds a few things: 1. A list of files that SharpStats finds in your import directories. This list is located in the "Database Maintenance" section of the Import tab. 2. An "Enable Debug" checkbox. If you check this box, SharpStats will report how many files it finds and then report how many hands that it finds within each file. Give this version a try and let me know what happens. Thanks, -red
|
|
| |
cirobonano | Date: Friday, 2010-02-26, 2:27 PM | Message # 7 |
Private
Group: Users
Messages: 9
Status: Offline
| I get the message "5 files found" and after that directly "0 hands successfully updated" and "Session clean-up complete". An example hand: Code Hand#21447788BF000001 - $1 NL Hold'em Turbo T7833791 -- Table 1 -- $0/$10/$20 NL Hold'em -- 2010-02-17 - 17:23:31 Seat 1: ciro-bonano ($1.500 in chips) Seat 2: PROB***2 ($1.500 in chips) Seat 3: bamb***3 ($1.500 in chips) Seat 5: Dear***5 ($1.500 in chips) Seat 6: Myst***6 ($1.500 in chips) Seat 7: Kral***7 ($1.500 in chips) Seat 8: Vero***8 ($1.500 in chips) Seat 9: spar***9 ($1.500 in chips) Seat 10: doin***10 ($1.500 in chips) DEALER ciro-bonano: posts small blind 10 PROB***2: posts big blind 20 Dealt to ciro-bonano [Qc,8c] bamb***3: calls 20 Voca***4: calls 20 Dear***5: folds Myst***6: folds Kral***7: folds Vero***8: folds spar***9: calls 20 doin***10: folds ciro-bonano: folds PROB***2: raises to 40 bamb***3: calls 20 Voca***4: calls 20 spar***9: calls 20 *** FLOP *** [3d,Jh,Kd] PROB***2: bets 60 bamb***3: calls 60 Voca***4: raises to 120 spar***9: folds PROB***2: calls 60 bamb***3: calls 60 *** TURN *** [Kh] PROB***2: checks bamb***3: checks Voca***4: bets 265 PROB***2: calls 265 bamb***3: calls 265 *** RIVER *** [7s] PROB***2: checks bamb***3: checks Voca***4: bets 662 PROB***2: folds bamb***3: calls 662 ***SHOW DOWN*** Voca***4: shows [Kc Qh] (Three of a Kind, Kings ) bamb***3: mucks Voca***4: wins 2.649 with Three of a Kind, Kings bamb***3: mucks [ Td, Jd ] (TwoPair)
|
|
| |
redlotus | Date: Friday, 2010-02-26, 4:21 PM | Message # 8 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| Quote (cirobonano) I get the message "5 files found" and after that directly "0 hands successfully updated" and "Session clean-up complete". Does the text box in the bottom-right corner list the 5 files or is it empty?
|
|
| |
cirobonano | Date: Saturday, 2010-02-27, 1:17 PM | Message # 9 |
Private
Group: Users
Messages: 9
Status: Offline
| Quote (redlotus) Does the text box in the bottom-right corner list the 5 files or is it empty? It does list the 5 files.
|
|
| |
redlotus | Date: Sunday, 2010-02-28, 2:37 PM | Message # 10 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| That definitely helps to narrow things down. I've posted a new debug version in the download section. I've made a change that I hope will fix the problem and added another checkpoint. Please download and install this new version and let me know how it works. Thanks, -red
|
|
| |
cirobonano | Date: Monday, 2010-03-01, 1:52 AM | Message # 11 |
Private
Group: Users
Messages: 9
Status: Offline
| Okay, removed database/program/"mydocuments/sspt" folder and installed again. I first see "5 files found", then "MaxImport=5", followed by "0 hands succesfully updated" and "session clean-up complete". After this, the 5 filenames are listed in the lower right corner.
|
|
| |
redlotus | Date: Monday, 2010-03-01, 7:34 PM | Message # 12 |
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
| #3 has been uploaded to the Downloads section. Let me know what messages you get. Thanks, -red
|
|
| |
|