Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By rschuler on
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
You also have to configure
You also have to configure the database prefix "d7_centertest" in the settings.php.
I like cookies!