[support] SQL Error After Moving Site

[Metzler, David]

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 at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Rahul Chauhan
Sent: Monday, July 15, 2013 10:25 AM
To: support at 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 at denverdataman.com<mailto:skessler at denverdataman.com>> wrote:
That table does not exist in either database.

On Mon, Jul 15, 2013 at 11:16 AM, Rahul Chauhan <rahulchauhan999 at gmail.com<mailto:rahulchauhan999 at 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 at denverdataman.com<mailto:skessler at 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<tel: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/ ]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130715/27b8e28f/attachment.html