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

Create

Capture

Maintain

Audience

View Issue Details [ Jump to Notes ]

[ Print ]

Project

Category

View Status

Date Submitted

Last Update

0011163

phplist

All Other

public

27-08-07 20:02

18-02-08 14:08

Reporter

bas

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

related to

0003721

closed

phplist 2.10.x

Notes
(0031239) bas (developer) 29-08-07 15: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.