search

JMAConsulting / biz.jmaconsulting.mte

Mandrill Emails Extension for CiviCRM
10 stars 21 forks source link

error with logging enabled #48

Closed shawnholt closed 10 years ago

shawnholt commented 10 years ago

info="INSERT INTO civicrm_mandrill_activity (mailing_queue_id ) VALUES ( 15 ) [nativecode=1146 \ Table 'jxxx_civi.log_civicrm_mandrill_activity' doesn't exist]"] )

JoeMurray commented 10 years ago

Can you confirm that you have turned database logging on for your system? Did you install the MTE extension before turning on logging?

shawnholt commented 10 years ago

I had logging set then added MTE. I manually created the table. did something like: Create log_civicrm_mandrill_activities Table Like civicrm_mandrill_activities Engine=Archive. Then added a couple of the log table fields and no more error. haven't done more than that today.

BTW - I still am not able to get bounce processing to work . Had a problem with an IDS conflict (not sure if you have seen that but it can be a hard to spot error. Disabled IDS, webhook is hitting the server but i don't see the onhold update (soft-bounce and reject), nor do I see an error. send works fine.

I was excited to use this as I realized I can change SMTP to mandrill and just use this module for webcall based bounce processing. would apreciate a few min to help debug, but no worries if you're swamped like me :).

thanks for a great contribution.

S.

On Tue, Jul 1, 2014 at 5:24 PM, JoeMurray notifications@github.com wrote:

Can you confirm that you have turned database logging on for your system? Did you install the MTE extension before turning on logging?

— Reply to this email directly or view it on GitHub https://github.com/JMAConsulting/biz.jmaconsulting.mte/issues/48#issuecomment-47711760 .

Shawn Holt me@shawnholt.com Google Voice: (973) 850-9773 LinkedIn.com/in/shawnholt

JoeMurray commented 10 years ago

Thanks for the feedback on the log table. I think this is an issue for all extensions that create tables when logging is enabled, so I'm going to pass the buck to the core team - https://issues.civicrm.org/jira/browse/CRM-15078