Email Archive Manager

[BlindSide]

Glad you like it, rlexyd.

The Trim functionality doesn't even look at your date formats. Since the date selections are preset radio buttons (1, 6, or 12 months), there's no date to enter, so the code just automatically puts the date in MySQL format. If you didn't touch the code in the addon you should be fine.

Assuming you didn't touch the code, let's do a test. Make sure you've installed the latest version of Email Archive Manager from the addon section. Then open email_history.php, and find this code at line 60:

$db->Execute("delete from " . TABLE_EMAIL_ARCHIVE . " where date_sent <= '" . zen_date_raw($cutoff_date) . "'");

Just above that line, enter the following code:

$sql = "delete from " . TABLE_EMAIL_ARCHIVE . " where date_sent <= '" . zen_date_raw($cutoff_date) . "'";
die($sql);

Save and upload the file to your /admin directory.

Now perform a trim, any date range. When you do, the page will come back blank with just the SQL query listed at the top. Copy and paste that query into a response post on this thread.

When you're done, go back into email_history.php and undo the changes described above. You can simply comment out the new lines and uncomment the original.

[rlexyd]

Hello Frank,
Thank you for your reply.

I did as you asked, here is the query:

delete from zen_email_archive where date_sent <= '20101307'

Just wondering, shouldn't the date have shown up as 20100713?

Hope you can solve this.

Best Regards,

[rlexyd]

You there Frank??

[BlindSide]

Sorry, went underground dealing with some non-Zen Cart stuff.

You're right, that date isn't correct. I'll look into this further.

[rlexyd]

I'm sure you are busy and I appreciate ur help :)

Cheers,

[BlindSide]

rlexyd, how exactly did you go about changing the date format?

Did you follow the instructions in this FAQ article?

https://www.zen-cart.com/tutorials/i...hp?article=401

Did you make any date-related edits to email_history.php?

[rlexyd]

Hiya Frank,

Yes, I followed the instructions from that link to change the dates.

Also, after the Trim email archive was Not working, I did attempt to alter the dates from the email_history.php and it didn't make a difference, so I just replaced it back with the original file!

You can check an image snapshot of what happens when I go to trim email archive, emails are only a week old and it still deleted them all.
(http://a.imageshack.us/img26/6650/eamerror.jpg)

Hope you can help figure out what's causing this and how to fix it :)

Best Regards,