[bug] csv import & overwrite broken SOLVED

[batonac]

I used to be able to update my data through CSV export, spreadsheet edit, and then import with overwrite on. The latest code seems to have broken this:

Duplicate entry '1' for key 'sequence_UNIQUE' SQL=INSERT INTO `grade` ( `code`,`name`,`sort` ) VALUES ( '???K','Pre-kindergarten','1' )

Apparently it's trying to do an INSERT when it should be doing an UPDATE?

 

[troester]

It's working on my site in the frontend, it isn't in the backend:
in the backend drop and override params are always 0, no matter how the settings are.

But in this case it's inserting the records with new autoincrement ids.
Is your DB table typ MyISAM or InnoDB?

 

[batonac]

Is your DB table typ MyISAM or InnoDB?

InnoDB

 

[troester]

Because import in backend was ignoring the override setting, it was inserting and breaking your "sequence_UNIQUE" restriction.

I think I've fixed it in GitHub.

 

[batonac]

Behold! It worketh! Thank-you