We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 6525
    • 15 Posts
    Hi, I installed and configured this module. I can subscribe to the mailinglist, however I can’t send email to my subscribers. It will let me send a test email to myself though. Here is the error:

    Warning: fsockopen() [function.fsockopen]: unable to connect to mail.tomlinnicks.com:25 (Connection timed out) in /home/content/c/o/b/cobroker1/html/manager/includes/controls/class.smtp.php on line 105
    An error occurred


    And Im pretty sure my SMTP settings are right.
      • 4429
      • 429 Posts
      I have a problem with my newsletters.

      I can create a newsletter fine.

      But if the letter contains a - or ’ then it will not save, and claims there is a mysql syntax error.

      This is very annoying as I cannot abbriviate words or use phrases like 7pm-9pm

      How can i solve this?
        • 3143
        • 46 Posts
        Hello ,

        here is the french language translation
          • 17723
          • 221 Posts
          Hello,
          I get this message:
          Warning: include() [function.include]: Failed opening ’../assets/modules/easynewsletter/languages/.php’ for inclusion (include_path=’/manager/includes/’) in /manager/processors/execute_module.processor.php(98) : eval()’d code on line 75

          Easy Newsletter 0.3 - © 2007 SimpleShop.dk
          | |
          Warning: include() [function.include]: Failed opening ’../assets/modules/easynewsletter/languages/.php’ for inclusion (include_path=’/manager/includes/’) in /assets/modules/easynewsletter/backend.php on line 27

          Could some one help me slove this problem? Im running MODX 9.6.1 and The latest Easy Newsletter.

            Lucas from AroundCyprus.net
            • 20349 ☆ A M B ☆
            • 453 Posts
            Hi!!!

            Here is the Croatian translation


            (you must remove ".txt" to work)
              BASE - Web Design Studio
              MODX Ambassador

              Website
              • 12320
              • 88 Posts
              Hi there,
              first of all, Huge thanks for this module, even if i’m having problems with it :
              - the snippet doesn’t suscribe and unsuscribe, but i will find out why (i hope so)
              - but worst of all in french language we use this character: ’  (the example => l’exemple) and so you can Not write a newsletter without french gramatical error or mysql error.
              To solve that you’ll have to prepare datas to be inserted in the database by encrypt in safe html content, and after to decrypt it. I’ll be helpfull for you if you need.

              I’ve done a dedicated solution for sending newsletters including images, if you want to have a look on it, i’ll offer it to you. it’s based on mime types.
              If you have a quick solution for the snippet , please let me know.

              EDIT : the snippet problem was solved by unselect page cache, sorry so sorry...

              Regards, Norbert.
                Thanks to the authors of the following code :
                Easy Newsletter (module)
                SiteMap (snippet)
                Codepress (Plugins)
                Strict URLs (Plugins)
                Virtual Aliases (Plugins)
                Maxygallery (snippet)
                • 12584
                • 208 Posts
                Heres something that would be a useful feature, a way to throttle back the speed the mails send out at.

                MY server is set to only let send 400 emails an hour. Right now the site I am using this on does not have that many so not an issue just yet.

                Cheers.
                  • 15152
                  • 360 Posts
                  Does anyone have a solution to upload a large amount of newsletter subscribers via excel? I’ve got about 500 that I need to get in the system.
                  Thanks
                    There are no boring projects. Only boring executions. ~ Etzkorn
                    www.impress-design.com
                    • 4310
                    • 2,310 Posts
                    Here’s a snippet that will insert the records from an excel generated csv file into the EasyNewsletters subscribers table.
                    There are three parameters :
                    &table name of the subscribers DB table
                    &csv name of the csv file ( doesn’t need the .csv extension )
                    &csvpath path to the csv file on the server
                    The csv file should have the seven columns :
                    firstname, lastname, email, status, blocked, lastnewsletter, created ( see attached .csv file )
                    Ideally this could be incorporated into the EasyNewsletter module itself, maybe with a file upload feature, but that would take longer wink
                    <?php
                    $table = (isset($table)) ? $table : 'easynewsletter_subscribers'; // name of the table for updating
                    $csv = (isset($csv)) ? $csv : 'subscribers'; // name of the csv file for updating the table - doesn't need the .csv extension
                    $csvpath= (isset($csvpath)) ? $csvpath : 'assets/csv/'; // path to the folder the csv file is stored in
                    $basePath = $modx->config['base_path'];
                    if (file_exists($basePath.$csvpath.$csv.".csv")){
                    $fp = fopen($basePath.$csvpath.$csv.".csv","r");
                    while($data=fgetcsv($fp,900000,",")){
                    $firstname = addslashes($data[0]);
                    $lastname = addslashes($data[1]);
                    $email = addslashes ($data[2]);
                    $status = addslashes($data[3]);
                    $blocked = addslashes($data[4]);
                    $lastnewsletter = addslashes($data[5]);
                    $created = addslashes($data[6]);
                    $fields = array ('firstname' => $modx->db->escape($firstname), 'lastname' => $modx->db->escape($lastname), 'email' => $modx->db->escape($email),
                    'status' => $modx->db->escape($status), 'blocked' => $modx->db->escape($Measure), 'lastnewsletter' => $modx->db->escape($lastnewsletter), 'created' => $modx->db->escape($created));
                    $rs = $modx->db->insert($fields, $table);
                    }
                    }
                    ?>

                    I tested it quickly, but if you have any problems, report back!
                      • 15152
                      • 360 Posts
                      David
                      Thanks!
                      Can you give me instructions on how to run this? Not a ’coder’ and don’t want to mess anything up.
                      Thanks a ton!
                        There are no boring projects. Only boring executions. ~ Etzkorn
                        www.impress-design.com