No default for {shoutbox}.hostname causing error after D7 upgrade

Hi there,
I checked your comment but I was unable to reproduce that.
By default in shoutbox table the value is localhost so if you can give me more details for that I would glad.

'hostname' => array(
'type' => 'varchar',
'length' => 255,
'default' => 'localhost',
'not null' => TRUE,
'description' => 'The hostname where the post originated.',
),

Thanks a lot for your report

Thanks for that. I just upgraded from Drupal 6.33 to 7.31 and I had this exact issue when upgrading the shoutbox (I only disabled, installed D7 version of shoutbox and enabled)

I was getting this in the log when trying to submit a shout

PDOException: SQLSTATE[HY000]: General error: 1364 Field 'hostname' doesn't have a default value: INSERT INTO {shoutbox} (uid, nick, shout, module, moderate, created, changed, sid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => ynohtna [:db_insert_placeholder_2] => test [:db_insert_placeholder_3] => shoutbox [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 1409526721 [:db_insert_placeholder_6] => 1409526721 [:db_insert_placeholder_7] => gfpCn_ZnWdGB-eHGz0U62IiicjSi6rB1M__-akd1WwU ) in drupal_write_record()

When to look at shoutbox table and there is a hostname field where null is not allowed but there is also no default set.

Putting the default to 'localhost' as described above got my shouts working.

So the upgrade process should have a script to put 'localhost' or something in the default value for shoutbox.hostname

I experienced the same problem on a D6->D7 upgrade. I created an update hook #7000 to add a default value to the hostname column, see attached patch against 7.x-1.x-dev. It solves the problem in my case.

Please review.

patch applied

Thanks a lot