Newsletter Builder Archive Issues - Draft newsletters

Mon, 26 Oct 2015 15:30:19 -0700

It worked!

My two favorite words! :)

Thanks for the update.

Newsletter Builder Archive Issues - Draft newsletters

Mon, 26 Oct 2015 15:30:17 -0700

It worked!

My two favorite words! :)

Thanks for the update.

Newsletter Builder Archive Issues - Draft newsletters

Mon, 26 Oct 2015 12:52:47 -0700

Damon: Not exactly how I would do that.... would this work?

'where' => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs . " AND " . "send IN ('all','archive') AND " . whereRecordNumberInUrl(1),

Ragi

P.S. It worked! Thanks Damon.

Newsletter Builder Archive Issues - Draft newsletters

Mon, 26 Oct 2015 11:28:26 -0700

Hi Ragi,

You do need this code:

'where' => "send IN ('all','archive') AND " . whereRecordNumberInUrl(1),

so that only newsletters that have been sent and archived (all) or just archived (archive) will be displayed. Otherwise newsletters that set as drafts (none) are displayed as well.

Can you add your additional mySQL filtering to the where statement?

Newsletter Builder Archive Issues - Draft newsletters

Sat, 24 Oct 2015 04:10:10 -0700

Woops! I made a mistake. Your solution actually brought me back to a previous version. it appears we’re back to the Messages from the SSC appearing under the weekly message archive. Only the weekly messages should appear in the weekly message section and archives.
And weekly messages are also appearing in the newsletter achive, when only Messages from the SSC (Owls nest) and 706 on the move! newsletters should be in the newsletter archive.

So, no it did not work.

Ragi

Newsletter Builder Archive Issues - Draft newsletters

Fri, 23 Oct 2015 15:15:16 -0700

Damon: again, great!

Ragi

Newsletter Builder Archive Issues - Draft newsletters

Fri, 23 Oct 2015 12:41:06 -0700

Hi again,

For the weeklyMessage.php file, on line 22, can you replace this:

'where' => "to_list = '" . coalesce(mysql_escape(@$_REQUEST['to_list']), '2') . "' AND " . $whereMessageNumIs,

with this:

'where' => "send IN ('all','archive') AND " . whereRecordNumberInUrl(1), // If no record # is specified then latest record is shown

Let me know if that works for you.

Thanks!

Newsletter Builder Archive Issues - Draft newsletters

Wed, 21 Oct 2015 16:23:03 -0700

Damon: I just realized I also have the file weeklyMessage.php which only lists the weekly messages. It has the same issue as the archive.php file, but in this case its a bit more convoluted. Can you provide me a hint?

Ragi

Newsletter Builder Archive Issues - Draft newsletters

Wed, 21 Oct 2015 12:17:02 -0700

That worked perfectly!

Thanks Damon.

Newsletter Builder Archive Issues - Draft newsletters

Wed, 21 Oct 2015 10:47:32 -0700

Hi Ragi,

Can you try replacing the code on line 28:

'where' => $where,

with this code:

'where' => "send IN ('all','archive')"

Let me know if that works for you.

Thanks!

Newsletter Builder Archive Issues - Draft newsletters

Mon, 19 Oct 2015 12:57:53 -0700

I am having a bit of a problem with a Newsletter Builder installation. I am using CMSB 2.65 and Newsletter Builder 3.02.

When I create a draft newsletter, it shows up on the archive.php page. It shouldn't, as my testing has shown from other implementations.

I have attached my archive.php file as I believe the error is in there.

Thanks!

Ragi