0015351: Bug in MySql installation script of PHPList

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0015351

[phplist] Installation

major

always

20-10-09 20:14

29-10-09 17:15

Reporter

shez001

View Status

public

Assigned To

Priority

normal

Resolution

no change required

Status

resolved

Product Version

2.10.10

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.

Additional Information

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

Relationships