1

I am having problems migrating my site to a production server. It's build in Drupal 7. I used the backup and migrate plugin to export the DB. The development server is Windows with Wamp installed and the production server is CentOS with Cpanel.

These are the errors I am getting:

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

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'fosagams_co_za.semaphore' doesn't exist: DELETE FROM {semaphore} WHERE (value = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => 191980980751f69eddeb26b7.24464293 ) in lock_release_all() (line 269 of /home/balabalab/public_html/includes/lock.inc).

I did however verify that the semaphore table exists. I am out of ideas, any help would be appreciated.

Thanks in advance.

  • 1
    Have you double checked the database settings in settings.php ? – tostinni Jul 29 '13 at 18:30
0

I also got the same problem. Then i realizez that when migrating, i copy and paste from old server. And when i opend the database on my new server and choose a table in it, it was emty giving me error: "table does not exist". So check out if it is importing the content of the data firt before continuing with your search.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.