[Dnfbb-developers] [ dnfbb-Bugs-1586230 ] MySQL .NET Connector (1.0.8 RC)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Bugs item #1586230, was opened at 2006-10-28 12:24
Message generated for change (Comment added) made by tectsoft
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1586230&group_id=152364

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: DAL - MySQL
Group: None
>Status: Pending
Resolution: Accepted
Priority: 6
Private: No
Submitted By: Bosie (sbosanquet)
Assigned to: Bosie (sbosanquet)
Summary: MySQL .NET Connector (1.0.8 RC)

Initial Comment:
Board fails to load with the MySQL .Net Connector 
1.0.8 RC with the following error:

http://localhost/dnf/Error.aspx&Error=Exception+during+
execution+of+'DNF_USERS_GET'%
3a+Value+was+either+too+large+or+too+small+for+an+unsig
ned+byte.

----------------------------------------------------------------------

>Comment By: Si (tectsoft)
Date: 2006-12-14 17:03

Message:
Logged In: YES 
user_id=1154545
Originator: NO

reset to pending until MySQL have a resolution

----------------------------------------------------------------------

Comment By: SourceForge Robot (sf-robot)
Date: 2006-12-14 03:20

Message:
Logged In: YES 
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Si (tectsoft)
Date: 2006-11-29 07:38

Message:
Logged In: YES 
user_id=1154545
Originator: NO

Set back to pending, waiting a fix from MySQL

----------------------------------------------------------------------

Comment By: SourceForge Robot (sf-robot)
Date: 2006-11-29 03:20

Message:
Logged In: YES 
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Si (tectsoft)
Date: 2006-11-14 06:52

Message:
Logged In: YES 
user_id=1154545

Reset to pending for review in 14 days

----------------------------------------------------------------------

Comment By: SourceForge Robot (sf-robot)
Date: 2006-11-14 03:20

Message:
Logged In: YES 
user_id=1312539

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Bosie (sbosanquet)
Date: 2006-10-30 18:40

Message:
Logged In: YES 
user_id=1025541

Bug verified in MySQL .Net Connector 1.0.8 RC.  Fix issued into connector
CVS.  Will be resolved once 
the final 1.0.8 connector is issued.  To get around this problem, either
use connecotr 1.0.7 or 5.0.1.

----------------------------------------------------------------------

Comment By: Bosie (sbosanquet)
Date: 2006-10-29 13:19

Message:
Logged In: YES 
user_id=1025541

Issued a bug report to MySQL (http://bugs.mysql.com/bug.php?id=23749). 
Waiting on response.  The 
problem is occurs when you have VarChar declarations over 255 in size e.g.
OUT opSIGNATURE VARCHAR(2500)

----------------------------------------------------------------------

Comment By: Bosie (sbosanquet)
Date: 2006-10-29 08:10

Message:
Logged In: YES 
user_id=1025541

More detailed Exception:

Value was either too large or too small for an unsigned byte. 
Description: An unhandled exception occurred during the execution of the
current web request. Please 
review the stack trace for more information about the error and where it
originated in the code. 

Exception Details: System.OverflowException: Value was either too large or
too small for an unsigned 
byte.

Source Error: 

An unhandled exception was generated during the execution of the current
web request. Information 
regarding the origin and location of the exception can be identified using
the exception stack trace 
below.  

Stack Trace: 

[OverflowException: Value was either too large or too small for an
unsigned byte.]
   System.Byte.Parse(String s, NumberStyles style, NumberFormatInfo info)
+2577833
   MySql.Data.MySqlClient.StoredProcedure.ParseType(String type, String
sql_mode, MySqlParameter p) +535
   MySql.Data.MySqlClient.StoredProcedure.ParseParameter(String parmDef,
ContextString cs, String 
sqlMode) +568
   MySql.Data.MySqlClient.StoredProcedure.ParseBody(String body, String
sqlMode) +429
   MySql.Data.MySqlClient.StoredProcedure.DiscoverParameters(String
spName) +44
   MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection
connection, String spName) +79
   MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection
conn, String spName) +226
   MySql.Data.MySqlClient.StoredProcedure.Prepare(MySqlCommand cmd) +93

[MySqlException: Exception during execution of 'DNF_USERS_GET': Value was
either too large or too small 
for an unsigned byte.]
   MySql.Data.MySqlClient.StoredProcedure.Prepare(MySqlCommand cmd) +1282
   MySql.Data.MySqlClient.MySqlCommand.PrepareSqlBuffers(String sql) +266
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior
behavior) +185
   MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() +6
   DotNetForum.Library.DAL.MySqlDB.UserGet(UserSession Session, Int64
UserID) +3210
   DotNetForum.Library.BOL.UserSession..ctor(String SessionID, Boolean
LoggedIn, Boolean 
UseInternalCache) +144
   DotNetForum.Library.BOL.UserSession.LoginGuestUser(Int64 BoardID, Int32
Days, Boolean 
UseInternalCache, String IPAddress) +158
   DotNetForum.WebSite.Classes.BaseWebForm.LoginUser() +314
   DotNetForum.WebSite.Classes.BaseWebForm.GetSession() +173
   DotNetForum.WebSite.Classes.BaseWebForm.OnInit(EventArgs e) +24
   DotNetForum.WebSite.WebForm1.OnInit(EventArgs e) +52
   System.Web.UI.Control.InitRecursive(Control namingContainer) +321
   System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean 
includeStagesAfterAsyncPoint) +692

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=784889&aid=1586230&group_id=152364