User warning: The following module is missing from the file system

for drupal7

drush sql-query "DELETE from system where name = 'old_module1' AND type = 'module';"

for drupal8

drush sql-query "DELETE FROM key_value WHERE collection='system.schema' AND name='module_name';"