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
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