[support] SQL Error After Moving Site

[Steve Kessler]

I have done a Drupal update and it resolved the problem. I still have no
idea what happened.

Thanks,
Steve


On Mon, Jul 15, 2013 at 12:40 PM, Steve Kessler
<skessler at denverdataman.com>wrote:

> 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 at 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 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> wrote:****
>>
>> That table does not exist in either database.****
>>
>> ** **
>>
>> On Mon, Jul 15, 2013 at 11:16 AM, Rahul Chauhan <
>> 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> 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/ ]
>>
>
>
>
> --
> Steve Kessler
> Owner and Lead Consultant
> Denver DataMan, LLC
> 303-587-4428
>



-- 
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/e7e885a5/attachment-0001.html