Error: Unable to Insert into Node_revisions table when converting from wordpress 2.6.0 to drupal 6.4
I'm currently trying to convert from wordpress 2.6.0 to drupal 6.4 and running into this error during the conversion process:
"Error: Unable to Insert into Node_revisions table. : Field 'log' doesn't have a default value"
I've checked into the node_revisions table in my drupal database and the field log is a longtext field, which doesn't allow for default values. I don't think I'm doing anything too special. I have ~200 pages and posts combined.
I can't reproduce this error. I converted a Wordpress 2.6.2 database (400 posts, 1800 comments) to Drupal 6.4 without error. I used the 1.04 version of the converter.
What I would suggest is re-creating (re-installing) the Drupal installation, which in turn creates the tables in the (new) database. Then try again.
Are you conducting the conversion remotely (that is over the internet) or locally (on your home computer). If the problem persists, and is a remote conversion, I could attempt it at my end.
I'm running the conversion locally - I'll give the fresh database thing another try tonight if I can and let you know how it goes. We're considering drupal among other cms systems so I'd hate to have you do it on your end since we would need to do it again at some point.
Yes, a strange one. I haven't come across this before and you're right, there are no default values for the log field. Leave it with me, I'll try a few things and see what happens.
Steve
My running website