SharpStats Personal Tracker
[ New messages · Members · Forum rules · Search · RSS ]
  • Page 1 of 1
  • 1
Forum moderator: redlotus  
Forum » SharpStats » Bugs » cake error while importing hh (playersonly skin) (error message)
cake error while importing hh (playersonly skin)
goforthclanDate: Tuesday, 2009-07-21, 8:04 PM | Message # 1
Private
Group: Users
Messages: 2
Status: Offline
when i try to import the hh i get the following message:
number of hand histories processed: 0
import rate = .00 hand/second
errors encountered during import process

it does move all of my hh to the cache folder.
i have tried resetting the database and moving the hh back to the original hh folder and trying again numerous times with the sme result. I am using sharpstats 1.0 fresh install (no previous version ever installed) and windows xp sp 2. I have walked though the tutorial several times with no success. I'm sure I'm doing something simple wrong. please help
btw: all hh are for ring games

Message edited by goforthclan - Tuesday, 2009-07-21, 8:05 PM
 
redlotusDate: Wednesday, 2009-07-22, 9:12 AM | Message # 2
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
Are all of the hand history files from after July 1, 2008?
 
goforthclanDate: Thursday, 2009-07-23, 5:05 AM | Message # 3
Private
Group: Users
Messages: 2
Status: Offline
yes they are all from about july 5th 09 to the present

Added (2009-07-23, 5:05 Am)
---------------------------------------------
okay, here is what is happening now. i installed the .net framework and rebooted i was able to get 4781 hands imported but it said with errors (didn't tell me what they were) i am able to graph but when i go to the hold em cash tab there is nothing displayed when i select this month and hit refresh i get a unhandled exeption has occurred box that says continue or exit under the details it says this:

************** Exception Text **************
Npgsql.NpgsqlException:
cannot cast type bit to text
Severity: ERROR
Code: 42846
at Npgsql.NpgsqlConnector.CheckErrors() in c:\Desenvolvimento\Npgsql1.0-src\Npgsql\src\Npgsql\NpgsqlConnector.cs:line 359
at Npgsql.NpgsqlConnector.CheckErrorsAndNotifications() in c:\Desenvolvimento\Npgsql1.0-src\Npgsql\src\Npgsql\NpgsqlConnector.cs:line 410
at Npgsql.NpgsqlCommand.ExecuteCommand() in c:\Desenvolvimento\Npgsql1.0-src\Npgsql\src\Npgsql\NpgsqlCommand.cs:line 1479
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in c:\Desenvolvimento\Npgsql1.0-src\Npgsql\src\Npgsql\NpgsqlCommand.cs:line 633
at Npgsql.NpgsqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior cb) in c:\Desenvolvimento\Npgsql1.0-src\Npgsql\src\Npgsql\NpgsqlCommand.cs:line 601
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 SharpStats_Multi.fclsMain.btnHECRefresh_Click(Object sender, EventArgs e) in C:\Users\THM6192\Documents\Visual Studio 2008\Projects\SharpStats Multi\SharpStats Multi\fclsSS.cs:line 2884
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(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)

if this isn't the part that you need let me know and i will post more of it.

Message edited by goforthclan - Thursday, 2009-07-23, 5:06 AM
 
redlotusDate: Friday, 2009-07-24, 9:19 AM | Message # 4
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
Quote (goforthclan)
i installed the .net framework

Sorry about not listing .NET 2.0+ as a requirement. I'll add that as a new FAQ item shortly.

Quote (goforthclan)
i was able to get 4781 hands imported but it said with errors (didn't tell me what they were)

If you go to the Database Editor tab and click the Import Errors button, it will give you a list of the problem hands.

Quote (goforthclan)
cannot cast type bit to text

This is the most relevant part of the error message. Basically, it is telling me that you are running an older version of PostgreSQL. SharpStats requires PostgreSQL version 8.3 or newer to work correctly. I will also be adding this requirement to the FAQ.

-red

 
Forum » SharpStats » Bugs » cake error while importing hh (playersonly skin) (error message)
  • Page 1 of 1
  • 1
Search:

2024