I had a Drupal 6 site on a server that I’ve made a local copy of using Backup & Migrate. I’ve now upgraded this site to Drupal 7 on my localhost. When I try to move this to a server (or, as I’ve discovered, a new installation of D7 on localhost) I get the following errors once I run update.php
Error message
- Notice: date_default_timezone_set() [function.date-default-timezone-set]: Timezone ID ‘0’ is invalid in drupal_session_initialize() (line 273 of /Users/username/Sites/sitename/includes/session.inc).
- PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘source’ in ‘field list’: SELECT DISTINCT SUBSTRING_INDEX(source, ‘/’, 1) AS path FROM {url_alias}; Array ( ) in drupal_path_alias_whitelist_rebuild() (line 380 of /Users/username/Sites/sitename/includes/path.inc). Uncaught exception thrown in session handler. PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘ssid’ in ‘where clause’: SELECT 1 AS expression FROM {sessions} sessions WHERE ( (sid = :db_condition_placeholder_0) AND (ssid = :db_condition_placeholder_1) ) FOR UPDATE; Array ( [:db_condition_placeholder_0] => Hz-vcoMFEI-tL3Tw55qLQG6kNqXmB2pziLRC1SMQVYw [:db_condition_placeholder_1] => ) in _drupal_session_write() (line 209 of /Users/username/Sites/sitename/includes/session.inc).
No idea what’s going on as the upgraded original site is working perfectly. It’s when I try to migrate it to a server that it all seems to break down.
Do you have any idea?