I have a site working very well in my dev environment and an older version was working on the production server.
The is loading very well and appears to be connected to the correct database. When I try and login with any user I get "*PDOException*: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'user_drupal_production.field_data_field_name' doesn't exist: SELECT t.* FROM {field_data_field_name} t WHERE (entity_type = :db_condition_placeholder_0) AND (entity_id IN (:db_condition_placeholder_1)) AND (language IN (:db_condition_placeholder_2)) AND (deleted = :db_condition_placeholder_3) ORDER BY delta ASC; Array ( [:db_condition_placeholder_0] => user [:db_condition_placeholder_1] => 18 [:db_condition_placeholder_2] => und [:db_condition_placeholder_3] => 0 ) in * field_sql_storage_field_storage_load()* (line *349* of* /home/user/public_html/modules/field/modules/field_sql_storage/field_sql_storage.module *)."
I have checked and the databases appear to have all the same tables. Any help is greatly appreciated.
Thanks, Steve