Hello,
When importing a contact file by selecting “create and update”, this error occurs:
Error: “You could not update this record”.
The contacts are updated, but 20 contacts that should be created are not and produce this error.
Thank you for your help.
I can’t find this error message anywhere in the code base. Is it the exact message?
This is the error message:
“The record could not be updated due to a permissions issue”
Maybe you have a record in the system which already has the same id. This can occur if you’re repeating an import, and your import uses ids.
Can you please tell us which version of SuiteCRM you are using?
Please share your csv file which you’re using for import contact.
my version 7.11.20
I have no contacts with the same ID.
I tried to import them by doing “create records” and it worked.
However, the problem persists when I do “create and update”.
Would you have an idea?
Thanks
Do you know the id of the record that fails to update?
Hi @pgr,
yes I know the id.
I tried again but the problem persists, it updates the existing contacts but does not create new ones
Go in phpMyAdmin and select the SuiteCRM database (not a specific table, but the database itself).
Click the Search tab on top.
Paste the record id into the search box.
Select ALL tables in the “inside tables” area. An easy way to do this is to click the first one and then press “ctrl-shift-end”.
Your screen should look something like this:
Now click to search, and scroll down to examine in which tables that id was found. This might explain why it is considered a duplicate. Searching here in the database, instead of from the UI, ensures you’re not restricted by security groups or any other filters.