[support] SQL Error After Moving Site

Steve Kessler skessler at denverdataman.com
Mon Jul 15 17:07:15 UTC 2013


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

-- 
Steve Kessler
Owner and Lead Consultant
Denver DataMan, LLC
303-587-4428
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130715/4ce4ad5c/attachment.html 


More information about the support mailing list