for the last days I was trying to solve this problem, but I can't fix it, so I would like to ask you for your help.
Basis: J! 3.9.16, Seblod 3.18.2, Seblod csv Importer 1.12, php 7.4.2 running on a mamp
Since I didn't found an appropriate app/extension/plugin for J! I decided to use Seblod for building an academic image-librarie with millions of possible annotations fields. I created an app with several form-n-content-types combined as groups in a main form-n-content type. Everything works fine and looks great.
Afterwards I wanted to import the informations from the old image-libraries, like I made a few years ago within another Seblod app: in myphpadmin I exported the table to have for sure the correct spelling and order. For testing I started with the first 5 articles which should be imported by the Seblod Importer as articles, but whatever I try to upload, I always get the Error 1060 Duplicate column name 'bild_auswahl' (error enclosed)
There is no typo, it's at the correct position of the table, since it's a select-simple I changed it to a a text field, checked and changed the seperators, imported as raw-data, de/activated the forced UTF, re-worte the csv in a Texteditor, successfully imported the csv in another Seblod-app, read millions of posting in this forum, the German Seblod-forum and in mysql forums. But: I can't fix it...
Seblod Importer and J! Debug say:
Es ist ein Fehler aufgetreten!
1060 Duplicate column name 'bild_auswahl' /Applications/MAMP/htdocs/injoest/libraries/joomla/database/driver/mysqli.php:665