Topics

1

General Help & How-To / Stops Sending

« on: December 19, 2007, 02:27:07 pm »

I know there have been a number of posts about this, but nothing has helped my situation yet.

I recently moved from an old, slow dedicated server to a newer, faster one. On the old server, LMP would usually send all my emails without interruption. On my new server, it will always send between 1700 and 2100 messages and then stop- that is around 7-8 minutes. The web interface doesn't show any error message - it just stops updating the message count and the messages stop going out. I have set the "Reconnect Every" to 999 (as I had it on the old server. I turned on the SMTP logging feature and found nothing out of the ordinary at the end of the log. No error messages - just the same set of connect and success lines for every message in the log.

Since I am sending more messages than the reconnect setting (999), I don't think that is the problem. With no errors in the SMTP log, I don't know what else to try.

Thanks,
Chris

PS I do have the resume cron script hooked up running every 10 minutes, so the sending resumes automatically. I just know it could take less time if it didn't keep stopping.

2

General Help & How-To / Issue with Custom Query in User Selection

« on: January 10, 2007, 09:56:22 am »

I created a complex custom query in the user selection area.

Code: [Select]

left join lm_users as B on lm_users.email = B.email and lm_users.uid != B.uid WHERE lm_users.cnf=1 AND  (lm_users.list = 4 or lm_users.list = 6 or lm_users.list = 8 or lm_users.list = 9) AND (B.email is NULL or B.list =4 or B.list =6 or B.list =8 or B.list =9) group by lm_users.email
This query selects everyone on list 4,6,8 & 9 who are not on other lists and groups by email to remove duplicates. (The people on the other lists will get a different email but I don't want anyone to get 2 emails). The above query was too long and the end was truncated when I saved it. I notcied that the 'q' field in Table lm_selectd was 'TinyText'. I changed that to 'Text' and the query was stored correctly.

Testing the query in the User Selection worked perfectly. However, when I went to actually send the message, there was a query error. It said that 'email' was an ambiguous field. Line 440 of selfunc.php does a condition between selecting '*' or selecting 'email,id'.  In my query, there are duplicate fields so that 'email' is ambiguous. I temporarily changed that line 440 to 'lm_users.email, lm_users.id' and then the whole thing worked.

I am not sure if you want to change this, but I wanted to let you know. Also, the above query might be helpful to others who are trying to accomplish a similar thing. This query may address this post:
http://listmailpro.com/forum/index.php?topic=1440.0

Thanks.

3

Development, Suggestions / Process inter-list dependancies during imports

« on: August 16, 2006, 11:54:19 am »

I found something I consider a bug but it could be by design - what do  you guys think?

I have a list (let's call it "Registered List") that is set to automatically remove a user from a different list ("Demo List") when they subscribe. This is using the "When users are added to this list remove them from the following list(s):" feature. If I do a batch import of users to the registered list, I would expect it to also remove the users from the "Demo" list. However, if the user is already on the Registered list, it is seen as a duplicate and is not added but it then does not check to see if it should be removed from the Demo list.

So for me, I'd like the inter-list dependancies tested whether or not the email address is a duplicate - both for subscribes and for imports.

Is my description clear? Does that make sense? What do you think?

Thanks,
Chris

4

Development, Suggestions / BUG: Scheduled Emails with Selection rules fail

« on: August 10, 2006, 07:48:34 am »

Twice I have gotten this error:

HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/html]
 Done!<br><br />
<b>Fatal error</b>:  Cannot redeclare selection() (previously declared in /XXX/listmail/selfunc.php:7) in <b>/home/www1/public_html/listmail/selfunc.php</b> on line <b>6</b><br />

It happens when I have 2 scheduled emails to go out using daily mail. Both emails used user selections rules. I am still running version 1.85.

Has anyone had this problem? Thanks.

5

Development, Suggestions / Bug in allowdupes

« on: March 10, 2006, 11:17:06 am »

If you use the 'allowdups' option and someone signs up for the second time to a list, the UID for that user gets set to '1' rather than retaining their previous UID as expected.

There is a typo in line 94 of signup.php where there are 2 commas in a row. Take out the double comma and it works again.

Code: [Select]

  if(mysql_num_rows($result)>0){
    list($xid,$xuid,$xcnf)=mysql_fetch_row($result); <-- this line
    if($xcnf=='2' || $xcnf=='0'){


6

Server Optimization, Tweaks / What's your sending speed?

« on: April 06, 2005, 02:23:41 pm »

I have a dedicated cpanel server. My sending speed has rarely been lightning fast, but it seems slower now with the 1.8 update.

I used to send about 2 emails/second. Now I am sending 1.03 emails/second.

Has anyone else noticed a speed decrease (or increase) with the 1.8 update? What speeds are other people achieving?

 I had already added the database index as well as the other cpanel optimizations mentioned here before doing the 1.8 update.

Any other ideas on increasing performance? Thanks.

7

Development, Suggestions / BUG: User Selection - All Lists

« on: April 06, 2005, 02:14:01 pm »

Trying to make a User Selection rule to send to all users on all lists and filtering duplicates.

Make a User Selection rule of "Active - All Lists" and leave the next popup to "- More".
Click the "Show Query" button.
I see:
"SELECT * FROM lm_users WHERE (1 and cnf = '1') group by email;

54455 users matched"
Then Click "Save Selection"

Then click "Send An Email" and use the selection rule built above. This should email to all users, but instead, it finds 0 users. Below is the debug info:
tolist=rs1
not-numeric - to ruleset
tors=1
CMD=SELECT email,id FROM lm_users WHERE (list = '0' and cnf = '1') group by email
num_rows=0
Done!

Note that it puts in a list = 0 which causes no users to be found.

---

PS. Could you please include the date and time of the last update in the Members area next to the Download ListMail links? Since we don't have incrementing version numbers, it would be a way to know when/if you have posted changes since the last time we downloaded the package. Thanks.

8

Development, Suggestions / Bug: "Show Query" changes comparison operator

« on: April 05, 2005, 10:00:49 pm »

Make a User Selection rule and set it to "Active - All Lists - Search - Exact - in Last Name". Click "Show Query" and when the page reloads, the "Exact" has been changed to "<=.


Also, I did a search with all lowercase letters in the Last Name field, and it matched a last name in the database which was capitalized. I like this behavior but I question the help text on that screen that says "Searches are case sensitive" - it seemed that it was case insensitive.

9

Development, Suggestions / Overwite Dups (retain UID)/Optl Welcome Mess/Personal HTML

« on: April 02, 2005, 08:01:12 am »

Dean,
Thanks for the new version! I am integrating the modifications I did to 1.77 into 1.8. I wanted to tell you my modifications to see if you want to integrate my code into the release version or integrate the functionality. The mods are all to signup.php:

1. I added code so that if you overwrite duplicates (overwrite_dupes) it will retain and reuse the original records UID code. I have a local database where I have a copy of their UID and this allowed me to match up a duplicate and treat it as an update rather than a whole new entry. It also helps with unsubscribes - if someone does a duplicate signup, their old unsubscribe links (using UIDs) will still be valid.

2. I added an optional "sendwelcome=yes/no" field to signup forms which can suppress the sending of the welcome message. This is not an option I give users, but I have some internal signup pages for my employees to manage the lists. I didn't want to give them access to the entire ListMail interface so I have the special signup page where they can decide if a Welcome Message should be sent.

3. I added the ability to use some message codes to customize error messages. !fname, !lname, !email and !id. That way, I can say, "Joe, your email address, joe@blah.com is no longer subscribed to this list".

Let me know if you have any questions or would like the code I wrote for these.

Thanks.

10

Development, Suggestions / Email notification of bounced users broken in 1.77B

« on: July 02, 2004, 06:37:54 pm »

It appears that the email notification of a bounced user no longer works if you use a threshhold and if you have bounced users removed from the database. In 1.77b the user is removed from the database before the notification email is sent which disables the ability to send the email because the user is no longer in the database.

This happens toward the bottom of function bounce(). mysql_query("delete... is called before sendnotif().

Here is the fix that worked for me:

Code: [Select]

    if($calc <= $days){
      $lrow = mysql_query("select listopts from $ltable where listnum = '$list'");
      list($listopts)=mysql_fetch_row($lrow);
      $listopts = explode(';',$listopts);
      $narr = getnotifs($list);
      if($narr[3]=='1') sendnotif('rem_bounce',$id,'',$msg);
      if($listopts[1]==1){
       mysql_query("update $utable set cnf = '3' where id = '$id'");
      } else {
       mysql_query("delete from $utable where id = '$id'");
      }
     } else {


11

General Help & How-To / detectsqlpath() worked in 1.77 but doesn't for me in 1.77b

« on: July 02, 2004, 12:30:46 pm »

I tried doing a backup for the first time since upgrading to 1.77b. At first, my attachments directory didn't allow writing so no file was created. There also was no error message. I set the permissions of attachments to 777 and then the backup would create a file, named correctly, that was empty. Further investigation showed that it was trying to execute the command 'no mysql/mysqldump ...'. It looks like the changes in the detection code works worse for me that the old code. I commented out the changes in detectsqlpath() as well as some of the changes in the $write area of editconf.php and it then worked as it did before.

I now see where I could hard-wire this path in the config.php file, but thought you'd like to know about my experience.

12

Testimonials, Feedback / Everyone loves ListMailPro!

« on: June 24, 2004, 01:25:45 pm »

I have been using ListMailPro for a few years now. It was the only script I found out there that did so much. On more that one occasion I have demostrated all the features of ListMail to some "know-it-all" who thought they used "the best" list program. I tell them of all the features which ListMail has and all the features that are coming. I tell them of the great tech support. By the end of the demonstration, they have to admit that ListMail is superior to anything they've ever seen and they ask me how they can get a copy.

Thanks Dean!