Trying to setup new client on my ISPConfig Server

Hello good day, please recently i am having some issue with the ISPConfig server, it has been working very fine for over 6 months already, but after the last upgrade version to version 3.2.9p1 i noticed my changes are no longer being processed in the server, at first the ispconfig log say access denied to update a table in the ispconfig database, then i give the ispconfig dabase user full privilege then i get the following error and yet the queue has refused to be processed below are the errors

Code:

Mon Mar 13 04:30:04 UTC 2023 13.03.2023-05:30 - WARNING - There is already a lockfile set, but no process running with this pid (2082). Continuing.
Mon Mar 13 04:30:04 UTC 2023 which: no incrond in (/sbin:/usr/sbin:/bin:/usr/bin:/usr/local/sbin:/usr/local/bin:/usr/X11R6/bin)
Mon Mar 13 04:30:04 UTC 2023 PHP Fatal error:  Uncaught mysqli_sql_exception: Table 'named.records' doesn't exist in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:302
Mon Mar 13 04:30:04 UTC 2023 Stack trace:
Mon Mar 13 04:30:04 UTC 2023 #0 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(302): mysqli_query()
Mon Mar 13 04:30:04 UTC 2023 #1 /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php(339): db->_query()
Mon Mar 13 04:30:04 UTC 2023 #2 /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php(158): db->query()
Mon Mar 13 04:30:04 UTC 2023 #3 /usr/local/ispconfig/server/lib/classes/plugins.inc.php(120): bind_dlz_plugin->soa_update()
Mon Mar 13 04:30:04 UTC 2023 #4 /usr/local/ispconfig/server/mods-available/dns_module.inc.php(104): plugins->raiseEvent()
Mon Mar 13 04:30:04 UTC 2023 #5 /usr/local/ispconfig/server/lib/classes/modules.inc.php(302): dns_module->process()
Mon Mar 13 04:30:04 UTC 2023 #6 /usr/local/ispconfig/server/lib/classes/modules.inc.php(235): modules->raiseTableHook()
Mon Mar 13 04:30:04 UTC 2023 #7 /usr/local/ispconfig/server/server.php(180): modules->processDatalog()
Mon Mar 13 04:30:04 UTC 2023 #8 {main}
Mon Mar 13 04:30:04 UTC 2023 thrown in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 302

 

Start with this: https://forum.howtoforge.com/threads/please-read-before-posting.58408/
Did the upgrade version 3.2.9p1 show any errors? It is strange database is missing a table.
Changing rights of database user is most likely wrong way to solve and may make situation worse. If system worked 6 months with the set of permission the were most likely correct.

 

There was no error during the upgrade process, I don't know how to recreate the missing tables

 

Below is the output of the above command

Code:

total 116
drwxr-x---  2 root root 4096 Jul 24  2022 .
drwxr-x--- 13 root root 4096 Mar 13 03:07 ..
lrwxrwxrwx  1 root root   68 Jul 24  2022 apache2_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apache2_plugin.inc.php
lrwxrwxrwx  1 root root   71 Jul 24  2022 apps_vhost_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/apps_vhost_plugin.inc.php
lrwxrwxrwx  1 root root   64 Jul 24  2022 aps_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/aps_plugin.inc.php
lrwxrwxrwx  1 root root   67 Jul 24  2022 backup_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/backup_plugin.inc.php
lrwxrwxrwx  1 root root   69 Jul 24  2022 bind_dlz_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_dlz_plugin.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 bind_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/bind_plugin.inc.php
lrwxrwxrwx  1 root root   73 Jul 24  2022 cron_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_jailkit_plugin.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 cron_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/cron_plugin.inc.php
-rwxr-x---  1 root root   45 Mar  8 02:41 empty.dir
lrwxrwxrwx  1 root root   69 Jul 24  2022 firewall_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/firewall_plugin.inc.php
lrwxrwxrwx  1 root root   73 Jul 24  2022 ftpuser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/ftpuser_base_plugin.inc.php
lrwxrwxrwx  1 root root   68 Jul 24  2022 getmail_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/getmail_plugin.inc.php
lrwxrwxrwx  1 root root   72 Jul 24  2022 maildeliver_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/maildeliver_plugin.inc.php
lrwxrwxrwx  1 root root   68 Jul 24  2022 mailman_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mailman_plugin.inc.php
lrwxrwxrwx  1 root root   70 Jul 24  2022 mail_plugin_dkim.inc.php -> /usr/local/ispconfig/server/plugins-available/mail_plugin_dkim.inc.php
lrwxrwxrwx  1 root root   65 Jul 24  2022 mail_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mail_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 mysql_clientdb_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/mysql_clientdb_plugin.inc.php
lrwxrwxrwx  1 root root   77 Jul 24  2022 network_settings_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/network_settings_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 postfix_filter_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/postfix_filter_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 postfix_server_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/postfix_server_plugin.inc.php
lrwxrwxrwx  1 root root   67 Jul 24  2022 rspamd_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/rspamd_plugin.inc.php
lrwxrwxrwx  1 root root   76 Jul 24  2022 server_services_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/server_services_plugin.inc.php
lrwxrwxrwx  1 root root   75 Jul 24  2022 shelluser_base_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_base_plugin.inc.php
lrwxrwxrwx  1 root root   78 Jul 24  2022 shelluser_jailkit_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/shelluser_jailkit_plugin.inc.php
lrwxrwxrwx  1 root root   76 Jul 24  2022 software_update_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/software_update_plugin.inc.php
lrwxrwxrwx  1 root root   70 Jul 24  2022 webserver_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/webserver_plugin.inc.php
lrwxrwxrwx  1 root root   84 Jul 24  2022 z_php_fpm_incron_reload_plugin.inc.php -> /usr/local/ispconfig/server/plugins-available/z_php_fpm_incron_reload_plugin.inc.php

 

Thanks that really solve my problem.