PDOException: SQLSTATE[HY000]: General error: 1364 Field 'router_path' doesn't have a default value: INSERT INTO {menu_links} (m

IGNORE THIS ... I misread

{menu_links}.router path has a default value of '', see
http://api.drupal.org/api/drupal/modules--system--system.install/functio...

     'router_path' => array(
        'description' => 'For links corresponding to a Drupal path (external = 0), this connects the link to a {menu_router}.path for joins.', 
        'type' => 'varchar', 
        'length' => 255, 
        'not null' => TRUE, 
        'default' => '',

Please run the output of SHOW CREATE TABLE menu_links; on your Drupal install.

Alternatively you could try installing http://drupal.org/project/schema and compare with that. I've not tried that module for D7 yet.

This looks like a site-specific issue so I'm moving it to a support request for now.

Is the script you ran from Drupal.org somewhere or just a generic one for changing collation?

So the issue is this:

  `router_path` varchar(255) NOT NULL,

On a stock D7 install on my system it's this:

  `router_path` varchar(255) NOT NULL DEFAULT '' COMMENT 'For links corresponding to a Drupal path (external = 0), this connects the link to a menu_router.path for joins.',

Looking at the script you posted it has this section:

  
  if ( $row['Null'] == 'YES' )
   $nullable = ' NULL ';
  else
   $nullable = ' NOT NULL ';
  // Does the field default to null, a string, or nothing?
  if ( $row['Default'] === NULL && $row['Null'] == 'YES' )
   $default = " DEFAULT NULL ";
  elseif ( $row['Default'] != '' )
   $default = " DEFAULT '".mysql_real_escape_string($row['Default'])."'";
  else
   $default = '';
  // sanity check and fix:
  if ($nullable == ' NOT NULL ' && $default == ' DEFAULT NULL ') {
   $default = '';

This looks pretty broken to me. So what's happened is the script has corrupted your database to have a completely different schema to the one Drupal requires, instead of just changing the collation.

You'll need to either restore a backup of the db, or start again. Another option is to backup, do a clean install, then try to import the data (but not the table definitions) from a database dump - that might work fine.

I'm going to mark this fixed since I think we identified what the problem is and there's no core bug to fix.

First, let me apologize if this is not the proper place to report this problem. If it isn't can someone please give me a link where I should report it?

I recently exported my Drupal DB and imported it on another system. The new site works, except I get the PDO error when I try to perform admin tasks, such clicking on the Content tab or try to "configure block". If I try to "edit block", I do not get this error. I am using Drupal 7.51. I have NO local code . I only have supported Drupal add-ins. I have tried to switch to Non-strict mode which did not help. I have also tried to delete and re-import the DB. The OLD system is currently unavailable (hardware failures), so I can't currently re-export. I am using MySQL 5.7.23.

I was fortunate to still have my original site in working condition. So this solution https://www.drupal.org/node/1428176 worked for me. I just examined the 2 databases (in my case, using phpmyadmin) looking for the tables/fields with the "bad" initial values and made the new DB match the old DB. I used the "manual" method because I did not want to muddy the waters with anything that update.php might do in the "fast" method. I only needed steps 7-10 and it took me 2 minutes for the 2 tables causing trouble.