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.edu> wrote:

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 

 

--
[ Drupal support list | http://lists.drupal.org/ ]

 


--
[ Drupal support list | http://lists.drupal.org/ ]



 

--
Steve Kessler

Owner and Lead Consultant 

Denver DataMan, LLC 


--
[ 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