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) »
  • Discussion »
  • Extensions (Moderators: mathieu, totten, kasiawaka) »
  • Installing Mandrill Extension: DB Error: nativecode=1060?
Pages: [1]

Author Topic: Installing Mandrill Extension: DB Error: nativecode=1060?  (Read 659 times)

aaronchow

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 3
  • CiviCRM version: 3.3
  • CMS version: Joomla
  • MySQL version: 4
  • PHP version: 5
Installing Mandrill Extension: DB Error: nativecode=1060?
February 12, 2014, 12:05:17 pm
To Whom It May Concern,

Just curious, I'm trying to install the Mandrill Transactional Emails extension, but when I try to install it, it gives me the following error:

Code: [Select]
Feb 12 11:27:21  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => ALTER TABLE `civicrm_mailing_event_queue`
  ADD `activity_id` INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']
    [type] => DB_Error
    [user_info] => ALTER TABLE `civicrm_mailing_event_queue`
  ADD `activity_id` INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="ALTER TABLE `civicrm_mailing_event_queue`
  ADD `activity_id` INT UNSIGNED NULL DEFAULT NULL COMMENT 'Activity id of activity type email and bulk mail.' [nativecode=1060 ** Duplicate column name 'activity_id']"]
)

Does anyone know how I may fix this problem or install it properly? Any help is appreciated.

- Aaron

Update:  There is a similar thread with the installation problem.
http://forum.civicrm.org/index.php/topic,31468.msg134815.html#msg134815
« Last Edit: February 12, 2014, 12:22:04 pm by aaronchow »

aaronchow

  • I post occasionally
  • **
  • Posts: 45
  • Karma: 3
  • CiviCRM version: 3.3
  • CMS version: Joomla
  • MySQL version: 4
  • PHP version: 5
Re: Installing Mandrill Extension: DB Error: nativecode=1060?
February 14, 2014, 09:32:53 am
This is an update.

I posted a bug report, and the developer responded with the following message:

https://github.com/JMAConsulting/biz.jmaconsulting.mte/issues/30#issuecomment-35084217
Hi,

There have been some schema changes for CiviCRM 4.4.4. We are working on releasing a v4.4.4 compatible version of the extension. Currently, there is a workaround. you could delete L37 from mte_install.sql
Also, to keep up with the schema changes, you would need to change L69 of mte.php to read $saveJob = new CRM_Mailing_DAO_MailingJob(); instead of $saveJob = new CRM_Mailing_DAO_Job();

Hth,
Edsel
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Extensions (Moderators: mathieu, totten, kasiawaka) »
  • Installing Mandrill Extension: DB Error: nativecode=1060?

This forum was archived on 2017-11-26.