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 »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Server problem bounced emails - mysql query required
Pages: [1]

Author Topic: Server problem bounced emails - mysql query required  (Read 589 times)

krankie

  • I’m new here
  • *
  • Posts: 22
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Joomla! 1.5.22
  • MySQL version: 5.0.22-log
  • PHP version: 5.2.11
Server problem bounced emails - mysql query required
February 01, 2011, 10:42:02 am
Yikes

We did a mailout earlier to all our members.  Unfortunately qscand ran out of memory scanning the mails and over 400 of them bounced locally, unsent, causing all those members to have their email address flagged as on hold.

I am not an expert with mysql or the civimail database structure, but I need help to construct a mysql query I can run which will find all the bounced recipients of the email and 'unhold' their email addresses.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Server problem bounced emails - mysql query required
February 01, 2011, 11:15:53 am
you can find them using advanced search and un unhold them (mass actions).

(at least on the latest version of civi)
X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

krankie

  • I’m new here
  • *
  • Posts: 22
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Joomla! 1.5.22
  • MySQL version: 5.0.22-log
  • PHP version: 5.2.11
Re: Server problem bounced emails - mysql query required
February 01, 2011, 11:40:12 am
Doesn't look like an option on 3.3.1, mailing fields not available in search.

krankie

  • I’m new here
  • *
  • Posts: 22
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Joomla! 1.5.22
  • MySQL version: 5.0.22-log
  • PHP version: 5.2.11
Re: Server problem bounced emails - mysql query required
February 01, 2011, 04:59:24 pm
Got this sorted now - it took about an hour to capture all the cid values - manually - then used awk to create a file of simple sql update table commands. Fairly novice technique but it had the desired result.

If upgrading adds mailings to the contact search builder pages I might give that a go next weekend.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • Server problem bounced emails - mysql query required

This forum was archived on 2017-11-26.