0017615: Messagedata table has incorrect id field

NOTE:: Before reporting an issue, make sure you are running the latest version, currently 3.3.1

View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0017615

phplist application

Message Send Process

public

09-03-15 12:05

06-07-15 18:04

Reporter

duncanc

Priority

normal

Severity

minor

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

OS Version

Product Version

3.0.12

Target Version

3.0.X

Fixed in Version

3.2.0

Summary

0017615: Messagedata table has incorrect id field

Description

The messagedata table duplicates some fields that are held in the message table. One such is the id field, and that causes a problem when a message is created by the repeat processing.

Message 5 was the original message. It has an id field on the message table of 5 and a row in messagedata with name 'id' and data 5.
After message 5 has been repeated, there is then a message 6 but it has a row in messagedata with name 'id' and value 5, not value 6.

When the message data is loaded, possibly through function loadMessageData(), the id field is being set to the value from the messagedata table instead of from the message table.

I noticed this when trying to use the plugin method cansend(). The $messagedata parameter has the wrong id value when it is a repeated message.

Notes
(0055970) michiel (manager) 09-03-15 21:23	Ah, yes, that can have weird consequences. It will be better to avoid it.

(0055991) duncanc (developer) 29-03-15 11:15	See GitHub pull request https://github.com/phpList/phplist3/pull/5 [^]

Relationships [ Relation Graph ] [ Dependency Graph ]