Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Cannot Reproduce
-
Affects Version/s: 4.4.4
-
Fix Version/s: None
-
Component/s: Core CiviCRM
-
Labels:
Description
After upgrading to 4.4.4 from 4.2, I get a Drupal database error
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'alsd_drupal.field_data_field_email' doesn't exist
It doesn't exist in the updated tables, but it did not exist prior, either.
The full log message is:
**ERROR**
Array
(
[type] => 32
[message] => PHP Startup: Unable to load dynamic library
'/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so' -
/usr/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so: cannot
open shared object file: No such file or directory
[file] => Unknown
[line] => 0
)
Array
(
[message] => SQLSTATE[42S02]: Base table or view not found: 1146 Table
'alsd_drupal.field_data_field_email' doesn't exist
[code] =>
[exception] => PDOException Object
(
[message:protected] => SQLSTATE[42S02]: Base table or view not
found: 1146 Table 'alsd_drupal.field_data_field_email' doesn't exist
[string:Exception:private] =>
[code:protected] => 42S02
file:protected =>
/home/alsd/www/www/includes/database/database.inc
[line:protected] => 2168
[trace:Exception:private] => Array
(
[0] => Array
(
[file] =>
/home/alsd/www/www/includes/database/database.inc
[line] => 2168
[function] => execute
[class] => PDOStatement
[type] => ->
[args] => Array
(
[0] => Array
(
[:db_update_placeholder_0] =>
15067
[:db_condition_placeholder_0] =>
23555
)
)
)
[1] => Array
(
[file] =>
/home/alsd/www/www/includes/database/database.inc
[line] => 680
[function] => execute
[class] => DatabaseStatementBase
[type] => ->
[args] => Array
(
[0] => Array
(
[:db_update_placeholder_0] =>
15067
[:db_condition_placeholder_0] =>
23555
)
[1] => Array
(
[target] => default
[return] => 2
[fetch] => 5
[throw_exception] => 1
)
)
)
[2] => Array
(
[file] =>
/home/alsd/www/www/includes/database/query.inc
[line] => 1177
[function] => query
[class] => DatabaseConnection
[type] => ->
[args] => Array
(
[0] => UPDATE
SET field_email_contact_id=:db_update_placeholder_0
WHERE (field_email_contact_id = :db_condition_placeholder_0)
[1] => Array
(
[:db_update_placeholder_0] =>
15067
[:db_condition_placeholder_0] =>
23555
)
[2] => Array
(
[target] => default
[return] => 2
)
)
)
[3] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/drupal/modules/civicrm_contact_ref/civicrm_contact_ref.module
[line] => 464
[function] => execute
[class] => UpdateQuery
[type] => ->
[args] => Array
(
)
)
[4] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Utils/Hook.php
[line] => 164
[function] => civicrm_contact_ref_civicrm_merge
[args] => Array
(
[0] => sqls
[1] => Array
(
[0] => UPDATE IGNORE
civicrm_acl_cache SET contact_id = 15067 WHERE contact_id = 23555
[1] => DELETE FROM
civicrm_acl_cache WHERE contact_id = 23555
[2] => UPDATE IGNORE
civicrm_contact SET primary_contact_id = 15067 WHERE primary_contact_id =
23555
[3] => DELETE FROM
civicrm_contact WHERE primary_contact_id = 23555
[4] => UPDATE IGNORE
civicrm_group_organization SET organization_id = 15067 WHERE organization_id
= 23555
[5] => DELETE FROM
civicrm_group_organization WHERE organization_id = 23555
[6] => UPDATE IGNORE civicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[7] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[8] => UPDATE IGNORE civicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[9] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[10] => UPDATE IGNOREcivicrm_acl
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[11] => DELETE FROM civicrm_acl
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[12] => UPDATE IGNORE
civicrm_acl_entity_role SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[13] => DELETE FROM
civicrm_acl_entity_role WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[14] => UPDATE IGNORE
civicrm_entity_file SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[15] => DELETE FROM
civicrm_entity_file WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[16] => UPDATE IGNOREcivicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[17] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[18] => UPDATE IGNOREcivicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[19] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[20] => UPDATE IGNORE
civicrm_mailing_group SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[21] => DELETE FROM
civicrm_mailing_group WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
)
[2] => 15067
[3] => 23555
[4] =>
)
)
[5] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Utils/Hook/Drupal.php
[line] => 67
[function] => runHooks
[class] => CRM_Utils_Hook
[type] => ->
[args] => Array
(
[0] => Array
(
[block] => block
[popup_ui] => popup_ui
[webform] => webform
[addtoany] => addtoany
[advanced_help] => advanced_help
[aggregator] => aggregator
[ayah] => ayah
[bulk_export] => bulk_export
[charts] => charts
[charts_google] => charts_google
[civicrm_contact_ref] =>
civicrm_contact_ref
[civicrm_error] => civicrm_error
[ckeditor] => ckeditor
[color] => color
[comment] => comment
[content_access] =>
content_access
[contextual] => contextual
[countdown] => countdown
[cpn] => cpn
[ctools] => ctools
[ctools_custom_content] =>
ctools_custom_content
[custom_formatters] =>
custom_formatters
[date_api] => date_api
[date_views] => date_views
[dblog] => dblog
[entity] => entity
[entity_token] => entity_token
[feeds] => feeds
[feeds_import] => feeds_import
[feeds_news] => feeds_news
[feeds_ui] => feeds_ui
[feed_import] => feed_import
[field] => field
[field_sql_storage] =>
field_sql_storage
[field_ui] => field_ui
[file] => file
[file_entity] => file_entity
[filter] => filter
[flexslider] => flexslider
[flexslider_fields] =>
flexslider_fields
[flexslider_views] =>
flexslider_views
[fontyourface] => fontyourface
[fontyourface_ui] =>
fontyourface_ui
[googleanalytics] =>
googleanalytics
[help] => help
[httpbl] => httpbl
[image] => image
[jcarousel] => jcarousel
[job_scheduler] => job_scheduler
[less] => less
[libraries] => libraries
[list] => list
[media] => media
[media_gallery] => media_gallery
[media_internet] =>
media_internet
[menu] => menu
[menu_block] => menu_block
[multiform] => multiform
[node] => node
[nodequeue] => nodequeue
[number] => number
[options] => options
[panels] => panels
[panels_mini] => panels_mini
[path] => path
[php] => php
[plupload] => plupload
[popup] => popup
[popup_block] => popup_block
[popup_descriptions] =>
popup_descriptions
[popup_filter] => popup_filter
[popup_menu] => popup_menu
[quicktabs] => quicktabs
[quicktabs_tabstyles] =>
quicktabs_tabstyles
[rdf] => rdf
[redirect] => redirect
[role_theme_switcher] =>
role_theme_switcher
[search] => search
[shortcut] => shortcut
[smartqueue] => smartqueue
[stylizer] => stylizer
[superfish] => superfish
[syslog] => syslog
[system] => system
[taxonomy] => taxonomy
[text] => text
[toolbar] => toolbar
[update] => update
[user] => user
[uuid] => uuid
[variablecheck] => variablecheck
[views_bootstrap] =>
views_bootstrap
[views_bulk_operations] =>
views_bulk_operations
[views_content] => views_content
[views_slideshow] =>
views_slideshow
[views_slideshow_cycle] =>
views_slideshow_cycle
[views_ui] => views_ui
[xmlsitemap_custom] =>
xmlsitemap_custom
[xmlsitemap_menu] =>
xmlsitemap_menu
[youtube] => youtube
[google_fonts_api] =>
google_fonts_api
[pathauto] => pathauto
[xmlsitemap] => xmlsitemap
[xmlsitemap_engines] =>
xmlsitemap_engines
[xmlsitemap_node] =>
xmlsitemap_node
[token] => token
[views] => views
[xmlsitemap_taxonomy] =>
xmlsitemap_taxonomy
[panels_node] => panels_node
[admin_views] => admin_views
[features] => features
[field_permissions] =>
field_permissions
[jquery_update] => jquery_update
[page_manager] => page_manager
[civicrm] => civicrm
[stripe] => stripe
[sendeventconf] => sendeventconf
[civicrmtheme] => civicrmtheme
[standard] => standard
)
[1] => civicrm_merge
[2] => 5
[3] => sqls
[4] => Array
(
[0] => UPDATE IGNORE
civicrm_acl_cache SET contact_id = 15067 WHERE contact_id = 23555
[1] => DELETE FROM
civicrm_acl_cache WHERE contact_id = 23555
[2] => UPDATE IGNORE
civicrm_contact SET primary_contact_id = 15067 WHERE primary_contact_id =
23555
[3] => DELETE FROM
civicrm_contact WHERE primary_contact_id = 23555
[4] => UPDATE IGNORE
civicrm_group_organization SET organization_id = 15067 WHERE organization_id
= 23555
[5] => DELETE FROM
civicrm_group_organization WHERE organization_id = 23555
[6] => UPDATE IGNORE civicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[7] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[8] => UPDATE IGNORE civicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[9] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[10] => UPDATE IGNOREcivicrm_acl
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[11] => DELETE FROM civicrm_acl
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[12] => UPDATE IGNORE
civicrm_acl_entity_role SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[13] => DELETE FROM
civicrm_acl_entity_role WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[14] => UPDATE IGNORE
civicrm_entity_file SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[15] => DELETE FROM
civicrm_entity_file WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[16] => UPDATE IGNOREcivicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[17] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[18] => UPDATE IGNOREcivicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[19] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[20] => UPDATE IGNORE
civicrm_mailing_group SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[21] => DELETE FROM
civicrm_mailing_group WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
)
[5] => 15067
[6] => 23555
[7] =>
)
)
[6] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Utils/Hook.php
[line] => 824
[function] => invoke
[class] => CRM_Utils_Hook_Drupal
[type] => ->
[args] => Array
(
[0] => 5
[1] => sqls
[2] => Array
(
[0] => UPDATE IGNORE
civicrm_acl_cache SET contact_id = 15067 WHERE contact_id = 23555
[1] => DELETE FROM
civicrm_acl_cache WHERE contact_id = 23555
[2] => UPDATE IGNORE
civicrm_contact SET primary_contact_id = 15067 WHERE primary_contact_id =
23555
[3] => DELETE FROM
civicrm_contact WHERE primary_contact_id = 23555
[4] => UPDATE IGNORE
civicrm_group_organization SET organization_id = 15067 WHERE organization_id
= 23555
[5] => DELETE FROM
civicrm_group_organization WHERE organization_id = 23555
[6] => UPDATE IGNORE civicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[7] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[8] => UPDATE IGNORE civicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[9] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[10] => UPDATE IGNOREcivicrm_acl
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[11] => DELETE FROM civicrm_acl
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[12] => UPDATE IGNORE
civicrm_acl_entity_role SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[13] => DELETE FROM
civicrm_acl_entity_role WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[14] => UPDATE IGNORE
civicrm_entity_file SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[15] => DELETE FROM
civicrm_entity_file WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[16] => UPDATE IGNOREcivicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[17] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[18] => UPDATE IGNOREcivicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[19] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[20] => UPDATE IGNORE
civicrm_mailing_group SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[21] => DELETE FROM
civicrm_mailing_group WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
)
[3] => 15067
[4] => 23555
[5] =>
[6] => civicrm_merge
)
)
[7] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Dedupe/Merger.php
[line] => 499
[function] => merge
[class] => CRM_Utils_Hook
[type] => ::
[args] => Array
(
[0] => sqls
[1] => Array
(
[0] => UPDATE IGNORE
civicrm_acl_cache SET contact_id = 15067 WHERE contact_id = 23555
[1] => DELETE FROM
civicrm_acl_cache WHERE contact_id = 23555
[2] => UPDATE IGNORE
civicrm_contact SET primary_contact_id = 15067 WHERE primary_contact_id =
23555
[3] => DELETE FROM
civicrm_contact WHERE primary_contact_id = 23555
[4] => UPDATE IGNORE
civicrm_group_organization SET organization_id = 15067 WHERE organization_id
= 23555
[5] => DELETE FROM
civicrm_group_organization WHERE organization_id = 23555
[6] => UPDATE IGNORE civicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[7] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[8] => UPDATE IGNORE civicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[9] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[10] => UPDATE IGNOREcivicrm_acl
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[11] => DELETE FROM civicrm_acl
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[12] => UPDATE IGNORE
civicrm_acl_entity_role SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[13] => DELETE FROM
civicrm_acl_entity_role WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[14] => UPDATE IGNORE
civicrm_entity_file SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[15] => DELETE FROM
civicrm_entity_file WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[16] => UPDATE IGNOREcivicrm_log
SET modified_id = 15067 WHERE modified_id = 23555
[17] => DELETE FROM civicrm_log
WHERE modified_id = 23555
[18] => UPDATE IGNOREcivicrm_log
SET entity_id = 15067 WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
[19] => DELETE FROM civicrm_log
WHERE entity_id = 23555 AND entity_table = 'civicrm_contact'
[20] => UPDATE IGNORE
civicrm_mailing_group SET entity_id = 15067 WHERE entity_id = 23555 AND
entity_table = 'civicrm_contact'
[21] => DELETE FROM
civicrm_mailing_group WHERE entity_id = 23555 AND entity_table =
'civicrm_contact'
)
[2] => 15067
[3] => 23555
[4] =>
)
)
[8] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Dedupe/Merger.php
[line] => 1307
[function] => moveContactBelongings
[class] => CRM_Dedupe_Merger
[type] => ::
[args] => Array
(
[0] => 15067
[1] => 23555
)
)
[9] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Contact/Form/Merge.php
[line] => 326
[function] => moveAllBelongings
[class] => CRM_Dedupe_Merger
[type] => ::
[args] => Array
(
[0] => 15067
[1] => 23555
[2] => Array
(
[move_job_title] =>
[move_location_email_1] =>
[location] => Array
(
[email] => Array
(
[1] => Array
(
[locTypeId] => 2
[operation] => 1
)
)
)
[move_custom_2] => NHL
[move_rel_table_activities] => 1
[move_rel_table_groups] => 1
[move_rel_table_mailings] => 1
[qfKey] =>
a3119b3f43bc64abd83e495504fa556c_9267
[entryURL] =>
https://alsd.com/civicrm/contact/merge?reset=1&cid=15067&oid=23555
[_qf_default] => Merge:next
[_qf_Merge_next] => Merge
[other_details] => Array
(
[loc_block_ids] => Array
(
[email] => Array
(
[1] =>
19558
)
)
)
[main_details] => Array
(
[contact_type] =>
Individual
[loc_block_ids] => Array
(
[email] => Array
(
[2] =>
12819
)
)
)
)
)
)
[10] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Core/Form.php
[line] => 261
[function] => postProcess
[class] => CRM_Contact_Form_Merge
[type] => ->
[args] => Array
(
)
)
[11] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Core/StateMachine.php
[line] => 160
[function] => mainProcess
[class] => CRM_Core_Form
[type] => ->
[args] => Array
(
)
)
[12] => Array
(
[file] =>
/home/alsd/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php
[line] => 60
[function] => perform
[class] => CRM_Core_StateMachine
[type] => ->
[args] => Array
(
[0] => CRM_Contact_Form_Merge Object
(
[_cid] => 15067
[_oid] => 23555
[_contactType] => Individual
[_locBlockIds:protected] =>Array
(
[main] => Array
(
[email] => Array
(
[2] =>
12819
)
)
[other] => Array
(
[email] => Array
(
[1] =>
19558
)
)
)
[_qfZeroBug] =>
e8cddb72-a257-11dc-b9cc-0016d3330ee9
[_state:protected] =>
[_name:protected] => Merge
[_title:protected] =>
[_options:protected] =>
[_action:protected] => 0
[_renderer:protected] =>
[_dateFields:protected] => Array
(
)
[_actions] => Array
(
)
[controller] =>
CRM_Core_Controller_Simple Object
(
[_title:protected] =>
Merge Contact
[_key] =>
a3119b3f43bc64abd83e495504fa556c_9267
[_scope:protected] =>
CRM_Contact_Form_Merge_a3119b3f43bc64abd83e495504fa556c_9267
[_stateMachine:protected]
=> CRM_Core_StateMachine Object
(
[_controller:protected] => CRM_Core_Controller_Simple Object
RECURSION
[_states:protected] => Array
(
[Merge]
=> CRM_Core_State Object
(
[_name:protected] => Merge
[_type:protected] => 3
[_back:protected] =>
[_next:protected] =>
[_stateMachine:protected] => CRM_Core_StateMachine Object
RECURSION
)
)
[_pages:protected] => Array
(
[CRM_Contact_Form_Merge] =>
)
[_pageNames:protected] => Array
(
[0] =>
Merge
)
[_action:protected] => 0
[_name:protected]
=>
)
[_embedded:protected] =>
[_skipRedirection:protected] =>
[_print] => 0
[_generateQFKey] => 1
[_QFResponseType] =>html
[_parent:protected] =>
[_destination] =>
[_entryURL] =>
https://alsd.com/civicrm/contact/merge?reset=1&cid=15067&oid=23555
[_pages] => Array
(
[Merge] =>
CRM_Contact_Form_Merge Object
RECURSION
)
[_actions] => Array
(
[Merge] =>
HTML_QuickForm_Action_Direct Object
(
)
[display] =>
CRM_Core_QuickForm_Action_Display Object
(
[_stateMachine:protected] => CRM_Core_StateMachine Object