[SOLVED]Can't see list in MLM Stats

[mailrock]

Hi,

I have the lastest MB and have opened some lists we sent emails to last year uisng the online MLM. Was able to see Stats etc of a couple of years sends.

Now I open Preferences and get a panel to Create an MLM or make sure Prefs know where lm.php is.

I see on the site public_html there is an /public_html/lm/ folder
and a /public_html/maxbulk/lm/ folder.

Can you give me a clue how to get my prefs back again. Same domain, same everything.

Thanks

oz

 

[mailrock]

Re: Where have MLM Prefernces gone ?

Okay I have recreated MLM on the server with new database etc.

All seemed to install fine but when I go to see a newlseter Stat, I get a 403 Forbidden page.

I checked the link mentioned on the error panel via ftp and it is correct.

I placed the address in te browser and got to the Subscribe/Unsubscribe Page but it also had a 403 message on it.

Any help please while I look msyelf?

oz

 

[mailrock]

Re: Forbidden 403 message for MLM

I just thought... I am using the directory...

public_html/newsletter-lm/lm/lm.php

All dirs are 777 except file lm.php at 0644

Maybe my name change is the problem?

 

[mailrock]

Re: Forbidden 403 message for MLM

After trying a few things.. changed 777 to 755 and the 403 went.

I was also able to access the Sub/unsub page okay now.

Sent 1 email from list as a test and was told to Activate which I did. Email was sent, Delivery said Finished.

In stats shows Next Delivery with 5 under it but nothing shows when I click them all.

The email landed in my inbox fine. The MB Delivery Page was empty.

When I access Admin at the lm.php page, the list is not there.

I tried to Upload from the site also within the MB program but I got the error..

'An error occurred during the list upload process.'

I also got an email..

[MLM] mySQL Connect Error in SaveRequestToDB() Service Unavailable

Any help please while I try and find an answer?

Diagnosed

MLM 3.1.7 diagnose ran on 2016-10-17 at 01:02:03

request_uri = http://www.mysite.com.au/newsletter-lm/ ... wd=correct
path_to_script = http://www.mysite..com.au/newsletter-lm/lm/lm.php
working_directory = /home/starreco/public_html/newsletter-lm/lm

mailqueue permissions = 0755
sqlqueue permissions = 0755
uploads permissions = 0777
imports permissions = 0755
templates permissions = 0755

#1 mysqli_connect( http://www.mysite..com.au, correct, correct, starreco_newsletter )
-> Connection error )
-> Check your server address and credentials in lm_settings.php

Maxprog List Manager 3.1.7

oz

 

[mailrock]

Re: Can't see list in MLM Stats

and on it goes..

To hopefully make it easier for you to diagnose..

When I put the init script in the browser I get this

Error - Impossible to create the database or the table.
[mySQL server connection error]

I notice in phpmyadmin there are no tables in the db.

To lm.php I just get the html 'Main Menu' with the New,Upload and Find links

When I to create a new list.. I get

Error - Server problem when reading list. [:]

When I try to Upload.. I get

0 address(es) have been uploaded to '2016-list-Spring-Oct16'.
MLM has found 0 duplicate(s) and 0 bad address(es).

My host now uses Maria db.

When I go to Upload a list to MLM from within MB, I get the Upload panel but even though I have uploaded the list, in the 'To' area, I always only get 'New List'.

Via ftp I see the files in the Upload directory.. Not sure why there are 2 though..

2016-list-Spring-Oct16 74,294
2016-list-Spring-Oct16.mbm 261.098

I checked the .mbm list and it is correct one with 998 people in this list.

When I try the Upload to MLM

'An error ocurred during the list upload process'

I have copied/pasted the URL in Preferences to the browser and it gets me to the MLM, panel but no lists show.

Diagnosts gives..

#1 mysqli_connect( localhost, starreco_mine, password, starreco_newsletter )
-> Connection error )
-> Check your server address and credentials in lm_settings.php

I have checked many times and I cannot see what is wrong.

Clicking the Get info in Prefs I get..

Error - An error occurred when trying to get information about the server.
[: ]

So everywhere I see I get this connection error, but for the life of me can't see the error.

BTW I created the db in phpmyadmin prior to the MLM install.

l

m_settings.php
$dbhost = 'localhost';// mySQL Host Name
$dbusername = 'starreco_myuser'; // mySQL User Name (For Full access!!)
$dbuserpass = 'pwd; // mySQL User Password (For Full access!!)
$dbname = 'starreco_dbname'; // mySQL Database Name

After I try to Upload I get this email.

[MLM] mySQL Connect Error in RequestExistsInDB()

The whole thing baffles me I'm afraid to say.. Spent all day trying different things..

A year or so ago, it worked fine with another list and db.

oz

 

[mailrock]

Re: Can't see list in MLM Stats

Well it looks like it was a problem at my hosts.

I was using the password that I used before they updated their Cpanel scripts and this somehow caused a conflict.

They deleted it, and reinstalled it and now it seems fine as far as my tests are to this moment.

I see now the script in MLM Web menu and can access, add and delet the names there.

I will continue a few test before I send out this very late now newsletter.

Sorry I've used up some bandwidth with this..

oz