Switched to IIS7, Now MySQL + CF not working

[idesdema]

I'm getting a weird error since I switched to IIS7.  "Data truncation: Data too long" in MySQL with the exact same code and same MySQL Database I was using previosuly.  MySQL v5.1.

Any ideas?

[Adam Cameron.]

Yep, here's an idea.  Tell us:

* the query that's erroring;

* the table schema of the table being written to;

* the source of the data being written, with examples

I strongly doubt IIS has anything to do with this.  The code and the DB might be the same, but the data's going to be different each time, innit?  This error is indicative of the data you're asking to write to the DB being too long for the column spec.  IIS has nothing to do with this.

--

Adam

[idesdema]

Yep you were right.  What was happening is that my db administration GUI was still connecting to the old VPS.  Once I changed the connection info to connect to the new IP, I saw that the db table column had not been changed (I was changing the old db).  Once I lengthened the varchar to accept longer strings it worked.