Monthly Archives: June 2026

Database error on roundcube on CWP Panel


Notice: WP_Theme_JSON_Resolver::get_user_data(): Error when decoding a theme.json schema for user data. Syntax error in /home/onlinesu/public_html/kb/wp-includes/functions.php on line 6170

While rest of the website were working fine and while accessing my email account via auto-login

it was showing an error Database error connection failed

Please contact server administrator

After checking the logs in /usr/local/cwpsrv/var/services/roundcube/logs/errors.log

found the error due to missing table roundcube.carddav_addressbook

18-Jun-2026 19:39:09 +0000]: <3c79m5k8> DB Error: [1146] Table ’roundcube.carddav_addressbooks’ doesn’t exist (SQL Query: SELECT * FROM carddav_addressbooks WHERE ((user_id = ‘3’))) in /usr/local/cwpsrv/var/services/roundcube/program/lib/Roundcube/rcube_db.php on line 543 (GET /?_task=mail&_token=tee6Pl7prS5tNWlXRyKRmdBY6p2cXU3o)
[18-Jun-2026 19:39:09 +0000]: <3c79m5k8> DB Error: [1146] Table ’roundcube.carddav_addressbooks’ doesn’t exist (GET /?_task=mail&_token=tee6Pl7prS5tNWlXRyKRmdBY6p2cXU3o)

logged into Mysql and went to roundcube database

[root@ok1129 ~]# mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 52184
Server version: 10.4.34-MariaDB MariaDB Server

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]> use roundcube;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Created the 2 missing tables using below commands

Database changed


MariaDB [roundcube]> CREATE TABLE IF NOT EXISTS carddav_addressbooks (
-> id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-> user_id INT(10) UNSIGNED NOT NULL,
-> name VARCHAR(255) NOT NULL,
-> url VARCHAR(255) NOT NULL,
-> username VARCHAR(255) DEFAULT NULL,
-> password VARCHAR(255) DEFAULT NULL,
-> active TINYINT(1) NOT NULL DEFAULT 1,
-> PRIMARY KEY (id),
-> CONSTRAINT fk_carddav_addressbooks_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.016 sec)

MariaDB [roundcube]> CREATE TABLE IF NOT EXISTS carddav_accounts (
-> id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
-> user_id INT(10) UNSIGNED NOT NULL,
-> name VARCHAR(255) NOT NULL,
-> discovery_url VARCHAR(255) NOT NULL,
-> username VARCHAR(255) DEFAULT NULL,
-> password VARCHAR(255) DEFAULT NULL,
-> active TINYINT(1) NOT NULL DEFAULT 1,
-> PRIMARY KEY (id),
-> CONSTRAINT fk_carddav_accounts_user_id FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE ON UPDATE CASCADE
-> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Query OK, 0 rows affected (0.012 sec)

MariaDB [roundcube]> exit
Bye

This fixed the issue and Roundcube was working perfectly fine

Change user in Ubuntu OS

Normally Ubuntu allows you to install OS as non root username

So you need to login to server as non root user and run command mentioned below to login as root user

sudo -i

Once you login as root user change below mentioned parameter in /etc/ssh/sshd_config

and uncomment PermitRootLogin paramter and change to to yes and restart sshd using command

service sshd restart

ERROR “Let’s Encrypt™” DNS DCV error on autoSSL cpanel

ERROR “Let’s Encrypt™” DNS DCV error (*.xtklaos.com): 400 urn:ietf:params:acme:error:dns (There was a problem with a DNS query) (DNS problem: looking up TXT for _acme-challenge.xxxtklaos.com: DNSSEC: DNSKEY Missing: validation failure <_acme-challenge.xxxtklaos.com. TXT IN>: No DNSKEY record [misc failure] from 142.214.184.xxx for key xxxtklaos.com. while building chain of trust)

Was getting an issue where autoSSL was giving the DNS error while domain was pointing to local server with DNS on third party registrar

The issue was due to DNSSEC enabled at domain registrar for the domain name

This was causing failure for auto SSL to install SSL

Disabling DNSSEC fixed the issue and AutoSSL worked fine

/tmp in read only mode cPanel server

/tmp in server was not allowing any write on it causing mysql to fail

below is the solution to fix it

Stop all services using /tmp using below command

systemctl stop httpd
systemctl stop mysql
systemctl stop cpanel

umount -f /var/tmp

rm -fv /usr/tmpDSK

/scripts/securetmp

The /tmp is recreated and all services are working fine