Page 1 of 1

PHPLIST 3.0 on IIS 7

PostPosted: 7:21pm, Tue 20 Aug, 2013
by BlueLuke
I manage to install PHPList on IIS 7.

I was getting this error when I tried to save stuff in the configuration section in the admin.

"Database error 1366 while doing query Incorrect integer value: '' for column 'editable' at row 1"

Basically, this comes from the table "phplist_config", the 'editable' colum is a tinyint(4)

What happens is that their are 2 config settings that try to update this column with an empty string ''.

They are "tld_last_sync" and "internet_tlds" which causes this to happen.

If you edit the values in these tables..

Set the internet_tlds to
Code: Select all
'ac|ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|asia|at|au|aw|ax|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cat|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cu|cv|cw|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gg|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|im|in|info|int|io|iq|ir|is|it|je|jm|jo|jobs|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|me|mg|mh|mil|mk|ml|mm|mn|mo|mobi|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|post|pr|pro|ps|pt|pw|py|qa|re|ro|rs|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sx|sy|sz|tc|td|tel|tf|tg|th|tj|tk|tl|tm|tn|to|tp|tr|travel|tt|tv|tw|tz|ua|ug|uk|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|xxx|ye|yt|za|zm|zw'


and set the last sync to "tld_last_sync"
Code: Select all
1376970593


And make it non-editable buy setting the editable column to 0.

If you make it editable, then the errors will come back because it will try to insert an empty string into an integer column. Once it's set you shouldn't have to edit these values anyhow.

I hope this helps all the IIS 7 people. Last night, I couldn't find any posts anywhere on how to fix this condition. So I figured it out on my own and now there is a post for people to find and save them the frustration.

Henry
http://www.phphelp.com
http://www.unlocktheinbox.com

Re: PHPLIST 3.0 on IIS 7

PostPosted: 6:40am, Wed 21 Aug, 2013
by BlueLuke
There's a few more steps that's needed.

1) In the phplist_list table I had to change the active column name from a tinyint(4) to a varchar(4)

2) In the config.php you need to tell it to use your smtp mail server, you can't use sendmail which it's defaulted to on windows.

I'll follow up with any other issues I have - I haven't tried all of the functionality out yet. But I'm able to send out emails at this point.

Henry
http://www.phphelp.com
http://www.unlocktheinbox.com

Re: PHPLIST 3.0 on IIS 7

PostPosted: 5:00pm, Thu 22 Aug, 2013
by adub
Thanks for this info...I just upgraded and had this issue.

BlueLuke wrote:2) In the config.php you need to tell it to use your smtp mail server, you can't use sendmail which it's defaulted to on windows.


This is not required if you have your php install setup correctly to be able to send mail, I believe it is defaulted to use php's mailing function.

Re: PHPLIST 3.0 on IIS 7

PostPosted: 7:28pm, Thu 22 Aug, 2013
by adub
BlueLuke wrote:Basically, this comes from the table "phplist_config", the 'editable' colum is a tinyint(4)

What happens is that their are 2 config settings that try to update this column with an empty string ''.

They are "tld_last_sync" and "internet_tlds" which causes this to happen.


I upgraded from the previous version and do not have those two settings in my phplist_config table...any ideas?

Re: PHPLIST 3.0 on IIS 7

PostPosted: 11:43pm, Sat 24 Aug, 2013
by BlueLuke
If you upgraded, then go into your configurations and edit something and hit save, it will try to add those two settings and crash, unless you make the modifications listed.

Henry
http://www.phphelp.com
http://www.unlocktheinbox.com

Re: PHPLIST 3.0 on IIS 7

PostPosted: 7:41pm, Tue 27 Aug, 2013
by BlueLuke
On to the next IIS 7 challenge - This might apply to Apache installs as well..

When checking the spam score of the emails going out, I was being flagged by this..

Code: Select all
2.4 FSL_HELO_BARE_IP_2 FSL_HELO_BARE_IP_2
        1.2 RCVD_NUMERIC_HELO Received: contains an IP address used for HELO


For an added spam weight of 3.6 (Which is not good)

to fix it I had to modify the lists\admin\class.phplistmailer.php file and make the change below.

Code: Select all
//$sTimeStamp = "from $ip_domain [$ip_address] by $hostname with HTTP; $request_time";
   $sTimeStamp = "from [$ip_address] by $hostname with HTTP; $request_time";


Removing the $ip_domain fixed this condition because Spam Assassin see that as a bare IP and a Numeric HELO.

I have one more spam flag left to deal with - before I can actually send an email blast - will post updates as soon as I solve it.

Henry
http://www.phphelp.com
http://www.unlocktheinbox.com

Re: PHPLIST 3.0 on IIS 7

PostPosted: 3:06pm, Tue 18 Mar, 2014
by Ckokrizzo
BlueLuke wrote:
They are "tld_last_sync" and "internet_tlds" which causes this to happen.


I can not find this at all in the SQL Database. I have looked in several areas and still can not find it.

Re: PHPLIST 3.0 on IIS 7

PostPosted: 5:37pm, Tue 18 Mar, 2014
by Dragonrider
Ckokrizzo wrote:
BlueLuke wrote:
They are "tld_last_sync" and "internet_tlds" which causes this to happen.


I can not find this at all in the SQL Database. I have looked in several areas and still can not find it.

Look at your phpList database in phpMyAdmin, select your phplist_config table, as stated above, I've highlighted the two records mentioned.

Hope that helps.
tlds.jpg
tlds.jpg (92.67 KiB) Viewed 12259 times

Re: PHPLIST 3.0 on IIS 7

PostPosted: 10:30am, Mon 07 Apr, 2014
by JohnPr
No, didn't help for me. I have the same problem. New install. FreeBSD. Mysql 5.6.17 PHPlist 3.0.5.

I do not have these two rows in my "phplist_config". I have 59 other rows. Using Webmin.
Also made changes in my.cnf without solving this problem.

But what doesn't work with this error: Database error 1366 while doing query Incorrect integer value: '' for column 'editable' at row 1

Re: PHPLIST 3.0 on IIS 7

PostPosted: 10:48am, Mon 07 Apr, 2014
by Dragonrider
JohnPr wrote:But what doesn't work with this error: Database error 1366 while doing query Incorrect integer value: '' for column 'editable' at row 1


A quick search brings up this possible solution.

Re: PHPLIST 3.0 on IIS 7

PostPosted: 11:02am, Mon 07 Apr, 2014
by JohnPr
Not very helpful for me. Is it a mysql problem or a Phplist problem?

If I move on with this problem, what will not work?

Re: PHPLIST 3.0 on IIS 7

PostPosted: 9:12am, Tue 08 Apr, 2014
by JohnPr
I am still stuck. Nobody can explain this to a non-expert? I do not have the above mentioned rows.

Can I ignore this error (I don't think so) ????

And I think it is a PHPlist bug. It is a fresh install of the latest PHPlist on the latest MySql. It isn't an update. There shouldn't be an error.

The only other option I have left, is deleting PHPlist and finding something that does work.