Some issues with MLM and MBM

[jo*]

Hi there,

we are experiencing some issues with MBM and MLM and would like to ask you for your help.

1. When uploading lists to MLM which were imported as tab-delimited text-files into MBM we get a failure notification in MBM. However, the lists get partially imported into the MySQL database. For example, when trying to upload a list with 5.000 recipients only 500 get imported.

As a workaround we directly imported the list as a csv-file into the MySQL database via PHPmyAdmin which worked alright but certainly isn't very convenient.

2. When opening this list in MBM via "External lists" the listname in the recipients pane a string with number of recipients, date and time gets appended ("_6647 2011-10-31 11:49:10") -> see Screenshot 1

3. When trying to remove the list via right-click "Remove" (-> see Screenshot 2) the entire MySQL table on the server gets deleted! Certainly something we don't want, especially after sending out a mailing where a certain number of recipients already unsubscribed from the mailing.

4. Before we sent out the real mailing we testdrove everything with a test-list containing 4 recipients. The mailing was delivered perfectly alright to all 4 recipients. In order to test the "Unsubsribe"-feature, two of those recipients clicked the "Unsubscibe"-Link contained in the mailing. Subsequently the 2 unsubsribers were removed and the MLM list only showed 2 remaining subscribers and the 2 recipients who unsubscribed received a notification email. Perfectly fine so far.

However, when we sent out the real mailing the unsubscribers don't get removed from the initial list. The initial number of recipients (6,534 subscribers) remains the same although there are a number of recipients (319 unsubscribers) who clicked the "Unsubscibe"-Link contained in the mailing as can be seen in the table "tbl_mlm_sub_loc" (-> see Screenshot 3)

Also, the number of unsubscribers shwon in table "tbl_mlm_sub_loc" (319) doesn't match the number of unsubscribe emails received (Subject:" has unsubscribed from 20111027_MHW_Newsletter") which is somewhat higher at 360.

Thanks for your help

 

[stanbusk]

1. When uploading lists to MLM which were imported as tab-delimited text-files into MBM we get a failure notification in MBM. However, the lists get partially imported into the MySQL database. For example, when trying to upload a list with 5.000 recipients only 500 get imported.

Click on the 'Settings' button in the 'Upload to MLM' window and select a lower number, 500 for example.

2. When opening this list in MBM via "External lists" the listname in the recipients pane a string with number of recipients, date and time gets appended ("_6647 2011-10-31 11:49:10") -> see Screenshot 1

There is no code in MLM nor MaxBulk Mailer that does that. It is a server thing :-/ Never see that before. I believe you will have to ask your server support.

3. When trying to remove the list via right-click "Remove" (-> see Screenshot 2) the entire MySQL table on the server gets deleted! Certainly something we don't want, especially after sending out a mailing where a certain number of recipients already unsubscribed from the mailing.

The MLM code doesn't remove the table, only entries. You can check the MLM code. Look at the queries we use. None remove tables.

However, when we sent out the real mailing the unsubscribers don't get removed from the initial list. The initial number of recipients (6,534 subscribers) remains the same although there are a number of recipients (319 unsubscribers) who clicked the "Unsubscibe"-Link contained in the mailing as can be seen in the table "tbl_mlm_sub_loc" (-> see Screenshot 3)

Unsubscribes are handed by deleting the recipients directly from the list. The tbl_mlm_sub_loc stores local unsubscribes, unsubscribes of local lists, list not in MLM but in MaxBulk Mailer. I guess you made an error here.