CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade to 4.3.1 caused multiple errors and unusable system
Pages: 1 2 [3] 4

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

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 25, 2013, 05:32:05 pm
This may be off base, but I made a mistake that lead to upgrade errors:
1. created a mysqldump of civi database to file (ie >mysqldump-out.sql)
2. tried to install - problems
3. ran mysql < mysqldump-out.sql

Everything looked fine, but when I tried to upgrade it failed.  The mysqldump does not delete the tables or keys or other things created by the upgrade.  The upgrade uses those tables, etc. to determine the version. This is known as a partial upgrade state and it is messy.  If this is your situation, you might want to look for a tool that compares data structures and delete the tables, indices, etc.

You have to drop everything or recreate the database before you run the restore.

NOTE: This did not address my upgrade - still stuck  :-[
« Last Edit: April 25, 2013, 06:15:14 pm by sonicthoughts »

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 25, 2013, 06:09:44 pm
If you do mysql command

SHOW CREATE TABLE civicrm_financial_trxn;

What is the output?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 26, 2013, 07:13:03 am
I hear you sonicthoughts, that does seem to be exactly what's going on. That's why I cleared everything out and tried the upgrade a couple of times from fresh.

Eileen, I did what you asked and the result is:


Table
Create Table
civicrm_financial_trxn
CREATE TABLE `civicrm_financial_trxn` (
 `id` int...

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 26, 2013, 10:05:38 am
It's getting more interesting ... when I reloaded the civicrm dashboard page: /civicrm/user?reset=1

... I now get a different error regarding a "discount" field as per below (bolded). This is another field we've never used and it has no data stored:

/civicrm/user?reset=1 

backTrace

#0 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#4 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#5 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...", "DB_Error", TRUE)
#6 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'discount.price_set_id' in 'on clause'")
#7 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#9 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#10 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#11 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#12 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(959): CRM_Core_DAO->query("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...", TRUE)
#13 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Contact/BAO/Query.php(4258): CRM_Core_DAO::singleValueQuery("SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contac...")
#14 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Event/Selector/Search.php(293): CRM_Contact_BAO_Query->searchQuery(0, 0, NULL, TRUE, FALSE, FALSE, FALSE, FALSE, NULL)
#15 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Selector/Controller.php(233): CRM_Event_Selector_Search->getTotalCount(4, NULL)
#16 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Event/Form/Search.php(445): CRM_Core_Selector_Controller->__construct(Object(CRM_Event_Selector_Search), NULL, NULL, 4, Object(CRM_Event_Form_Search), 1, "event_")
#17 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Event/Form/Search.php(187): CRM_Event_Form_Search->postProcess()
#18 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Form.php(336): CRM_Event_Form_Search->preProcess()
#19 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(93): CRM_Core_Form->buildForm()
#20 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Event_Form_Search), "display")
#21 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Event_Form_Search), "display")
#22 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Controller.php(316): HTML_QuickForm_Page->handle("display")
#23 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Event/Page/UserDashboard.php(60): CRM_Core_Controller->run()
#24 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Event/Page/UserDashboard.php(72): CRM_Event_Page_UserDashboard->listParticipations()
#25 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Contact/Page/View/UserDashBoard.php(143): CRM_Event_Page_UserDashboard->run()
#26 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Contact/Page/View/UserDashBoard.php(208): CRM_Contact_Page_View_UserDashBoard->buildUserDashBoard()
#27 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(292): CRM_Contact_Page_View_UserDashBoard->run((Array:2), NULL)
#28 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:14))
#29 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#30 /home/vmgdev/www/www/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:2))
#31 [internal function](): civicrm_invoke("user")
#32 /home/vmgdev/www/www/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1))
#33 /home/vmgdev/www/www/index.php(21): menu_execute_active_handler()
#34 {main}
Sorry but we are not able to provide this at the moment.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'discount.price_set_id' in 'on clause', 1054
Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.price_set_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 2218 )  AND (contact_a.is_deleted = 0)     [nativecode=1054 ** Unknown column 'discount.price_set_id' in 'on clause']
    [type] => DB_Error
    [user_info] => SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.price_set_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 2218 )  AND (contact_a.is_deleted = 0)     [nativecode=1054 ** Unknown column 'discount.price_set_id' in 'on clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT count( DISTINCT  civicrm_participant.id )  FROM civicrm_contact contact_a LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_contact' AND
                                                        contact_a.id = civicrm_note.entity_id )  LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id  INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id  LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id )  LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.price_set_id )  LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
                               AND option_group_participant_role.id = participant_role.option_group_id )  LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id)  WHERE  ( contact_a.id = 2218 )  AND (contact_a.is_deleted = 0)     [nativecode=1054 ** Unknown column 'discount.price_set_id' in 'on clause']"]
)
Return to home page.

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 26, 2013, 04:24:48 pm
I tried again but this time I created the missing foreign key to the civicrm_financial_trxn table before trying the upgrade since that is what seemed to be missing and causing the error. I added this index:

FK_civicrm_financial_trxn_ibfk_2

... but the error after the failed upgrade is exactly the same. I had tried adding the index previously without the FK_ prefix to: civicrm_financial_trxn_ibfk_2 ... but, the results were also identical. We are using entities in Drupal, if that makes a difference.

The database has never been customized or altered from the default CiviCRM installation. There is only one DB on the site and it is the original Drupal DB with the fields installing CiviCRM added to it plus a couple of tables that are used by Drupal and have nothing to do with CiviCRM.

I will try just about anything anyone cares to suggest ... with much hope and gratitude.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 28, 2013, 08:03:48 pm
So, to clarify - the update did fail part way through again? & the version in the civicrm_domain table is not showing 4.3.1?
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 29, 2013, 06:59:56 am
Hi Eileen,

Yes, the version in civcrm_domain says: 4.3.alpha1.upgrade

This is also the version reported in the footer and in the welcome message, although there's no reference to "alpha" in those two places. The older databases backups I have been trying to upgrade from have some tables that seem to have been added by the upgrade process with names such as "field_deleted_data_116" ... are these created by the upgrade process? Should they be deleted automatically at the end of the upgrade process? I don't remember seeing them in the db before. Can I safely delete them?

We started with an earlier version of 4.2 and have been doing every upgrade as it was released for the last five or six months. Is it possible there are artifacts from a previous upgrade that may be causing problems? Do I need to go back to a DB backup that doesn't have these "field_deleted_data_116" tables in it?

Many Thanks

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 29, 2013, 02:37:03 pm
OK - so the upgrade is failing still. So, you need to focus on what the error is that is preventing the upgrade. Until you can see the 4.3.1 in the civicrm_domain table then you can't expect the site to work.

I feel that there is a bug in the upgrade script around the constraints. The show create table you pasted before was truncated though :-(
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 29, 2013, 04:15:41 pm
Please let me know what you need to see from the table and I'll get it for you. Thank you!

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 10:00:23 am
We located an older backup of the database we used for version 4.2.8 which worked fine. We dropped all of the tables and uploaded this DB and verified in civicrm_domain version that it's version 4.2.8.

We ran the upgrade again as per: /civicrm/upgrade?reset=1

This time I noticed two extra buttons on the upgrade display, one that apparently can refresh the screen and the other causes the upgrade to proceed despite the error being displayed. This time I kept clicking the "proceed" button and got to the end of the upgrade.

The version it says is installed in civicrm_domain is now 4.3.1.

I cleared the Drupal cache, the Civicrm cache and also deleted all the files in c_templates.

However, I now get this when I try to access civicrm I get: 


backTrace

#0 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Error.php(148): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#4 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#5 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", "DB_Error", TRUE)
#6 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'created_date' in 'NEW'")
#7 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#9 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(2421): DB_common->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#10 /home/vmgdev/www/www/sites/all/modules/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#11 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(155): DB_DataObject->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...")
#12 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(917): CRM_Core_DAO->query("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", FALSE)
#13 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1683): CRM_Core_DAO::executeQuery("CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact...", (Array:0), TRUE, NULL, FALSE, FALSE)
#14 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/DAO.php(1563): CRM_Core_DAO::createTriggers((Array:4))
#15 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Logging/Schema.php(169): CRM_Core_DAO::triggerRebuild()
#16 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Form.php(632): CRM_Logging_Schema->fixSchemaDifferences()
#17 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(181): CRM_Upgrade_Form::doFinish()
#18 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Upgrade/Page/Upgrade.php(75): CRM_Upgrade_Page_Upgrade->runFinish()
#19 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(292): CRM_Upgrade_Page_Upgrade->run((Array:2), NULL)
#20 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(70): CRM_Core_Invoke::runItem((Array:13))
#21 /home/vmgdev/www/www/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:2))
#22 /home/vmgdev/www/www/sites/all/modules/civicrm/drupal/civicrm.module(436): CRM_Core_Invoke::invoke((Array:2))
#23 [internal function](): civicrm_invoke("upgrade")
#24 /home/vmgdev/www/www/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:1))
#25 /home/vmgdev/www/www/index.php(21): menu_execute_active_handler()
#26 {main}

Sorry but we are not able to provide this at the moment.
DB Error: no such field
Error Details
Database Error Code: Unknown column 'created_date' in 'NEW', 1054


Additional Details:
Array
(
    [callback] => Array
        (
           
  • => CRM_Core_Error
    • [1] => handle
            )

       
Code: [Select]
=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']
    [type] => DB_Error
    [user_info] => CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TRIGGER civicrm_contact_before_insert before insert ON civicrm_contact FOR EACH ROW BEGIN 
SET NEW.created_date = CURRENT_TIMESTAMP;
 END [nativecode=1054 ** Unknown column 'created_date' in 'NEW']"]
)

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 10:02:22 am
I had an upgrade problem at one point becuase the database user did not have permission to operate triggers.  Make sure your db user has sufficient privileges.

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 10:09:47 am
Thank you, Sonicthoughts. I checked that out and the db user has all permissions including "trigger" enabled.
« Last Edit: April 30, 2013, 10:16:39 am by Michael »

Interpolat

  • I post frequently
  • ***
  • Posts: 140
  • Karma: -1
    • Interpolat Solutions, LLC.
  • CiviCRM version: 4.4+
  • CMS version: Wordpress
  • MySQL version: 5.5+
  • PHP version: 5.4+
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 10:13:40 am
I also had problems loading a mysql dump after upgrading one of my sites.  I reported the issue and fix for my particular situation here http://www.jmdezigns.com/support/troubleshooting-civicrm/restoring-civicrm-database-from-mysql-dump-fails/.  Perhaps that will help.
Interpolat Solutions, LLC
Connecting the dots for you!
http://www.interpolat.com

Michael

  • I post occasionally
  • **
  • Posts: 69
  • Karma: 2
  • Isn't this just terrific?
  • CiviCRM version: 4.4.0
  • CMS version: Drupal 7.23
  • MySQL version: 5.3.19
  • PHP version: 5.5.30
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 10:19:58 am
Thanks for the tip, jmdezigns. I read your linked post and it's useful to know. When I tried to restore the sql dump directly it failed and what you wrote about was likely the reason. We been using other zipped backups that seem to work since then.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: Upgrade to 4.3.1 caused multiple errors and unusable system
April 30, 2013, 12:47:16 pm
Quote
This time I noticed two extra buttons on the upgrade display, one that apparently can refresh the screen and the other causes the upgrade to proceed despite the error being displayed. This time I kept clicking the "proceed" button and got to the end of the upgrade.

Sorry - getting the end of the upgrade this way is not the same as successfully completing the upgrade :-(

Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute
Pages: 1 2 [3] 4
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade to 4.3.1 caused multiple errors and unusable system

This forum was archived on 2017-11-26.