MLM upload mailinglist problem

[nicolasbulb]

I've got a mailing of 3090 contacts and I've wanted to upload them on the MLM SQL database using the html upload command.
I've entered all the needed informations and then clicked "upload" to filled my database with the data.
When I checked on the mySQL table to see if the contacts were correctly upload I've noticed that only 2903 contacts are on the server. ?????
I've also noticed that the "upload" script didn't gave any confirmation or errors message at all. The page was just blank.
I've then checked carefully what was the 2904 contacts and created a list that contains the missing 187 contacts and used the same "upload" script. This time, I've had a confirmation that the 187 were correctly uploaded on the server.
How come MLM can't process the entire contact list?

This is a bit disturbing?

Thanks.

 

[stanbusk]

I guess an unexpected error happened during the import and let the script without a response. When you upload a list and you got no acknowledgment that the list has ben uploaded successfully it is because something went wrong. Perhaps the mySQL connexion was broken in he middle of the import. Have you tried to re-upload the full list again?

 

[nicolasbulb]

Yes I did try several times and everytime it hangs. That's why I've splitted the list. But this is not a handy way to work.

By the way, what's the advantages of working with SQL list vs Text list?

 

[stanbusk]

This is strange, it would be helpful if you could open a support ticket and attach the list to it. I would like to try to upload your list here and see if I can reproduce the problem, and if so, it will be easy to fix the issue.

The 'benefit' of using plain text files rather than a mySQL database is that you don't have to enter your mySQL settings. It is actually your only choice if you do not have access to mySQL on your server. The benefits of using a mySQL database rather than a plain text file are obvious to mySQL programmers, mySQL is faster, more secure and it allows you to maintain much bigger lists. In addition, MLM includes a SQL queue so in case the mySQL database is not available to the user for whatever reason the system will continue to accept commands from your subscribers, will post notifications by email to the administrator (you) about the problem and will try to run the commands again later. When using plain text files and because it is extremely rare to get a failure, the system will simply returns the error to the subscriber in a nice formatted HTML page.