Support/Comments for Easy Newsletter

Quote from: Frank at Mar 17, 2009, 03:09 AM

Hi Pieter,

ran into almost the same issue yesterday, here’s my solution:

http://modxcms.com/forums/index.php/topic,33080.msg206647.html#msg206647

Let me know if that works

Thanks for the Dutch translation! However I have not found the solution so far, I have looked in the the Module file, but I could not find the code "$language = ’’.$path.’languages/’.$lang.’.php’;" which I should change to Dutch. I found in line 75 this code "include($path.’languages/’.mysql_result($result,$i,"lang_backend").’.php’);" ?

Thank you for helping me out!


Do you have any suggestions?


*******************************
It works! I was searching for this code in 0.3 version instead of 0.4! Thank you for helping me out!

Regards,

Pieter

Looks like your language configuration is not being passed to the backend.php code.
The link Frank gave is for a modified version (0.4) of Easy Newsletter I wrote, so the line numbers/code don’t match the original version (0.3).
If you want, PM me with a login and I’ll have a quick look, maybe it’s an easy fix

I’ve looked and can’t find this info. Does anyone know how to personalize the newsletter? I’d like to place something like this: Hello (subscriber name)

Thanks

I face the following problem. When I send the test e-mail I get the following error code.

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table ’xxx_nederland.modx_web_user_attributes’ doesn’t exist »
SQL: SELECT * FROM `modx_web_user_attributes`
[Copy SQL to ClipBoard]

Parser timing
MySQL: 0.0022 s (4 Requests)
PHP: 1237365459.6630 s
Total: 1237365459.6651 s

However when I really send the newsletter it works fine.

Any suggestions how I can repair the test mode?

Thanks in advance.

Pieter

Hi

Are you using that "modx" prefix in the db?
Change line 126 and 306 in backend.php if you do not use that ’modx_’ prefix in the DB.
If we are using the same version.

Frank.

Hi Frank, thanks for your reply.

I have changed these lines:

126 $sql = "SELECT * FROM `modx_web_user_attributes` WHERE `blocked` = 0";
306 $sql = "SELECT * FROM `modx_web_user_attributes`";

in

126 $sql = "SELECT * FROM `web_user_attributes` WHERE `blocked` = 0";
306 $sql = "SELECT * FROM `web_user_attributes`";

And now it works!

Thank you for your help. This is a great module!

Regards,

Pieter

Whish feature: newsletters scheduling (like this one _http://drupal.org/project/simplenews_scheduler)

And another one would be the option to use a template/modx page.
Would give the personalize option throught placeholders I guess.

well...it looks like easynewsletter is not really supported any more :’( at least not from the original developer...

j

I keep meaning to make one updated version out a couple of customised versions I use.
Never seem to have the time, I will try though.