[support] SQL Error After Moving Site

[Rahul Chauhan]

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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20130715/d397b9f9/attachment-0001.html