View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0011163||phpList 3 application||General||public||27-08-07 20:02||18-02-08 14:08|
|Priority||normal||Severity||major||Reproducibility||have not tried|
|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.|
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.