The table did exist at one point looking at the version that was running on the production server but it is not in the live database.
I ran the database update through Drush.
The code base is the same between the dev and production servers but newer than the version that was running. I did the move of the code through SCP.
-Steve
On Mon, Jul 15, 2013 at 11:41 AM, Metzler, David metzlerd@evergreen.eduwrote:
Another possibility is that the code on the two different instances are not running the same version of source code. Have you tried running update.php on this site? ****
Dave****
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Rahul Chauhan *Sent:* Monday, July 15, 2013 10:25 AM *To:* support@drupal.org *Subject:* Re: [support] SQL Error After Moving Site****
Check you old database backup for the same table.****
On Mon, Jul 15, 2013 at 10:50 PM, Steve Kessler < skessler@denverdataman.com> wrote:****
That table does not exist in either database.****
On Mon, Jul 15, 2013 at 11:16 AM, Rahul Chauhan rahulchauhan999@gmail.com wrote:****
Hi,****
Please check database carefully for this table "Table 'user_drupal_production.field_data_field_name' "****
Thanks****
Rahul ****
On Mon, Jul 15, 2013 at 10:37 PM, Steve Kessler < skessler@denverdataman.com> wrote:****
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****
-- [ Drupal support list | http://lists.drupal.org/ ]****
-- [ Drupal support list | http://lists.drupal.org/ ]****
-- Steve Kessler****
Owner and Lead Consultant ****
Denver DataMan, LLC ****
303-587-4428****
-- [ Drupal support list | http://lists.drupal.org/ ]****
-- [ Drupal support list | http://lists.drupal.org/ ]