PHPLIST 3.0 on IIS 7

Questions & Problems about Installing or Upgrading with Version 3 phpList.
Forum rules
Please help the volunteers to help you by supplying the version of phpList you are using, browser & version and if possible, a link to your phpList installation.

PHPLIST 3.0 on IIS 7

Postby BlueLuke » 7:21pm, Tue 20 Aug, 2013

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
BlueLuke
phpLister
 
Posts: 9
Joined: 5:13am, Thu 19 Nov, 2009

Re: PHPLIST 3.0 on IIS 7

Postby BlueLuke » 6:40am, Wed 21 Aug, 2013

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
BlueLuke
phpLister
 
Posts: 9
Joined: 5:13am, Thu 19 Nov, 2009

Re: PHPLIST 3.0 on IIS 7

Postby adub » 5:00pm, Thu 22 Aug, 2013

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.
adub
phpList newbie
 
Posts: 3
Joined: 4:19pm, Thu 22 Aug, 2013

Re: PHPLIST 3.0 on IIS 7

Postby adub » 7:28pm, Thu 22 Aug, 2013

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?
adub
phpList newbie
 
Posts: 3
Joined: 4:19pm, Thu 22 Aug, 2013

Re: PHPLIST 3.0 on IIS 7

Postby BlueLuke » 11:43pm, Sat 24 Aug, 2013

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
BlueLuke
phpLister
 
Posts: 9
Joined: 5:13am, Thu 19 Nov, 2009

Re: PHPLIST 3.0 on IIS 7

Postby BlueLuke » 7:41pm, Tue 27 Aug, 2013

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
BlueLuke
phpLister
 
Posts: 9
Joined: 5:13am, Thu 19 Nov, 2009

Re: PHPLIST 3.0 on IIS 7

Postby Ckokrizzo » 3:06pm, Tue 18 Mar, 2014

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.
Ckokrizzo
phpList newbie
 
Posts: 1
Joined: 1:43pm, Tue 18 Mar, 2014

Re: PHPLIST 3.0 on IIS 7

Postby Dragonrider » 5:37pm, Tue 18 Mar, 2014

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 9724 times
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: PHPLIST 3.0 on IIS 7

Postby JohnPr » 10:30am, Mon 07 Apr, 2014

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
JohnPr
phpLister
 
Posts: 13
Joined: 10:07am, Tue 18 Sep, 2012

Re: PHPLIST 3.0 on IIS 7

Postby Dragonrider » 10:48am, Mon 07 Apr, 2014

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.
My sites:- http://wharfedalefestival.co.uk, http://ilkleygardeners.org.uk, http://emergencyaid.net, http://dragonrider.co.uk
Latest phpList version is now 3.0.12 (3 February 2015) and requires a minimum of MySQL 5.0 and PHP 5.3.x
Dragonrider
Moderator
 
Posts: 3460
Joined: 6:58am, Sun 02 Jul, 2006
Location: Ilkley, West Yorkshire, United Kingdom

Re: PHPLIST 3.0 on IIS 7

Postby JohnPr » 11:02am, Mon 07 Apr, 2014

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?
JohnPr
phpLister
 
Posts: 13
Joined: 10:07am, Tue 18 Sep, 2012

Re: PHPLIST 3.0 on IIS 7

Postby JohnPr » 9:12am, Tue 08 Apr, 2014

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.
JohnPr
phpLister
 
Posts: 13
Joined: 10:07am, Tue 18 Sep, 2012


Return to Installing and Upgrading

Who is online

Users browsing this forum: No registered users and 1 guest

cron