UpiCRM won’t send any emails – DB error

  • Resolved ebrilz

    (@ebrilz)


    5 years, 1 month ago

    Hello,
    I can’t get UpiCRM to send any emails. I’ve tried everything I can think of in the configuration. I have a Contact Forms 7 form that successfully creates a new lead in UpiCRM and assigns it to a group of users in round robin style. However, the user assigned the lead never gets the email. Further, none of the emails in the Email Notifications configuration section are ever sent.
    I’m getting this error a lot in my error log:

    WordPress database error Unknown column ‘lead_integration_wait_send’ in ‘where clause’ for query SELECT * FROM wp_upicrm_leads_integration WHERE lead_integration_wait_send=1 /* From [kwstage.wpengine.com/wp-admin/admin-ajax.php] in [/nas/content/live/kwstage/wp-content/plugins/upi-crm-universal-crm-solution/classes/upicrm_integrations.php:92] */ made by do_action(‘wp_ajax_nopriv_upicrm_on_load’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, UpiCRMAJAX->wp_ajax_upicrm_on_load_callback, UpiCRMIntegrationsLib->send_waiting_slave, UpiCRMIntegrations->get_waiting_leads, referer: http://kwstage.wpengine.com/

    Any help would be appreciated.

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter ebrilz

    (@ebrilz)

    5 years ago

    Manually reassigning a lead to someone else also does not send an email.

    Thread Starter ebrilz

    (@ebrilz)

    5 years ago

    I was able to solve the MySQL error by looking at the UpiCRM source and grabbing the ALTER TABLE statement that adds the lead_integration_wait_send column to the necessary table. Now I’m not getting those errors in the error log, but emails still do not send. We are successfully getting emails sent from Contact Forms 7, but none of the UpiCRM emails send.

    Plugin Author Upi

    (@upi)

    5 years ago

    Hi
    First – did you use the checkbox in the email setting to override the default Sendmail function? Please try.

    Another solution can be to use WP SMTP plugin.

    Please try and let us know
    Uri

    Thread Starter ebrilz

    (@ebrilz)

    5 years ago

    Hi Uri,

    I have tried checking and unchecking the setting called “UpiCRM will send email using only WP-Mail function.” and both ways the emails never send.

    We are using WP Engine to host our WP site and they do not have an SMTP server available, so the WP SMTP plugin can’t help us unless we pay for a 3rd party SMTP provider.

    However, Contact Forms 7 emails successfully send from our site, and UpiCRM emails do not. Do you know a reason for this?

    Thanks,
    Erik

    Plugin Author Upi

    (@upi)

    5 years ago

    Hi Erik
    The simplest solution – open a Gmail mailbox call leadsyoureite@gmail.com and send through there.
    Google are excellent dmtp provider – for free.

    Works?

    Thread Starter ebrilz

    (@ebrilz)

    5 years ago

    Hi Uri,

    I installed the WP Mail SMTP plugin and discovered there is an option to keep using PHP’s built in mail function, which I used. I then went and checked Upi’s checkbox for “UpiCRM will send email using only WP-Mail function.” This resulted in the New Lead email successfully being sent. The email template we configured in the Auto Lead Management settings did *not* send. This is fine for us, as the New Lead email is sufficient.

    We are now able to use UpiCRM for our purposes, but it is worth noting these two things:

    • On WP Engine hosting, Contact Forms 7 is able to send emails without a plugin, while UpiCRM seems to require the WP Mail SMTP plugin to send emails.
    • Even with WP Mail SMTP installed, when we configured an email template in Auto Lead Management, it did not send. Only the New Lead email was sent.

    Thanks,
    Erik

    mikenco

    (@mikenco)

    4 years, 11 months ago

    Hi,

    When a lead is assigned to a different user, is the new user supposed to get an email notification? I have WP SMTP setup and working, but only admin ever gets any emails from UPICRM, is this correct?

    mikenco

    (@mikenco)

    4 years, 11 months ago

    I have “WP Mail SMTP” connected to Google Business Suite with an API. Contact Form 7 works, email testing plugins works, but UPIcrm will not send email to users, but it will end emails to admins. I have ticked the ‘use WP Mail’ option in settings, but still nothing.. any ideas?

    Could you write a smtp testing section into your plugin? Also, can you write in the ability to notify a user of their new lead from the admin panel. i.e. change the drop down to “ASSIGNED” and a “NOTIFY” button appears!

    • This reply was modified 4 years, 11 months ago by mikenco. Reason: typo
Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘UpiCRM won’t send any emails – DB error’ is closed to new replies.