SharpStats Personal Tracker
[ New messages · Members · Forum rules · Search · RSS ]
Page 1 of 11
Forum moderator: redlotus 
Forum » SharpStats » Bugs » Cannot cast type bit to text (SharpStats v1.0 error viewing hands)
Cannot cast type bit to text
wesdublDate: Saturday, 2009-08-01, 5:21 PM | Message # 1
Private
Group: Users
Messages: 1
Status: Offline
First of all, thank you creating this application and for supporting the Merge network. I will definitely use this product for that reason.

I imported my hands from the Merge site just fine, but when I try to view hands or graphs I get the following error:

ERROR: 42846: cannot cast type bit to text

Quote

************** Exception Text **************
Npgsql.NpgsqlException:
cannot cast type bit to text
Severity: ERROR
Code: 42846
at Npgsql.NpgsqlConnector.CheckErrors()
at Npgsql.NpgsqlConnector.CheckErrorsAndNotifications()
at Npgsql.NpgsqlCommand.ExecuteCommand()
at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior cb)
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)

----------------------------------------
Npgsql
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/WINDOWS/assembly/GAC/Npgsql/1.0.0.0__5d8b90d52f46fda7/Npgsql.dll
----------------------------------------

I have PosgreSQL 8.3 and Windows XP. Let me know if you have any suggestions.
Wes

Added (2009-08-01, 5:21 Pm)
---------------------------------------------
OK, nevermind I was connecting to my PostgreSQL 8.2 database, not the 8.3, wrong port. Once I corrected that the application works fine. One bug I do notice though is if I try to refresh with the filter on, and there is no filter I get an exception, obviously not to big of a deal.

Thanks again for creating this, if you need Merge hands let me know.
Wes

 
redlotusDate: Saturday, 2009-08-01, 9:45 PM | Message # 2
Can't settle on a title
Group: Administrators
Messages: 68
Status: Offline
Quote (wesdubl)
OK, nevermind I was connecting to my PostgreSQL 8.2 database, not the 8.3, wrong port. Once I corrected that the application works fine. One bug I do notice though is if I try to refresh with the filter on, and there is no filter I get an exception, obviously not to big of a deal.

Glad you got the first problem sorted out. I will definitely fix the filter exception error for the next version.

Thanks,
-red

 
Forum » SharpStats » Bugs » Cannot cast type bit to text (SharpStats v1.0 error viewing hands)
Page 1 of 11
Search:

2017