Difficulty importing a csv into atom version 2.7.1

Skip to first unread message


Nov 16, 2023, 12:30:55 PM11/16/23
to AtoM Users
Good afternoon, after I installed atom version 2.7.1 and migrated the data from version 2.3.1, I was experiencing some problems, for example:

When importing a csv the following error is issued: "php '/usr/share/nginx/atom/symfony' 'csv:import' --skip-matched --quiet --user-id="175918" --source -name='Example-accessions-2.6.csv' '/usr/share/nginx/atom/uploads/tmp/TMP557a94fb.csv'; Unable to execute INSERT statement. [wrapped: SQLSTATE[HY000]: General error: 1364 Field 'lft' doesn't have a default value]"

I don't know what the "lft" field means, could anyone help me with this?

Dan Gillean

Nov 16, 2023, 12:35:54 PM11/16/23
to ica-ato...@googlegroups.com
Hi Matheus, 

I just replied to you on the other thread you posted on, but I see you have deleted that post and started a new thread. I will point you to that thread's reply: 
In particular, see my suggestions to the previous user - have you tried that yet? I explain there that lft and rgt refer to the nested set. See: 
If you are certain that you have properly upgraded (per the checklist in my second post), then try rebuilding the nested set, running the generate slugs task, clearing the application cache, and restarting PHP-FPM to see if this resolves the issue. 


Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
he / him

Unifor.br | Instagram | Facebook | Twitter LinkedIn | TV Unifor | G1/Ensinando e Aprendendo

You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/6647885e-6f51-4f35-a078-ee169f8484adn%40googlegroups.com.
Reply all
Reply to author
0 new messages