SharpStats Personal Tracker
[ New messages · Members · Forum rules · Search · RSS ]
Page 1 of 11
Forum moderator: redlotus 
Forum » SharpStats » Bugs » Cannot import cake tournament histories
Cannot import cake tournament histories
cirobonanoDate: 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)
 
redlotusDate: 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.

 
cirobonanoDate: 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.

 
redlotusDate: 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

 
cirobonanoDate: 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?

 
redlotusDate: 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

 
cirobonanoDate: 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)
 
redlotusDate: 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?
 
cirobonanoDate: 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.
 
redlotusDate: 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

 
cirobonanoDate: 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.

 
redlotusDate: 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

 
Forum » SharpStats » Bugs » Cannot import cake tournament histories
Page 1 of 11
Search:

2017