Author Topic: Civi Mail Error when group is greater than 1000 (Read 6598 times)

jennybertha · August 01, 2013, 03:51:42 pm

I am not sure this is the problem but It coincides that when the group I am trying to send has more than 1000 contacts I get an error when using CiviMail.

The very first screen of civimail when selecting an intelligent group with all the contacts, I get an Unknown DB Error in the next screen Saying the table i_86 is full. if the group is smaller the error is not occuring.

Anybody know why this is happening, Please help, I need to use this feature right away and would hate to have to send two different mailings to smaller groups.

Thank you

jennybertha · August 01, 2013, 07:41:24 pm

This is the error message coming up.

Array
(
[callback] => Array
(

=> CRM_Core_Error

Code: [Select]

 =&gt; -1
    [message] =&gt; DB Error: unknown error
    [mode] =&gt; 16
    [debug_info] =&gt; 
INSERT IGNORE INTO I_86 (email_id, contact_id) 
SELECT     e.id as email_id, c.id as contact_id
FROM       civicrm_contact c
INNER JOIN civicrm_email e                ON e.contact_id         = c.id
INNER JOIN civicrm_group_contact_cache gc ON gc.contact_id        = c.id
LEFT  JOIN X_86                      ON X_86.contact_id = c.id
WHERE      gc.group_id = 15
  AND      c.do_not_email = 0
  AND      c.is_opt_out = 0
  AND      c.is_deceased = 0
  AND      (e.is_bulkmail = 1 OR e.is_primary = 1)
  AND      e.on_hold = 0
  AND      X_86.contact_id IS null
ORDER BY   e.is_bulkmail
 [nativecode=1114 ** The table 'I_86' is full]
    [type] =&gt; DB_Error
    [user_info] =&gt; 
INSERT IGNORE INTO I_86 (email_id, contact_id) 
SELECT     e.id as email_id, c.id as contact_id
FROM       civicrm_contact c
INNER JOIN civicrm_email e                ON e.contact_id         = c.id
INNER JOIN civicrm_group_contact_cache gc ON gc.contact_id        = c.id
LEFT  JOIN X_86                      ON X_86.contact_id = c.id
WHERE      gc.group_id = 15
  AND      c.do_not_email = 0
  AND      c.is_opt_out = 0
  AND      c.is_deceased = 0
  AND      (e.is_bulkmail = 1 OR e.is_primary = 1)
  AND      e.on_hold = 0
  AND      X_86.contact_id IS null
ORDER BY   e.is_bulkmail
 [nativecode=1114 ** The table 'I_86' is full]
    [to_string] =&gt; [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="
INSERT IGNORE INTO I_86 (email_id, contact_id) 
SELECT     e.id as email_id, c.id as contact_id
FROM       civicrm_contact c
INNER JOIN civicrm_email e                ON e.contact_id         = c.id
INNER JOIN civicrm_group_contact_cache gc ON gc.contact_id        = c.id
LEFT  JOIN X_86                      ON X_86.contact_id = c.id
WHERE      gc.group_id = 15
  AND      c.do_not_email = 0
  AND      c.is_opt_out = 0
  AND      c.is_deceased = 0
  AND      (e.is_bulkmail = 1 OR e.is_primary = 1)
  AND      e.on_hold = 0
  AND      X_86.contact_id IS null
ORDER BY   e.is_bulkmail
 [nativecode=1114 ** The table 'I_86' is full]"]
)

Donald Lobo · August 02, 2013, 08:44:02 am

might want to check:

http://stackoverflow.com/questions/730579/error-1114-hy000-the-table-is-full

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Civi Mail Error when group is greater than 1000 (Read 6598 times)

jennybertha

Civi Mail Error when group is greater than 1000

jennybertha

Re: Civi Mail Error when group is greater than 1000

Donald Lobo

Re: Civi Mail Error when group is greater than 1000