0008106: import 'foreignkey' fails; bad SQL

Create

Capture

Maintain

Audience

Viewing Issue Simple Details [ Jump to Notes ]

[ View Advanced ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0008106

[phplist] Subscriber Import

minor

always

02-10-06 22:08

18-02-08 14:06

Reporter

bevan

View Status

public

Assigned To

Priority

normal

Resolution

fixed

Status

resolved

Product Version

2.10.2

Summary

0008106: import 'foreignkey' fails; bad SQL

Description

Importing the foreign key fails if the drop down list (on step two of the import process) is used to match a CSV column to a database field. i.e. when the foreign key column in the CSV file is not 'foreign key', e.g. it is 'foreignkey', or 'key', or 'id' or anything other than 'foreign key' (not case sensitive).

I have reproduced this error in MAMP (like xampp but for mac os x) 1.0 beta (PHP 4, MySQL 4.0)
and the latest release, 1.3.1 (PHP 4, MySQL 5.0)
which means it's not a MySQL version issue.

Additional Information

steps to reproduce:

1. create a CSV file to import with columns 'email', 'foreignkey'
2. import using /admin/?p=import2
3. match 'foreignkey' to 'Foreign Key'
4. SQL error is reported on results
5. data in 'foreignkey' on CSV was not imported into 'Foreign Key'

Let me know if you need help reproducing the error.

Bevan/

Tags

No tags attached.

Attached Files

Relationships

related to

0003721

closed

phplist 2.10.x

Notes
(0019536) michiel (administrator) 03-10-06 21:04	no, I can reproduce that, but the confusion is caused by "foreign key" being listed as one of the fields that you can map onto. If your source file has "Foreign Key" as the column name, the FK import matching will work.

(0029690) bas (developer) 23-07-07 19:49	When the user chose to map an unknown import attribute to a system attribute this attribute ended up in the $_SESSION["import_attribute"] array. A bit of code has been added which moves the attribute to the system mappings array.