Manish Pansiniya's Blog

.NET, C#, Javascript, ASP.NET and lots more…:)

Subsonic : Input string was not in a correct format. Database Error or FormatException – solution

with 3 comments

we were working with subsonic and MySQL database. Suddenly there was one error pops up and that is

{“Input string was not in a correct format.”}

I tried many things but could not find the issue. At last I put the pdb file of SubSonic.dll and debug the issue. The issue is in the inbuild column name. Subsonic use Audit fields (CreatedBy, CreatedOn, ModifiedBy and ModifiedOn ). So if any one of these fields present in your table and if it is not varchar type then zoooop…you will get this wierd exception :-). So to resolve the issue. just rename the field to another name.


Written by Manish

March 12, 2008 at 11:46 am

Posted in .NET, .NET 3.0, MySQL

3 Responses

Subscribe to comments with RSS.

  1. Gud one.. I had this problem… now solved already….tnx


    December 10, 2008 at 7:30 am

  2. waaaahhh! I am so pissed off!


    February 25, 2010 at 12:10 pm

    • me too was at that time 🙂


      February 26, 2010 at 9:30 pm

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: