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.

Advertisements

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

    Anonymous

    December 10, 2008 at 7:30 am

  2. waaaahhh! I am so pissed off!

    adet

    February 25, 2010 at 12:10 pm

    • me too was at that time 🙂

      Manish

      February 26, 2010 at 9:30 pm


Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: