FMLP Software error on Save of HTML messages only

[leadman]

DR Q,

For the most part, your FMLP works great. I installed it months ago and it has been trouble free up until recently.

When I make an html message (with the html message as default) and go to save it, I get the following error:

Software error:

SQL error:
INSERT INTO swd_mess (`days` , `defmesstype` , `encoding` , `fk_account` , `mess` , `messhtml` , `messrss` , `priority` , `rsslink` , `saveinhistory` , `senddat` , `subject` , `type` , `typesend`) VALUES ('0' , '2' , 'iso-8859-1' , '25' , NULL , 'test' , NULL , NULL , NULL , NULL , NULL , 'test 2' , 'html' , 'manual')
: ERROR: 1048 - Column 'mess' cannot be null at lib/dbfunc.pm line 151.

Most of the time, the message never saves and I have to start over again.

I do not get this error when I make a simple text only message.

Because of this error, I have had to make the message a simple text message, save it, and then go and change it into an html message. I do not get this error on the second save.

Lastly, I am not using the RSS function at all, nor am I checking the RSS box.

I'm going to assume this problem is a database settings issue and not your software.

Please advise as to your thoughts on the subject.

[drquek]

Hmmm... I never came across this problem before.

[leadman]

DR Q,

It seems that the database is not allowing 'NULL' values for various tables.

Software error:

SQL error:
INSERT INTO swd_conf (`conf_value` , `fk_account` , `pk_conf`) VALUES (NULL , '0' , 'OLD_ALGORITHM_PROC')
: ERROR: 1048 - Column 'conf_value' cannot be null at lib/dbfunc.pm line 151.

Is it OK to change the database tables to accept NULL values? Or does FMLP setup the database automatically to NOT accept null values for a reason?

I don't want to corrupt the database with a bunch of Null values, but the only way to eliminate this error on my install is to change database table settings to allow NULL values.

[drquek]

Please do not change the NULL values unless you know what you are doing.
Is there any reason you want to do so?

[leadman]

I had to change a few tables to allow NULLS because I was getting errors and FMLP wasn't saving messages I spent alot of time to create.

Now, the software seems to be working well - without errors.

I haven't come across any negative effects from doing this. Like I said, I only changed a couple tables where the errors were being generated. Now I no longer have errors or problems. It may be specific to my host server.

[drquek]

Thanks for posting.

[drquek]

Hi Leadman,

I came across an server with the same problem.

Can you tell me how you rectify your problem?

Software error:


SQL error:
INSERT INTO swd_conf (`conf_value` , `fk_account` , `pk_conf`) VALUES (NULL , '2' , 'subscribeemail')
: ERROR: 1048 - Column 'conf_value' cannot be null at lib/dbfunc.pm line 151.</pre> For help, please send mail to the webmaster (webmaster@thenutstand.com), giving this error message and the time and date of the error.

[vincpl]

I'm having the same problem. It worked fine up until just recently. I don't understand how it could change on its own.

What do I have to do to get this working again?

Thanks.

[drquek]

Read Item 8 of:

http://www.doctorquek.com/forums/showthread.php?t=62