Fwd: FN-FORUM: Updating / inserting a LONGTEXT field in mySQL using ASP / IIS

date posted 15th January 2007 15:45

Well I didn't really find a solution. Basically I could delete the
contents of these fields and then update them with new content. I
could not update them with longer text if there was already content in
these fields.

I then added so more VARCHAR fields and started getting this error...

Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt]Got error 139
from storage engine

I tried updating the content directly through MySQL Query Browser and
got the same 139 error. Some googling led me to change the table
engine from InnoDB to MyISAM. It seems to have sorted everything out.

Maybe I should keep a journal of my exciting work like ...