Author Topic: Upgrade to 4.3.1 caused multiple errors and unusable system (Read 10088 times)

Eileen · April 24, 2013, 03:20:12 pm

You probably know this but E-Notice errors are not necessarily a problem.

Michael · April 24, 2013, 05:49:24 pm

I restore the site and then ran through the entire upgrade procedure again from 4.2.9 to 4.3.1 and exactly the same results posted previously with the detailed error. One thing that is either new or I didn't notice it before on the fist upgrade attempt since it was displayed only very briefly was a message saying it was upgrading TO 4.2.9 even though I had already done that successfully a while ago, or at least so I thought. Then it said it was upgrading to an alpha version of 4.3.1 ... alpha? Can this be true?

On the civicrm 'homepage' on our site I get the same lines of green checkmarks in circles and it says "Welcome to CiviCRM 4.3.1" but when I try to search for a member by name it gives this error on the search result page:

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Return to home page.

Any help or suggestions will be appreciated. I can post a list of Drupal modules installed if that helps. We seem to get exactly the same errors and problems whether and additional CiviCRM related modules are enabled or disabled, no difference either way. So, this is repeatable and produces the same results.

Eileen · April 24, 2013, 05:50:24 pm

can you turn debugging on ? if so you should get a backtrace

sonicthoughts · April 24, 2013, 08:58:58 pm

Quote from: Eileen on April 24, 2013, 03:20:12 pm

You probably know this but E-Notice errors are not necessarily a problem.

Yes - but I find that they often lead to some sort of bug (not always of course...). Wonder if we should keep a list of them somewhere?

Eileen · April 24, 2013, 09:02:08 pm

Yeah - I'm just not sure the symptom that you do have.

I can see Michael has a mysql error (& with debugging will be able to say what it is) but not sure your actual error

Michael · April 25, 2013, 07:31:29 am

Hi Eileen,

Many thanks for looking into this. Is this helpful?

Part One:

Executed 165 queries in 257.02 ms. Queries exceeding 5 ms are highlighted. Memory used at: devel_boot()=3.28 MB, devel_shutdown()=41.03 MB, PHP peak=43.5 MB.
ms#whereops
query
target
0.764DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN (:cids_0)
default
6.194DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN (:cids_0)
default
1.074DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN (:cids_0)
default
1.446drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.512menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0) ORDER BY fit DESC LIMIT 0, 1
default
0.111masquerade_initP A E
SELECT uid_from FROM masquerade WHERE sid = :sid AND uid_as = :uid_as
default
0.541DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_path WHERE cid IN (:cids_0)
default
0.111DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_libraries WHERE cid IN (:cids_0)
default
0.5512DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.5712DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
1.3312DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.5440_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.4140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.5340_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.0940_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2740_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.1740_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.2640_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2240_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.3140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.1640_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.051menu_link_get_preferredP A E
SELECT ml.*, m.*, ml.weight AS link_weight FROM menu_links ml LEFT OUTER JOIN menu_router m ON m.path = ml.router_path WHERE (ml.link_path IN (:db_condition_placeholder_0))
default
0.2513DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.177DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.247DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
1.7113DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
7.961_menu_build_treeP A E
SELECT ml.*, m.load_functions AS load_functions, m.to_arg_functions AS to_arg_functions, m.access_callback AS access_callback, m.access_arguments AS access_arguments, m.page_callback AS page_callback, m.page_arguments AS page_arguments, m.delivery_callback AS delivery_callback, m.tab_parent AS tab_parent, m.tab_root AS tab_root, m.title AS title, m.title_callback AS title_callback, m.title_arguments AS title_arguments, m.theme_callback AS theme_callback, m.theme_arguments AS theme_arguments, m.type AS type, m.description AS description FROM menu_links ml LEFT OUTER JOIN menu_router m ON m.path = ml.router_path WHERE (ml.menu_name = :db_condition_placeholder_0) AND (ml.plid IN (:db_condition_placeholder_1, :db_condition_placeholder_2)) ORDER BY p1 ASC, p2 ASC, p3 ASC, p4 ASC, p5 ASC, p6 ASC, p7 ASC, p8 ASC, p9 ASC
default
0.467DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
14.447DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.191_menu_per_role_get_rolesP A E
SELECT mpr.* FROM menu_per_role mpr
default
0.712DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
4.3712DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
3.6640_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.3540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
2.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.8940_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2440_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.3840_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2840_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.1740_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2740_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2240_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.3940_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.5440_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
1.7140_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.340_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.0540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.4640_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.4540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2440_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.5340_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.2540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
8.0540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
0.5540_registry_check_codeP A E
SELECT filename FROM registry WHERE name = :name AND type = :type
default
3.821_block_load_blocksP A E
SELECT b.* FROM block b WHERE (b.theme = :db_condition_placeholder_0) AND (b.status = :db_condition_placeholder_1) ORDER BY b.region ASC, b.weight ASC, b.module ASC
default
0.131block_block_list_alterP A E
SELECT module, delta, rid FROM block_role
default
2.271node_block_list_alterP A E
SELECT module, delta, type FROM block_node_type
default
1.6413DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
1.2313DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.161menu_tree_page_dataP A E
SELECT menu_links.mlid AS mlid FROM menu_links menu_links WHERE (menu_name = :db_condition_placeholder_0) AND (expanded = :db_condition_placeholder_1) AND (has_children = :db_condition_placeholder_2) AND (plid IN (:db_condition_placeholder_3)) AND (mlid NOT IN (:db_condition_placeholder_4))
default
0.337DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.537DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.6213DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
35.651DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_token WHERE cid IN (:cids_0)
default
13.3312DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
4.7112DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.221DrupalDefaultEntityController::loadP A E
SELECT base.uid AS uid, base.name AS name, base.pass AS pass, base.mail AS mail, base.theme AS theme, base.signature AS signature, base.signature_format AS signature_format, base.created AS created, base.access AS access, base.login AS login, base.status AS status, base.timezone AS timezone, base.language AS language, base.picture AS picture, base.init AS init, base.data AS data FROM users base WHERE (base.uid IN (:db_condition_placeholder_0))
default
0.081UserController::attachLoadP A E
SELECT r.rid, r.name, ur.uid FROM role r INNER JOIN users_roles ur ON ur.rid = r.rid WHERE ur.uid IN (:uids_0)
default
0.082DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN (:cids_0)
default
0.782DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_field WHERE cid IN (:cids_0)
default

Michael · April 25, 2013, 07:31:57 am

Part Two

2.91field_read_fieldsP A E
SELECT fc.* FROM field_config fc INNER JOIN field_config_instance fci ON fc.id = fci.field_id WHERE (fci.entity_type = :db_condition_placeholder_0) AND (fci.bundle = :db_condition_placeholder_1) AND (fc.active = :db_condition_placeholder_2) AND (fc.storage_active = :db_condition_placeholder_3) AND (fc.deleted = :db_condition_placeholder_4)
default
0.731field_read_instancesP A E
SELECT fci.* FROM field_config_instance fci INNER JOIN field_config fc ON fc.id = fci.field_id WHERE (fci.entity_type = :db_condition_placeholder_0) AND (fci.bundle = :db_condition_placeholder_1) AND (fc.active = :db_condition_placeholder_2) AND (fc.storage_active = :db_condition_placeholder_3) AND (fc.deleted = :db_condition_placeholder_4) AND (fci.deleted = :db_condition_placeholder_5)
default
0.21DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_field cache_field WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.261DrupalDatabaseCache::setP A
INSERT INTO cache_field (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.7412DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
7.061flag_get_flagsP A E
SELECT f.fid AS fid, f.entity_type AS entity_type, f.name AS name, f.title AS title, f.global AS global, f.options AS options, fn.type AS type FROM flag f LEFT OUTER JOIN flag_types fn ON fn.fid = f.fid
default
4.5712DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.136drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.112menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6) ORDER BY fit DESC LIMIT 0, 1
default
10.236drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.131menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2) ORDER BY fit DESC LIMIT 0, 1
default
0.1312drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.076drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.126drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.12menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0) ORDER BY fit DESC LIMIT 0, 1
default
3.9313DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.427DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.377DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
1.2913DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.241menu_tree_check_accessP A E
SELECT n.nid AS nid FROM node n WHERE (n.status = :db_condition_placeholder_0) AND (n.nid IN (:db_condition_placeholder_1, :db_condition_placeholder_2, :db_condition_placeholder_3, :db_condition_placeholder_4, :db_condition_placeholder_5))
default
0.246drupal_lookup_pathP A E
SELECT source FROM url_alias WHERE alias = :alias AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.122menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6) ORDER BY fit DESC LIMIT 0, 1
default
0.174block_block_viewP A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
0.6812DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.974DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_filter WHERE cid IN (:cids_0)
default
0.084block_block_viewP A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
0.274DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_filter WHERE cid IN (:cids_0)
default
0.084block_block_viewP A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
0.324DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_filter WHERE cid IN (:cids_0)
default
0.5613DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.217DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.377DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.2913DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.091menu_tree_check_accessP A E
SELECT n.nid AS nid FROM node n WHERE (n.status = :db_condition_placeholder_0) AND (n.nid IN (:db_condition_placeholder_1))
default
0.354DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_bootstrap WHERE cid IN (:cids_0)
default
0.214block_block_viewP A E
SELECT body, format FROM block_custom WHERE bid = :bid
default
0.194DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_filter WHERE cid IN (:cids_0)
default
14.8412DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.291DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_filter cache_filter WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.311DrupalDatabaseCache::setP A
INSERT INTO cache_filter (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.761menu_local_tasksP A E
SELECT menu_router.* FROM menu_router menu_router WHERE (tab_root = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) ORDER BY weight ASC, title ASC
default
0.281context_reaction_block::get_blocksP A E
SELECT block.* FROM block block WHERE (theme = :db_condition_placeholder_0)
default
0.171DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_admin_menu WHERE cid IN (:cids_0)
default
0.831admin_menu_session_countP A E
SELECT COUNT(sid) AS count FROM sessions sessions WHERE (timestamp >= :db_condition_placeholder_0) AND (uid = :db_condition_placeholder_1)
default
0.311admin_menu_session_countP A E
SELECT COUNT(sid) AS count FROM sessions sessions WHERE (timestamp >= :db_condition_placeholder_0) AND (uid > :db_condition_placeholder_1)
default
14.513DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.357DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.297DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.3513DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
2.191EntityAPIController::queryP A E
SELECT base.id AS id, base.type AS type, base.label AS label, base.weight AS weight, base.data AS data, base.status AS status, base.module AS module FROM profile_type base WHERE (base.type IN (:db_condition_placeholder_0))
default
6.7112DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache WHERE cid IN (:cids_0)
default
0.2412drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.6813DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.237DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_menu cache_menu WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.447DrupalDatabaseCache::setP A
INSERT INTO cache_menu (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
1.7413DrupalDatabaseCache::getMultipleP A E
SELECT cid, data, created, expire, serialized FROM cache_menu WHERE cid IN (:cids_0)
default
0.212drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.143menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22) ORDER BY fit DESC LIMIT 0, 1
default
0.12menu_contextual_linksP A E
SELECT m.* FROM menu_router m WHERE (tab_parent = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) AND (context <> :db_condition_placeholder_2) ORDER BY weight ASC, title ASC
default
0.146menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.112menu_contextual_linksP A E
SELECT m.* FROM menu_router m WHERE (tab_parent = :db_condition_placeholder_0) AND (context <> :db_condition_placeholder_1) AND (context <> :db_condition_placeholder_2) ORDER BY weight ASC, title ASC
default
0.1212drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.0712drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
19.943menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22) ORDER BY fit DESC LIMIT 0, 1
default
0.216menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.166menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.146menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.166menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.0812drupal_lookup_pathP A E
SELECT alias FROM url_alias WHERE source = :source AND language IN (:language, :language_none) ORDER BY language ASC, pid DESC
default
0.123menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22) ORDER BY fit DESC LIMIT 0, 1
default
0.146menu_get_itemP A E
SELECT * FROM menu_router WHERE path IN (:ancestors_0, :ancestors_1, :ancestors_2, :ancestors_3, :ancestors_4, :ancestors_5, :ancestors_6, :ancestors_7, :ancestors_8, :ancestors_9, :ancestors_10, :ancestors_11, :ancestors_12, :ancestors_13, :ancestors_14, :ancestors_15, :ancestors_16, :ancestors_17, :ancestors_18, :ancestors_19, :ancestors_20, :ancestors_21, :ancestors_22, :ancestors_23, :ancestors_24, :ancestors_25, :ancestors_26, :ancestors_27, :ancestors_28, :ancestors_29, :ancestors_30, :ancestors_31, :ancestors_32) ORDER BY fit DESC LIMIT 0, 1
default
0.481variable_setP A
SELECT 1 AS expression FROM variable variable WHERE ( (name = :db_condition_placeholder_0) ) FOR UPDATE
default
0.81variable_setP A
UPDATE variable SET value=:db_update_placeholder_0 WHERE ( (name = :db_condition_placeholder_0) )
default
0.811DrupalDatabaseCache::clearP A
DELETE FROM cache_bootstrap WHERE (cid = :db_condition_placeholder_0)
default
0.622DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_bootstrap cache_bootstrap WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
1.172DrupalDatabaseCache::setP A
UPDATE cache_bootstrap SET serialized=:db_update_placeholder_0, created=:db_update_placeholder_1, expire=:db_update_placeholder_2, data=:db_update_placeholder_3 WHERE ( (cid = :db_condition_placeholder_0) )
default
0.231DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_path cache_path WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
0.221DrupalDatabaseCache::setP A
INSERT INTO cache_path (cid, serialized, created, expire, data) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4)
default
0.222DrupalDatabaseCache::setP A
SELECT 1 AS expression FROM cache_bootstrap cache_bootstrap WHERE ( (cid = :db_condition_placeholder_0) ) FOR UPDATE
default
1.282DrupalDatabaseCache::setP A
UPDATE cache_bootstrap SET serialized=:db_update_placeholder_0, created=:db_update_placeholder_1, expire=:db_update_placeholder_2, data=:db_update_placeholder_3 WHERE ( (cid = :db_condition_placeholder_0) )
default
0.291lock_release_allP A
DELETE FROM semaphore WHERE (value = :db_condition_placeholder_0)

Eileen · April 25, 2013, 01:41:06 pm

What we need is backtrace turned on - e.g. a screen like this

http://drupal.demo.civicrm.org/civicrm/admin/setting/debug?reset=1

If you can't get to that then add this

define( 'CIVICRM_DEBUG_LOG_QUERY', 'backtrace' );

to civicrm.settings.php & look for the output in files/civicrm/ConfigAndLog (or similar - from templates_c it's ../ConfigAndLog

Michael · April 25, 2013, 02:28:24 pm

Thank you. Okay I turned it on and one of the things displayed is:

Database check failed - the database looks to have been partially upgraded. You may want to reload the database with the backup and try the upgrade process again.

(I had already done that but it failed and resulted in the current state)

The ConfigAndLog file is attached.

Many thanks for looking at it!

Eileen · April 25, 2013, 02:30:19 pm

OK - so when you re-started did you you drop your database (or at least all the CiviCRM tables) before restarting?

When you reload your database it will drop & create tables in the back-up but not ones created since, so the upgrade will fail when it tries to create them

Michael · April 25, 2013, 02:34:27 pm

Yes, both upgrade attempts I dropped all the tables before starting. At least I think I did through phpMy Admin. (Unless I somehow missed page two of the tables but I know for sure I did on the most recent attempt.) Absolutely for sure I dropped them all on that attempt.

I followed all the instructions exactly and in sequence.

Eileen · April 25, 2013, 02:52:16 pm

Does the upgrade always fail on this

* ERROR USERINFO: ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 [nativecode=1025 ** Error on rename of './vmgdev_tr99xl1/civicrm_financial_trxn' to './vmgdev_tr99xl1/#sql2-3752-468f18' (errno: 152)]
* ERROR DEBUGINFO: ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 [nativecode=1025 ** Error on rename of './vmgdev_tr99xl1/civicrm_financial_trxn' to './vmgdev_tr99xl1/#sql2-3752-468f18' (errno: 152)]

I realise why that looks familiar - I hit something related & noted it back in November - but in discussions around that time it was clear that I shouldn't be trying to test / use the upgrade script on trunk at that point in time so I dismantled my client data on trunk set-up & reconfigured my machine to use the same data set on trunk as everyone else (sadly that was only a week before Pradeep did turn his attention to it but I'd completely changed my set-up in between).

http://issues.civicrm.org/jira/browse/CRM-11260?focusedCommentId=46652&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-46652

However, the bug is slightly different - can you determine the names of the foreign keys on this table?

civicrm_financial_trxn

Michael · April 25, 2013, 03:57:40 pm

Yes, that's exactly the place it fails.

In the Action column for that table in phpMyAdmin it has all keys listed as primary. At Hershel's suggestion I tried adding the missing foreign key to the table and then running the upgrade but that too failed.

Eileen · April 25, 2013, 04:29:48 pm

So, to put it simply, you either need to get your DB to a state where

ALTER TABLE civicrm_financial_trxn DROP FOREIGN KEY civicrm_financial_trxn_ibfk_2 ;

works when run in mysql before you upgrade, or comment that line out of the upgrade script

Michael · April 25, 2013, 05:26:13 pm

Thank you. I don't quite understand though ... this table is the default table from CiviCRM version 4.XX (we've done each upgrade as they were released) and I don't think we even use that table in our application. So, I'm unclear as to why, if it is a default, that it would fail and need special attention. (Not complaining at all, just trying to understand.)

When the upgrade tries to alter the table civicrm_financial_trxn I can see it's failing because the foreign key doesn't exist ... but why is it looking for something non-existent (at least in this case)? Would it be more likely to upgrade properly if I create the foreign key in the table (That is what you are suggesting? I'm just not clear, it's not you ... it's me!.)

Alternatively, I am willing to try and comment the line out of the upgrade script if you can tell me where to find it (which would be appreciated) but, if that approach is taken, are we asking for problems down the road with future upgrades?

I would prefer to take the path that is most-future-proof if possible.

Many thanks, your time and help are appreciated.

CiviCRM Community Forums (archive)

News:

Author Topic: Upgrade to 4.3.1 caused multiple errors and unusable system (Read 10088 times)

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

sonicthoughts

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Eileen

Re: Upgrade to 4.3.1 caused multiple errors and unusable system

Michael

Re: Upgrade to 4.3.1 caused multiple errors and unusable system