ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Mailing List database table not updating

July 09, 2010 5:57am

Subscribe [4]
  • #1 / Jul 09, 2010 5:57am

    brianfidler

    75 posts

    I’m trying to use the mailing list and my list table isn’t updating.

    I initially tried with the standard mailing list tags, couldn’t get that to work so I then switched to freeform.

    I do receive an email with the opt-in confirmation link but when I click it, it just takes me to my home page.

    What could I missing?

    Here’s an example of my code.

    {exp:freeform:form return="members/edit-profile" mailinglist="stay-informed"  }
        <h4><label for="newsletteremail">Stay Informed</label></h4>
    <p>    Receive the latest my company Alerts in your inbox.<br />
       <div><br />
           <input id="newsletteremail" type="text" name="email" value="{email}" /><br />
           <input type="submit" value="submit" /><br />
       </div><br />
    {/exp:freeform:form}

    thanks,
    brian

  • #2 / Jul 09, 2010 10:23am

    Sue Crocker

    26054 posts

    Brian, unfortunately we can’t support Freeform.

    Which version/build of ExpressionEngine 1.6.x are you using? You can find that out at the bottom of any control panel page.

    The current version of the 1.6.x branch is 1.6.9 and the build is 20100430.

  • #3 / Jul 09, 2010 12:49pm

    brianfidler

    75 posts

    I’m using v1.6.9 of EE Build:  20100430 .

    I’m not expecting you to support Freeform, I simply indicated that I’m experiencing the issue whether I use EE’s mailinglist tags or Freeforms tags.

    Below is the EE native code which also does not update my database table.

    {exp:mailinglist:form list="stay-informed"}
     <h4><label for="newsletteremail">Stay Informed</label></h4>
    <p>    Receive the latest my company Alerts in your inbox.<br />
       <div><br />
           <input id="newsletteremail" type="text" name="email" value="{email}" /><br />
           <input type="submit" value="submit" /><br />
       </div><br />
    {/exp:mailinglist:form}

  • #4 / Jul 09, 2010 6:28pm

    Brandon Jones

    5500 posts

    brianfidler,

    The mailing list system is opt-in. Are you receiving the confirmation email and clicking the link? Otherwise, no emails will be added to the list.

  • #5 / Jul 09, 2010 6:47pm

    brianfidler

    75 posts

    yes, as I indicated in my initial question, users signing up do receive an email however nothing occurs when they click the opt-in link.

  • #6 / Jul 09, 2010 6:59pm

    Brandon Jones

    5500 posts

    Are you using a method to remove index.php from your URLs?

  • #7 / Jul 09, 2010 7:10pm

    brianfidler

    75 posts

    Actually we are. Using Leevi’s LG .htaccess generator

  • #8 / Jul 09, 2010 7:47pm

    Brandon Jones

    5500 posts

    URL rewriting is often the culprit in these cases, so I’d suggest temporarily disabling that extension, renaming any .htaccess files to disable them, and setting your site’s index page in General Configuration back to ‘index.php’. Then test again and keep us posted.

  • #9 / Jul 10, 2010 9:50pm

    brianfidler

    75 posts

    We removed the .htaccess that removed index.php and the mailing list worked however we do need the index.php to be removed so I then altered the mod.mailinglist.php file in the systesm/modules/mailinglist/ directory to the following:

    //orig='activation_url'    => $FNS->fetch_site_index(0, 0).$qs.'ACT='.$action_id.'&id;='.$code,
    
    'activation_url' => $FNS->fetch_site_index(0, 0).'index.php?ACT='.$action_id.'&id;='.$code,

    I added ‘index.php?’ before ‘ACT’...

    Important to remove the “$qs” as it adds the quesiton mark into the URL string. I suppose I could have added ‘index.php’ before $qs as well.

    Now all works, thanks for pointing me in the right direction.

    brian

  • #10 / Jul 11, 2010 3:40pm

    Greg Salt

    3988 posts

    Hi Brian,

    Glad that you’ve found a fix though I strongly recommend that you do not make alterations to the core files since you may run into problems when attempting to update and also it’ll make it very difficult to provide support to you. Please remove the changes you’ve made and either contact Leevi for help with the extension or perhaps use another method - several are listed in our Wiki. Alternatively, your host may be able to provide direct assistance with URL rewriting for your particular environment.

    Cheers

    Greg

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases