Skip to content

Instantly share code, notes, and snippets.

@onecooltaco

onecooltaco/fix-dbname.semaphore.sql

Created June 23, 2015 00:40
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save onecooltaco/e7e6792d88b1b3df1063 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save onecooltaco/e7e6792d88b1b3df1063 to your computer and use it in GitHub Desktop.
Download ZIP
Drupal Troubleshooting.
Raw
fix-dbname.semaphore.sql
/*
Getting “warning: Table 'dbname.semaphore' doesn't exist query: SELECT expire, value FROM semaphore”
when updating DB or running Drush commands.
Try running this query on your database.
*/
CREATE TABLE semaphore ( `name` VARCHAR(255) NOT NULL DEFAULT '', `value` VARCHAR(255) NOT NULL DEFAULT '', `expire` DOUBLE NOT NULL, PRIMARY KEY (name), INDEX expire (expire) ) /*!40100 DEFAULT CHARACTER SET UTF8 */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment