0011163: SQL error on import: syntax error near 'data' since additional data is used

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

0011163

phplist application

All Other

public

27-08-07 21:02

18-02-08 14:08

Reporter

user1822

Priority

normal

Severity

major

Reproducibility

have not tried

Status

resolved

Resolution

fixed

Platform

OS Version

Product Version

Target Version

2.10.7

Fixed in Version

2.10.5

Summary

0011163: SQL error on import: syntax error near 'data' since additional data is used

Description

using import2 I import a file with 5 users, 3 unknown fields.
I choose to add 2 and map the third to 'extradata'
phplist imports all 5 users issuing 5 errors on select bla from bla where id = additional data
which is wrong twice:
• additional data is the nice name of extradata and should not end up in under the additional data
• id should not be this name, it should be an email (or username in some systems)

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

0003721

closed

phplist 2.10.x

Notes
(0031239) user1822 29-08-07 16:24	Fixed, code contains too many arrays with mappings and attributes IMHO. It works now but needs mayor redesign to be truly maintainable. KNOWN ISSUE: When using test preview, system attribute mapping will be lost and needs to be selected twice. Annoying but no loss of functionality or reliability so I'll leave this for now.