[MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB()

[lithoart]

I get this error message sent into my inbox
"[MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB()"

The body of the email contains:
Service unavailable!
:

What does this mean?

What triggers this error?

How do I troubleshoot this?

I have also check that the 'lm' folder permissions are 777 .

I am using mySQL.
Attached is a screenshot of the mySQL tables. (Just in case you need it).

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

Do you always get that error or you only received it once?

 

[lithoart]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

I get it all the time. I receive a lot of them through out the day.

I don't know what triggers it.

I have tried doing the following:
-subscribe
-unsubscribe
-getting the available lists
-Getting a subscriber list
-Removing lists
-Renaming a list
-Getting info

using the various URLs/commands.

They ALL work ok.

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

It is when MLM try to delete the subscription request fro the database. What MLM version are you using?

 

[lithoart]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

Found in lm.php file --- V.3.0.3

It is when MLM try to delete the subscription request from the database

I get the email confirmation stating:

EMAIL ADDRESS has unsubscribed from LIST

So does it mean that I get the acknowledgement email that someone unsubscribed,
but the email is NOT actually unsubscribed from the list?

When I reload the list for my next mail out, I get a message that some people have unsubscribed
and I select the option to unsubscribe and save the list.

Is this a different thing?

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

It is a different thing. This is an error when deleting the request, only the request.

 

[lithoart]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

It is when MLM try to delete the subscription request fro the database.

Is there a fix for this?
How do I further troubleshoot this?

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

I am not sure, you are the only one right now with this problem. I remember something similar on this same forum a couple of months ago. The user fixed the problem himself.

 

[lithoart]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

Recently got this error message sent to my email.



What triggers this?
What's the fix for this?

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

The error says: "The server has gone away". That means the connection between your web server and the SQL server is broken. That can be a temporary situation. The best in any case is to contact your web server support. Note that MLM has a SQL queue. On error like this, the query is added to the queue. As soon as the server is available again, MLM empty the queue running all queries. That way you never lose anything.

 

[lithoart]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

If I contact my web server support about this, what do I ask them?

 

[stanbusk]

Re: [MLM] mySQL Connect Error in RemoveExpiredRequestsFromDB

Send them the screenshot you sent to me. That will help a lot.