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

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0011163

[phplist] All Other

major

have not tried

27-08-07 20:02

18-02-08 14:08

Reporter

bas

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Status

resolved

Product Version

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)

Additional Information

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.