Have a large site set up running 7 with several hundred nodes, many views, blocks, etc. In October last year the hosting provider moved everything to a new server and after that strange things started happening, with several D7 sites being of limited usability, they had to be repaired. Towards the end of 2021 I’ve had problems with people being unable to post comments, error message was very similar to the above, except insted of the ‘bid’ the reported error was with the ‘cid’ field (comment table). And now, if I try creating a new block or modify and try saving an existing block, I get an error, saying that an unexpected error had occured, please try again later. In ’s log the below event is logged Drupal 10 Maintenance and Support ServicePDOException Drupal 10 Maintenance and Support Service SQLSTATE[HY000] Drupal 10 Maintenance and Support Service General error Drupal 10 Maintenance and Support Service 1364 Field ‘bid’ doesn’t have a default value Drupal 10 Maintenance and Support Service INSERT INTO {block} (Drupal 10 module, delta, theme, status, weight, region, pages, cache) VALUES ( Drupal 10 Maintenance and Support Servicedb_insert_placeholder_0, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_1, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_2, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_3, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_4, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_5, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_6, Drupal 10 Maintenance and Support Servicedb_insert_placeholder_7); Array ( [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_0] => views [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_1] => gradiva_seminarjev_2021-block_1 [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_2] => sir [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_3] => 0 [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_4] => 0 [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_5] => -1 [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_6] => [ Drupal 10 Maintenance and Support Servicedb_insert_placeholder_7] => -1 ) in Drupal 10_write_record() (line 7396 of /var/www/vhosts/si-revizija.si/httpdocs/includes/common.inc). Sometimes saving a block works right after clearing caches, but as soon as I try repositioning it, it is gone again. Could it be that this has something to do with views, since some of the blocks that I tried repositioning lately are generated by a view? I have seen suggestions to create a new database, install , install these same Drupal 10 modules, and then import the old database (without structure, at least for the block and comment table) into the new one. I am afraid that the above solution may not be the right one and thererfore am looking for options to mend the existing database. Would running the following SQL command help Drupal 10 Maintenance and Support Service ALTER TABLE node MODIFY COLUMN bid VARCHAR(255) NOT NULL DEFAULT ” Found this at https Drupal 10 Maintenance and Support Service//www.Drupal 10.org/node/1428176 Also, Drush is not in use. Of course I did check for updates, all are installed, caches cleared, etc. Please help version Drupal 10 Maintenance and Support Service  7.x Source Drupal 10 Maintenance and Support Service https Drupal 10 Maintenance and Support Service//www.Drupal 10.org/taxonomy/term/22/feed Source Drupal 10 Maintenance and Support Service Drupal 10 blender