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
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.comwrote:
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/ ]
That table does not exist in either database.
On Mon, Jul 15, 2013 at 11:16 AM, Rahul Chauhan rahulchauhan999@gmail.comwrote:
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/ ]
Check you old database backup for the same table.
On Mon, Jul 15, 2013 at 10:50 PM, Steve Kessler skessler@denverdataman.comwrote:
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/ ]
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.commailto: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.commailto: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.commailto: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-4428tel: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/ ]
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/ ]
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@denverdataman.comwrote:
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/ ]
-- Steve Kessler Owner and Lead Consultant Denver DataMan, LLC 303-587-4428
-
Metzler, David -
Rahul Chauhan -
Steve Kessler