SQL Error After Moving Site
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
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/ ]
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
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/ ]
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<mailto: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<mailto: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<mailto: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<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/ ]
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 ****
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
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.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@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 ****
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
participants (3)
-
Metzler, David -
Rahul Chauhan -
Steve Kessler