I created a website in drupal 7, tested it in my localhost and works good. Now, I want to host the site in our Main server. So, I uploaded the site directory to the server and created a corresponding database for that. Updated the settings.php file with the database name, user and password.
I do hope that the site install process is done. The site is deployed within the server, database created. When I give the address of the site, it shows some PDO exception error.
PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table '[database].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/cpath/D-6.12/apache2/htdocs/[htdocs]/includes/lock.inc).
I tried re-installing the drupal site, it didn't work.
I even reviewed and tried all the solutions shown in drupal.org, but no way I couldn't resolve the issue.
I appreciate your valuable suggestions.
update.php
[your-site]/update.php – shrish Jun 11 '14 at 15:53semaphore table
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) ) – shrish Jun 11 '14 at 16:09