I've been working on a Drupal 7.x site for the past year. In September I was prompted to update the site to the latest core of Drupal for an important security update.
When I did the update and ran the "update.php" command, as is best practice, I received the following error:
PDOException: SQLSTATE[HY000]: General error: 1 no such table: semaphore: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /nfs/c09/h01/mnt/128315/domains/parfaitonline.com/html/dev/includes/lock.inc).
I've searched through the Drupal support community to see if any other developers have encountered this. I did notice that somehow the name of my database was changed (unbeknownst to me).
Has anyone else encountered this problem? Has anyone found a fix?
Comments
=-=
from what version of drupal did you update and to what version of drupal did you update?
did you check the database to see if the table exists or not?
have you run update.php again to ensure that you've applied all database updates?
PDOException: SQLSTATE[HY000]
I was using Drupal 7.15. I was updating to 7.17.
I am not really a developer, so I was not sure how to verify if a table exists or not. I do know, however, that I did not make any changes to the database before or after the Drupal version update.
I posted this comment the third time I tried to update my version and the same issue occurred.
Each time I run "Update.php" I get the same error message.
Thanks!
=-=
did you correct this in settings.php?
in researching the error with google: http://api.drupal.org/api/drupal/includes%21lock.inc/7#comment-26128 includes two links which may aid. The second of which aids in creating the table.
Thanks. I'll try that.
Thanks. I'll try that.