Hello, I have a bit of a strange problem.

I am moving a live production site down to my local machine. I made a copy of the database through phpmyadmin, then created and imported that database into one locally using phpmyadmin through MAMP. Then, I updated my settings.php file to match the new database settings. I have moved the entire drupal installation and all files locally under my htdocs folder in MAMP.

I have tried truncating all the cache in the database but that didn't seem to change anything. Does anyone have any suggestions so that I can get this site running locally?

Additional uncaught exception thrown while handling exception.
Original

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd7_centertest.url_alias' doesn't exist: SELECT source FROM {url_alias} WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC; Array ( [:alias] => node/22 [:language] => en [:language_none] => und ) in drupal_lookup_path() (line 176 of /Applications/MAMP/htdocs/centeractivities/includes/path.inc).
Additional

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd7_centertest.watchdog' doesn't exist: INSERT INTO {watchdog} (uid, type, message, variables, severity, link, location, referer, hostname, timestamp) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => php [:db_insert_placeholder_2] => %type: !message in %function (line %line of %file). [:db_insert_placeholder_3] => a:6:{s:5:"%type";s:12:"PDOException";s:8:"!message";s:336:"SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd7_centertest.url_alias' doesn't exist: SELECT source FROM {url_alias} WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC; Array ( [:alias] => node/22 [:language] => en [:language_none] => und ) ";s:9:"%function";s:20:"drupal_lookup_path()";s:5:"%file";s:60:"/Applications/MAMP/htdocs/centeractivities/includes/path.inc";s:5:"%line";i:176;s:14:"severity_level";i:3;} [:db_insert_placeholder_4] => 3 [:db_insert_placeholder_5] => [:db_insert_placeholder_6] => http://localhost:8888/centeractivities/ [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => ::1 [:db_insert_placeholder_9] => 1438721356 ) in dblog_watchdog() (line 160 of /Applications/MAMP/htdocs/centeractivities/modules/dblog/dblog.module).

Comments

Stefan Lehmann’s picture

You also have to configure the database prefix "d7_centertest" in the settings.php.

$databases['default']['default'] = array(
  'driver' => 'mysql',
  'database' => 'databasename',
  'username' => 'username',
  'password' => 'password',
  'host' => 'localhost',
  'prefix' => 'd7_centertest',
  'collation' => 'utf8_general_ci',
);

I like cookies!