Author Topic: Follow Up Emails are Blank (Read 2051 times)

melanie · « **on:** January 20, 2006, 09:41:51 am »

Over the weekend we moved to a new server. All previous saved followup emails are blank - subject and text message (none of these are HTML messages.) To test, I added another followup to my test list with new text, and this new followup came through fine - its just the ones that were brought over from the other server that are sending as blanks.

Any ideas?

DW · « **Reply #1 on:** January 22, 2006, 10:54:50 am »

Are the followups appearing as expected in the interface? Please submit your info so I can take a closer look.

Regards, DW

melanie · « **Reply #2 on:** January 22, 2006, 01:12:52 pm »

Yes, they do appear as normal. I submitted info as requested. Look at list number 14 as one example of followups that are not sending...it sends the email but both the subject and message are blank.

DW · « **Reply #3 on:** January 24, 2006, 07:40:38 am »

I'm not sure what's going on, the tables look fine, the data is all there, etc. I notice you are on a much older copy of ListMail (v1.8.). You may want to upgrade to the latest version (v1.85) to make sure this is not caused by a bug that was fixed.

One thing out of the ordinary is your (slightly modified for privacy) MySQL hostname.

$sqlhost = ':/tmp/mysql_x1234.sock';

This appears to work just fine, however, so I don't know how relevant it is.

Please upgrade and if that doesn't fix it I'll try to troubleshoot the issue.

Regards, DW

melanie · « **Reply #4 on:** January 24, 2006, 09:53:57 am »

Upgrade to 1.85 is complete.

I also exported the tables for lists and followups in MySQL, then reimported them, but it didn't work. Then I tried switching from SMTP to PHP Mail, but that didn't help either. Also...

Sending an email (not a followup, a standard mailing) works fine.
Previewing an email doesn't work, the subject and message are blank.
Previewing a followup doesn't work, the subject and message are blank.

I turned off dailymail a couple days ago because I received the blank followups, and I hesitate to turn it back on for a test because I don't want to send any blank followups. If we can get the preview working, I'll delete the followups from the database (I have a backup) and run another test.

DW · « **Reply #5 on:** January 24, 2006, 09:05:21 pm »

Thank you - I believe with these details I should be able to figure it out tonight. Normally I recommend fixing problems before upgrading, but I didn't have much to go on as I surely could not run your dailymail manually as a test.

Regards

DW · « **Reply #6 on:** January 24, 2006, 11:13:39 pm »

It appears that you have added 5 extra custom fields to your lm_users table. Some of these fields contain data for some users. Did you previously modify ALL ListMailPRO user operations to reflect the added fields? This will need to be done again, or the fields will need to be removed, before I can assist more for free.

I also noticed that I could not create a new list - was the lm_lists table modified as well?

Regards, DW

melanie · « **Reply #7 on:** January 25, 2006, 07:02:01 am »

I had forgotten about that - yes we had modified them quite some time ago, but now I have removed those fields as they are no longer necessary. Adding a list works now, but the previews of followups are still not working.

DW · « **Reply #8 on:** January 25, 2006, 08:58:35 pm »

Okay, I think I figured it out. The blank message is returned when there are NO message codes to cycle through.

What you need to do to avoid this bug is add at least one Global Code whether you use it or not.

Regards

melanie · « **Reply #9 on:** January 26, 2006, 07:39:58 am »

Wonderful - I ran a couple tests and things seem to be working much better now! I turned dailymail back on, so tonight will be the true test - but I'm pretty sure we're back to normal.

Thanks!