I found that they did not have an entry in the mailing_account_table so I created one with the sql expression
Code: Select all
insert into mailing_account_tbl (mailing_id, status_field, company_id, mailtype, no_of_mailings, no_of_bytes, change_date, maildrop_id , blocknr)
select
maildrop_status_tbl.mailing_id as mailing_id,
maildrop_status_tbl.status_id as status_field,
1 as company_id,
1 as mailtype,
mailing_backend_log_tbl.current_mails as no_of_mailings,
maildrop_status_tbl.blocksize as no_of_bytes,
mailing_backend_log_tbl.change_date as change_date,
maildrop_status_tbl.status_id as maildrop_id,
10 as blocknr
from (maildrop_status_tbl inner join mailing_backend_log_tbl on maildrop_status_tbl.mailing_id = mailing_backend_log_tbl.mailing_id)
where maildrop_status_tbl.mailing_id>=334 and maildrop_status_tbl.mailing_id<357 order by mailing_id;
The 10 as blocknr bit is completely arbitrary, and I used the mailing_id range that was sent out with RC1 and did not have an entry in the mailing_account_tbl.
This has not handled the situation though - and the reason I would like to resolve it is because now I have a whole ton of mailings that just sit on the top of all the sent mailings looking like they are not sent and the moment you send something and gets a send date, it disappears behind these.
I am sure you'll have this fixed by the final release - but in the meantime, could you tell me where in the database does the Mailings Overview get the send date column from? I can't figure it out from the table schema.
Thanks!