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) »
  • 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
Pages: [1]

Author Topic: 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1  (Read 1915 times)

nicol

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 5
  • CiviCRM version: 4.2, 4.3, 4.4
  • CMS version: Joomla 2.5.x, Joomla 3.x Wordpress 3.x, Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3 / 5.4
4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
June 06, 2013, 06:06:21 am
Hi,
I've been trying to upgrade from 4.2.7 to 4.3.3 and have been stumbling at the point below.

Code: [Select]
ype DB_Error
Code -15
Message DB Error: can not create
Mode 16
UserInfo ALTER TABLE `civicrm_entity_financial_account` ADD CONSTRAINT `FK_civicrm_entity_financial_account_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`) [nativecode=1005 ** Can't create table 'bapcadbse.#sql-27c4_b04' (errno: 121)]
DebugInfo ALTER TABLE `civicrm_entity_financial_account` ADD CONSTRAINT `FK_civicrm_entity_financial_account_financial_account_id` FOREIGN KEY (`financial_account_id`) REFERENCES `civicrm_financial_account` (`id`) [nativecode=1005 ** Can't create table 'bapcadbse.#sql-27c4_b04' (errno: 121)]
PEAR_Exception: DB Error: can not create in unknown on line unknown
- DB_Error: DB Error: can not create in unknown on line unknown
Exception trace
# Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
1 call_user_func(Array, Object(DB_Error)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: can no…', -15, 16, Array, 'ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB.php:969
3 DB_Error->DB_Error(-15, 16, Array, 'ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -15, null, null, 'ALTER TABLE `civ…', 'DB_Error', true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1905
5 DB_common->raiseError(-15, null, null, null, '1005 ** Can't cr…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery('ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8 DB_common->query('ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php:284
9 CRM_Utils_File::sourceSQLFile('mysql://root:roo…', ' SELECT @wo…', null, true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:159
10 CRM_Upgrade_Form->source(' SELECT @wo…', true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:299
11 CRM_Upgrade_Form->processLocales('/Applications/MA…', '4.3.alpha1') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:323
12 CRM_Upgrade_Form->processSQL('4.3.alpha1') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:945
13 CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), '4.3.alpha1') unknown:unknown
14 call_user_func_array(Array, Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:186
16 CRM_Queue_Runner->runNext(true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17 CRM_Queue_Page_AJAX::{closure}() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
19 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
20 call_user_func(Array, Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:258
21 CRM_Core_Invoke::runItem(Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:70
22 CRM_Core_Invoke::_invoke(Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:52
23 CRM_Core_Invoke::invoke(Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/admin.civicrm.php:116
24 civicrm_invoke() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/admin.civicrm.php:40
25 require_once('/Applications/MA…') /Applications/MAMP/htdocs/j25.9/libraries/joomla/application/component/helper.php:383
26 JComponentHelper::executeComponent('/Applications/MA…') /Applications/MAMP/htdocs/j25.9/libraries/joomla/application/component/helper.php:351
27 JComponentHelper::renderComponent('com_civicrm') /Applications/MAMP/htdocs/j25.9/administrator/includes/application.php:153
28 JAdministrator->dispatch() /Applications/MAMP/htdocs/j25.9/administrator/index.php:46
29 {main}

I tried to do it incrementally by going from 4.2.7 to 4.2.9 which the update script progresses through fine, but then it continues further and once the progress bar shows "Upgrade to 4.3alpha1" I get a new error (below), so made the change manually and re-ran, and then a new error - which I edited manually in mysql. I've now tried running the mysql queries from the "4.3.alpha1.mysql.tpl" file but every third or fourth gives an error.
Really not sure what to try next - as I had the impression my database was ok before.
thanks
Nic

- updated with more info / attempts


Code: [Select]
Type DB_Error
Code -1
Message DB Error: unknown error
Mode 16
UserInfo ALTER TABLE `civicrm_discount` DROP FOREIGN KEY FK_civicrm_discount_option_group_id, DROP INDEX FK_civicrm_discount_option_group_id [nativecode=1025 ** Error on rename of './bapcadbse/civicrm_discount' to './bapcadbse/#sql2-27c4-97a' (errno: 152)]
DebugInfo ALTER TABLE `civicrm_discount` DROP FOREIGN KEY FK_civicrm_discount_option_group_id, DROP INDEX FK_civicrm_discount_option_group_id [nativecode=1025 ** Error on rename of './bapcadbse/civicrm_discount' to './bapcadbse/#sql2-27c4-97a' (errno: 152)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown
Exception trace
# Function Location
0 CRM_Core_Error::exceptionHandler(Object(DB_Error)) unknown:unknown
1 call_user_func(Array, Object(DB_Error)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/PEAR.php:931
2 PEAR_Error->PEAR_Error('DB Error: unknow…', -1, 16, Array, 'ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB.php:968
3 DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/PEAR.php:564
4 PEAR->raiseError(null, -1, null, null, 'ALTER TABLE `civ…', 'DB_Error', true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1903
5 DB_common->raiseError(-1, null, null, null, '1025 ** Error on…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:898
6 DB_mysql->mysqlRaiseError() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php:327
7 DB_mysql->simpleQuery('ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/packages/DB/common.php:1216
8 DB_common->query('ALTER TABLE `civ…') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Utils/File.php:287
9 CRM_Utils_File->sourceSQLFile('mysql://root:roo…', ' SELECT @wo…', null, true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:152
10 CRM_Upgrade_Form->source(' SELECT @wo…', true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:292
11 CRM_Upgrade_Form->processLocales('/Applications/MA…', '4.3.alpha1') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Form.php:316
12 CRM_Upgrade_Form->processSQL('4.3.alpha1') /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Upgrade/Incremental/php/FourThree.php:945
13 CRM_Upgrade_Incremental_php_FourThree::task_4_3_x_runSql(Object(CRM_Queue_TaskContext), '4.3.alpha1') unknown:unknown
14 call_user_func_array(Array, Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Task.php:79
15 CRM_Queue_Task->run(Object(CRM_Queue_TaskContext)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Runner.php:187
16 CRM_Queue_Runner->runNext(true) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:44
17 CRM_Queue_Page_AJAX::{closure}() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/ErrorPolicy.php:80
18 CRM_Queue_ErrorPolicy->call(Object(Closure)) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Queue/Page/AJAX.php:47
19 CRM_Queue_Page_AJAX::runNext(Array) unknown:unknown
20 call_user_func(Array, Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:187
21 CRM_Core_Invoke::_invoke(Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php:51
22 CRM_Core_Invoke::invoke(Array) /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/admin.civicrm.php:87
23 civicrm_invoke() /Applications/MAMP/htdocs/j25.9/administrator/components/com_civicrm/admin.civicrm.php:40
24 require_once('/Applications/MA…') /Applications/MAMP/htdocs/j25.9/libraries/joomla/application/component/helper.php:383
25 JComponentHelper::executeComponent('/Applications/MA…') /Applications/MAMP/htdocs/j25.9/libraries/joomla/application/component/helper.php:351
26 JComponentHelper::renderComponent('com_civicrm') /Applications/MAMP/htdocs/j25.9/administrator/includes/application.php:153
27 JAdministrator->dispatch() /Applications/MAMP/htdocs/j25.9/administrator/index.php:46
28 {main}
« Last Edit: June 12, 2013, 07:35:33 am by nicol »

nicol

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 5
  • CiviCRM version: 4.2, 4.3, 4.4
  • CMS version: Joomla 2.5.x, Joomla 3.x Wordpress 3.x, Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3 / 5.4
Re: 4.2.7 to 4.2.9 - db error & script tries to upgrade 4.3alpha1
June 12, 2013, 07:35:09 am
Does anyone have any ideas on this?

It seems strange that when I try a small upgrade to either 4.2.8 or 4.2.9 it still tries to rung the 4.3alpha1 upgrade script which is where it all breaks.

I've tried running a fresh Joomla and Civi install, swapping the Civi tables over and then running the upgrade script and it hangs at the same point. I can't see what else to try.

Thanks
Nic

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
June 13, 2013, 11:56:35 pm
This seems strange. I would have thought that the 4.2.9 codebase would not even include any sql to do with 4.3.x, which suggests to me that you have not effectively deleted all of the codebase from your earlier attempt to update to 4.3.x?
Graham Mitchell
http://mc3.coop

nicol

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 5
  • CiviCRM version: 4.2, 4.3, 4.4
  • CMS version: Joomla 2.5.x, Joomla 3.x Wordpress 3.x, Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3 / 5.4
Re: 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
June 14, 2013, 03:44:52 am
Hello, yes it's exactly that - I should have updated this to clarify - my downgrade left parts of 4.3.x behind hence the sql script running. A clean reinstall fixed that.

Have now managed to get to 4.2.9 but still getting the same error when I try to jump over to 4.3.x

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
June 14, 2013, 04:13:25 am
It looks like you are using MAMP to test the upgrade, presumably on a copy of the live site? Have you checked that everything in the copy is working properly in that location (i.e.on your Mac) before running the update? If some of the paths or URLs are incorrect it may well be causing problems.
Graham Mitchell
http://mc3.coop

nicol

  • I post occasionally
  • **
  • Posts: 95
  • Karma: 5
  • CiviCRM version: 4.2, 4.3, 4.4
  • CMS version: Joomla 2.5.x, Joomla 3.x Wordpress 3.x, Drupal 7.x
  • MySQL version: 5.x
  • PHP version: 5.3 / 5.4
Re: 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1
June 14, 2013, 04:19:18 am
Yes it seems to work fine in MAMP - other than the upgrade script.

I even tried the upgrade on a live site, before having to quickly reinstall a backup, and the error message came at the same point about the 'civicrm_entity_financial_account' table.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • 4.2.7 to 4.2.9 or 4.3.x - db error & script tries to upgrade 4.3alpha1

This forum was archived on 2017-11-26.