Error message - Table 'XXXXXX_dolibar.llx_adherent' doesn't exist

Using my Dolibarr
1

Hi

I’m getting the below error message when trying to delete a third party. This third party is from an earlier import. The same message appears if I activates the membership module. It’s not a new issue for me, but I think it’s about time to get it fixed. Any ideas?

Table ‘XXXXXX_dolibar.llx_adherent’ doesn’t exist

2

looks like you had once a link to a membership. adherent tables are form the membership module.
Not so sure about a solution but maybe could help to activate the membership. Check if there are some old content in it and than delete both.

3

Hey @JoHe
like Kim, I also think, that there is a link between the third party object you want to delete and an “old” member object.

You should check:

  1. The configuration parameter
    $dolibarr_main_db_prefix='llx_';
    in the configuration fiile /htdocs/conf/conf.php
    Is this identical to “XXXXXX” in the warning message?
  1. Your database: Does the table (llx_)adherent exist? (llx_) shoud match your prefix as defined before.
  2. You should enable the module “Debug Logs” and activate DEBUG logging. So you can get more detailed information an possible error messages for troubleshooting

Best regards, Marcel

1 Like
4

Can you remove the link to a member in the GUI before deleting it? If not try setting it to empty (usually the top choice.

Or Maybe using the API?