0015351: Bug in MySql installation script of PHPList

Create

Capture

Maintain

Audience

View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0015351

phplist

Installation

public

20-10-09 20:14

29-10-09 17:15

Reporter

shez001

Priority

normal

Severity

major

Reproducibility

always

Status

resolved

Resolution

no change required

Platform

OS Version

Product Version

2.10.10

Target Version

Fixed in Version

Summary

0015351: Bug in MySql installation script of PHPList

Description

After installing PHPList on server and going through the admin panel I noticed that I was receiving errors such as table does not exist. This was very strange so I decided to do some further investigation.

Findings:

On line number 1087 in the phplist.sql:

INSERT INTO `phplist_user_blacklist_data` VALUES ('billgates@microsoft.com','reason','I\\\'m not really that interested in your newsletter anymore. Sorry.');

This is not correct as the \\\ in the query escapes the rest of the sql and the remaining tables are not executed this results in a broken installation.

The correct sql is:
INSERT INTO `phplist_user_blacklist_data` VALUES ('billgates@microsoft.com','reason','I\'m not really that interested in your newsletter anymore. Sorry.');

After doing this fix and adding the tables below this line number everything worked perfectly.

Notes
(0050760) michiel (administrator) 29-10-09 17:15	the sql file is not used in installation

Relationships