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) »
  • CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal
Pages: [1]

Author Topic: CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal  (Read 1712 times)

rmmcclay

  • Guest
CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal
December 11, 2009, 01:51:15 am
Followed instructions to the T.  Click on Upgrade and then this:

Error Details:

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

       
[c ode] => a515ac9c2796ca0e23adbe92c68fc9fc
    [message] => DB Error: a515ac9c2796ca0e23adbe92c68fc9fc
    [mode] => 16
    [debug_info] => DROP TRIGGER civicrm_report_instance_before_insert [nativecode=1360 ** Trigger does not exist]
    [type] => DB_Error
    [user_info] => DROP TRIGGER civicrm_report_instance_before_insert [nativecode=1360 ** Trigger does not exist]
    [to_string] => [db_error: message="DB Error: a515ac9c2796ca0e23adbe92c68fc9fc" code=0 mode=callback callback=CRM_Core_Error::handle prefix="" info="DROP TRIGGER civicrm_report_instance_before_insert [nativecode=1360 ** Trigger does not exist]"]
)

I have no idea where to start trying to fix this problem. In our setup the Drupal
and Civicrm Databases are in the same database.

Thanks for any ideas.


Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal
December 11, 2009, 08:26:35 am
Can you check if your db is InnoDB?

Kurund
Found this reply helpful? Support CiviCRM

rmmcclay

  • Guest
Re: CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal
December 11, 2009, 09:53:31 pm
Hi Kurund --

Thanks for the reply!

Quote from: Kurund Jalmi on December 11, 2009, 08:26:35 am
Can you check if your db is InnoDB?

It is.  It has to be: 2.2.7 won't install otherwise.

Russ

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal
December 15, 2009, 05:56:59 am
It looks like for some reason you ended up with a multilingual install, but without the BEFORE INSERT trigger on the civicrm_report_instance table.

Can you try commenting-out the 103rd line of CRM/Upgrade/ThreeZero/ThreeZero.php and try the upgrade again? (This is the line with ‘DROP TRIGGER civicrm_report_instance_before_insert’.)
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • CRM Core Error Upgrading from 2.2.7 to 3.0.3 Drupal

This forum was archived on 2017-11-26.