Reveiving following error upon enabling this module:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'drupal7.stager_semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 165 of C:\xampp\htdocs\drupal7\includes\lock.inc).

Followed the directions in the readme.

Comments

rp7’s picture

rp7 commented

This message actually occures once I make the settings.php alterations...

aristeides’s picture

aristeides commented

subscribing

aristeides’s picture

aristeides commented
swentel’s picture

swentel commented
Status: Active » Closed (won't fix)

That's a drupal core bug, the semaphore table should be there on a Drupal 7 installation.

TrevorG’s picture

TrevorG commented
Status: Closed (won't fix) » Active

I got the same db error on create staged site, after following the instructions. On subsequent attempts, this extended error came up:

Error
The website encountered an unexpected error. Please try again later.
Error message
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theo2010_drupal.stager_semaphore' doesn't exist: SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 164 of /home/theo2010/public_html/includes/lock.inc).
Uncaught exception thrown in shutdown function.

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theo2010_drupal.stager_semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 18429784714d926f1be7e133.95018323 ) in lock_release_all() (line 246 of /home/theo2010/public_html/includes/lock.inc).

This then caused errors on any page view.

I replaced the settings.php with the original and it was fine, with the grey bar at the bottom, but of course it did not create any tables in the db.

I have marked this as active because I don't believe it to be an isolated case of one messed up drupal install, and it likely needs to be fixed so that we can install your module which looks really great. Looking at my db there is a semaphore table, but no records in it.

mavimo’s picture

mavimo commented

Try patch posted on #1269074: Error in data copy generate a complete crash of module, I think it can solve your problem.

swentel’s picture

swentel commented
Status: Active » Closed (duplicate)

Yup, that patch should fix it all, marking this as duplicate of that one.