error occurred during upload process

opiyo

New Member
Having installed MLM on my server I keep getting the 'error occurred during upload process' error when trying to upload lists. How do I resolve this?
 

stanbusk

Administrator
Staff member
What version of MaxBulk Mailer are you using? What version of MLM? Are you uploading a list that already exists in MaxBulk Mailer? Have you tried to change the upload settings?
 

opiyo

New Member
Mailer version is 8.4.9 Pro, updated last week. MLM version is 3.1.6
Yes I'm uploading a list that already exists in MBM. I have modified MLM upload setting from 1000 to 250 recipients. Interval remains unchanged. The list I'm uploading contains only 20 recipients.

I've contacted my web provider. They can't identify a security issue from their end. They've suggested I share my weblogs with you to see if we can identify the issue and revert back to them.

I've tried a few other uploads and I noticed that my lists are indeed getting uploaded to the folder 'uploads'. So why is MBM displaying the list upload error?

I've sent myself a message and tried to unsubscribe. I keep getting:
'Error: Subscription cancellation failure
We're sorry, but the cancellation of your subscription to list 'Test' has failed due to a server error. Please wait a while and try again. If the problem persists please contact us at'

Does this mean MLM is not working correctly? are the other functionalities like click through tracking etc going to work?
 

stanbusk

Administrator
Staff member
Perhaps the error comes from somewhere else. Are you using mySQL to store the data?
 

opiyo

New Member
Hi Stan,
Yes I'm selecting mySQL in MLM settings.

After days of poring over blogs and manuals for clues I've tried many things, achieving partial results here and there but nothing seems to globally resolve MLM functioning. I've done CHMODs, manual installations, modifications in lm_setting.php, tried different server address and credentials, run diagnostics...

Amongst other things I'm wondering about the right ID and passwords to use in MLM settings. I have 2 sets of credentials that I use. One for managing our account with the web provider - subscribing to services, setting up e-mails, etc. The other for FTPing to our website. I've tried both and they both seem to work equally. However running diagnostic on lm.php on web browser I get the following result indicating an issue with server address & credentials:

However if I manually change storage settings in lm.php from '1' to other names, diagnostic returns:

In this case I can access MLM on browser and be able to create lists receive unsubscribe notifications even though the e-mail in question is not deleted from the list. But in this case BulkMailer is no longer able to upload lists to MLM and statistics returns returns invalid URL error for http://www....../lm/lm.php thus no hope of tracking either

If I keep storage type unchanged, retaining everything, except CHMOD to 755, as installed automaticaly via BulkMailer I manage to upload BulkMailer lists to MLM and get Statistics running. But in this case creating lists via web browser produces the error:
Error - Server problem when reading list. [: ]' and I receive e-mail notification Subject: '[MLM] mySQL Connect Error in RequestExistsInDB()
with the message
Service unavailable!
Also in this case Unsubscribe requests return the error:
Error: Subscription cancellation failure
We're sorry, but the cancellation of your subscription to list 'Test' has failed due to a server error. Please wait a while and try again. If the problem persists please contact us at ....
Does this give indication as to where the problem might lie? Could you point me in the right direction
 

stanbusk

Administrator
Staff member
Keep the mySQL setting to '1'. The diagnostic shows the account ID and password may be wrong. Have you ask your server for the right credentials? and mySQL address?

The MLM credentials are listed at the beginning of the lm_settings.php file:
Code:
// -- Access data & Notifications ----------------------------------------------

$admin_id            = "admin";                             // Your administrator ID
$admin_password      = "admin";                             // Your administrator password
This is the default with 'admin', your will display something different.
 

opiyo

New Member
Have you ask your server for the right credentials?
I've contacted my server and am waiting for response. But which credentials do you mean? the ones I use for my manager control panel or the ones I use for FTP. I know and have tried both.
and mySQL address?
The address to which mySQL? the one in LM (I'm assuming LM contains a mySQL database in it and I know the correct address to where it is located in my web folder) or the other 5 mysql databases acquired from my web provider. I have an old folder called mysql in the server folder which also contains my website (www). Other folders such as apache, php etc are located at the same place. Are you referring to the address of myQSL at this location?

For LML credentials have tried
1.- Your MLM User ID and Password: Choose whatever you prefer here!...
as advised in your manual. I initially tried tried a new ID and password, then tried the ones for my manager control panel, then my ftp ID and password. Whatever I use doesn't seem to change anything as far as diagnostic test results are concerned.

Another question. Could it be that I need to order a new mysql database from my web provider to use with MLM?

Do you offer an installation service that could get this up and running in a short time. I have very urgent mailing that has been waiting for weeks. I'm beginning to wonder if I'd it would not be wiser to resort to mailing services like everybody else around me.
 

stanbusk

Administrator
Staff member
I've contacted my server and am waiting for response. But which credentials do you mean? the ones I use for my manager control panel or the ones I use for FTP. I know and have tried both.
No, I am talking about your mySQL credentials.
The address to which mySQL? the one in LM (I'm assuming LM contains a mySQL database in it and I know the correct address to where it is located in my web folder) or the other 5 mysql databases acquired from my web provider. I have an old folder called mysql in the server folder which also contains my website (www). Other folders such as apache, php etc are located at the same place. Are you referring to the address of myQSL at this location?
MLM needs you to enter the right mySQL server address and the right credentials. MLM has no idea, you have to tell him.
as advised in your manual. I initially tried tried a new ID and password, then tried the ones for my manager control panel, then my ftp ID and password. Whatever I use doesn't seem to change anything as far as diagnostic test results are concerned.
It is MLM user ID and password. Actually you need your FTP user ID and password in order to install MLM on your server, MLM user ID and password to access MLM but you also have to provide your mySQL user ID and password to MLM so he can connect to your server.
Another question. Could it be that I need to order a new mysql database from my web provider to use with MLM?
If you want. You can use an existing database or create a new one.
Do you offer an installation service that could get this up and running in a short time. I have very urgent mailing that has been waiting for weeks. I'm beginning to wonder if I'd it would not be wiser to resort to mailing services like everybody else around me.
No we don't but actually all you need to know is explained here: How to install MLM on my server. I believe it is better you do it yourself, it is not that complex.
 

opiyo

New Member
Excuse my lack of knowledge but let me verify that I understand one thing correctly.
In the box 4 of step #1 of MLM settings (illustration below) I need to enter mySQL ID and password that are provided by my web host when I acquire a mySQL database from them? This would normally be different from the credentials I use to log into my server Control Panel or the ones I use for FTP?
And for the box 'Database' I must enter the name of the same mySQL database provided by my host?
 

opiyo

New Member
Eureka! cracked it. I needed to get MLM & MBM to work with the PHPAdmin/MySQL database provided by my web hosting provider. It is so easy but there is no way I would have got it relying solely on the information in your instruction manual. I have had to spend a lot of time searching all over the internet and reading stuff way too technical. I think it would help a lot to indicate clearly that one needs to get their own mySQL to work in conjunction with with MLM. This is not clear at all to someone with no notion of the concept.
 

stanbusk

Administrator
Staff member
What do you mean? Actually you don't have to do anything except if your system is not or badly configured. PHPAdmin is not needed, it is a mySQL front-end. Usually you ask your web hosting support to create a mySQL database and that's all to it.
 

opiyo

New Member
oops, it seems I stumbled upon the wrong way to get MLM to work right, at least for the moment. I've used one of my old MySQL databases preinstalled by my hosting provider alongside PHPAdmin. I wasn't sure I needed to order a new mySQL database. A basic database from my hosting provider costs 48€ per yr so I wasn't going to get one without being sure of how to use it and if it would work with MLM.

you don't have to do anything except if your system is not or badly configured
Maybe the mySQL folder was not placed at the right location by my previous webmaster. It is not in the folder called 'www' where I have my website in which I have installed LM. It is located in the master folder that contains everything - I don't know what you call this location.

So I will reinstall differently when i'm done with the current mailing but for the moment, perhaps by some miracle it seems to work. I've been able to upload lists (with close to 2000 addresses) to to MLM and I'm using it to send mail, I'm getting unsubscribe, delivery, bounce, open, click statistics both on the MBM interface as well as even more detailed info on recipients via PHPAdmin online.

I'm also receiving unsubscribe e-mail notifications etc. It seems to me all the functionalities are working, apart from the 'error occurred during upload process' message on MaxbulkMailer when time I try to upload lists via it. The lists it seems are getting uploaded to MLM. Browser diagnostic indicates everything is working OK see attachment below ????
 

stanbusk

Administrator
Staff member
The diagnostic output is fine. All is OK.
Now, if you have troubles uploading you have to contact your web server support. Given security settings can prevent the upload to be achieved properly.
 

opiyo

New Member
Thanks Stan, it has been a long road to here. I'm managing to upload but MaxBulkmailer keeps showing the upload error. Maybe it does not matter.
 

stanbusk

Administrator
Staff member
It is something you need to discuss with your server support. They have to adjust the security settings accordingly to your needs.
 
Top