can't create lists

[casadeferro]

Hi there.
I sure to be missing something, but I get an error every time I try to upload or create a MLM list:

If I go to my domain.com/lm/lm.php and create a new list I get the following error:
Error - Server problem when reading list. [: ]

If I try to upload a list via MaxBulk menu I get:
An error occurred during the list upload process

could you please be so kind to help?

 

[stanbusk]

Are you using mySQL to store the lists?

 

[casadeferro]

I am!

 

[stanbusk]

Are you sure your mySQL data is correct?

 

[casadeferro]

no, can you help me making it sure?

 

[stanbusk]

I can't help you, that data is private between you and your server.

 

[casadeferro]

my database is OK and running. The user for this db has ALL PRIVILEGES...

 

[stanbusk]

What version of MLM are you using?

 

[casadeferro]

$script_name = "Maxprog List Manager";
$script_version = "3.0.8";
$copyright = "Copyright (c) 2008 - 2012";
$languages = array( 'en', 'fr', 'de', 'es', 'it', 'nl', 'cz' );

$dec_quotes = ENT_COMPAT;
$dec_charset = "UTF-8";

$allowdups = 0; // Allow duplicate email addresses
$rowsperpage = 100; // Recipients per page when displaying a list thru the web interface

 

[casadeferro]

hi there. Are you investigating this?

 

[stanbusk]

Are you 100% sure your mySQL settings are correct?

 

[casadeferro]

I know "data is private between you and your server". But I don't have any data on my DB.
You will have to trust my word on it, unless you have know a way to confirm that MySQL settings are properly configured?

 

[stanbusk]

You could check that with the mySQL server administrator. I guess it is the way to go here.

 

[casadeferro]

I feel like I've bumped into a brick wall...
I have on MySQL version 5.5.29, with 12 db up and running smoothly:
Total databases: 12
Total tables: 291
Combined size for all databases: 40.16 MB

the only db with no tables or data is MLM db... I'm sure it isn't from MySQL

 

[stanbusk]

Have you asked your mySQL server administrator about that? Have you checked your login data with him/her?

 

[casadeferro]

grrr... My lm_settings.php was:
$dbhost = 'mywebsite.com';

changed it to:
$dbhost = 'localhost';

it works.

 

[awpeterson]

grrr... My lm_settings.php was:
$dbhost = 'mywebsite.com';

changed it to:
$dbhost = 'localhost';

it works.

Okay, someone should make this a sticky solution on the forum. We, too, had the same difficulty and this solved our issue.

 

[kjmm]

me to

grrr... My lm_settings.php was:
$dbhost = 'mywebsite.com';

changed it to:
$dbhost = 'localhost';

it works.

tks