settings backup db

[xmanhattan]

Hello,

I am receiving the error, Action failed! Internal Server Error when I try to backup the db.
I am thinking that it might have to do with SSL but on another site with SSL it doesn't do this.
Any thoughts?

[xmanhattan]

Hello,
I am still seeing this error with the following info:

Backup DB
Action failed! Internal Server Error

File name: error.log
[2024-03-06 09:16:59]    ERROR in file public_html/includes/libraries/elxis/database/adapters/mysql.adapter.php line 86

Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 in public_html/includes/libraries/elxis/database/adapters/mysql.adapter.php:86
Stack trace:
#0 public_html/includes/libraries/elxis/database/adapters/mysql.adapter.php(86): PDO->query()
#1 public_html/includes/libraries/elxis/database.class.php(496): elxisMysqlAdapter->backup()
#2 public_html/components/com_cpanel/controllers/utilities.php(845): elxisDatabase->backup()
#3 public_html/components/com_cpanel/controllers/utilities.php(723): utilitiesCPController->dbBackup()
#4 public_html/components/com_cpanel/cpanel.php(53): utilitiesCPController->makebackup()
#5 public_html/includes/libraries/elxis/document.class.php(1221): cpanelRouter->route()
#6 public_html/includes/libraries/elxis/document.class.php(1034): elxisDocument->renderComponent()
#7 public_html/includes/libraries/elxis/document.class.php(948): elxisDocument->makeAdmin()
#8 public_html/includes/loader.php(245): elxisDocument->make()
#9 public_html/xxxxxxxx/inner.php(25): require('...')
#10 {main}
  thrown

[datahell]

Do you just click the green db backup button or you click options and select a specific database table?
Please open file configuration.php located in site's root folder and copy-paste me the values of these 2 parameters:
DB_DSN
DB_NAME

[xmanhattan]

Hello Datahell,
Only the green db backup button.
I looked at the options for db and it is set for all.  Under that are all the tables pertaining to Elxis.

DB_DSN is set to empty.
DB_NAME is correct db.

[datahell]

The process fails in this command: SHOW CREATE TABLE `db name`.db table name;

Make sure the MySQL user has all the required privileges (CREATE, DROP, etc). An other option is the database table to be corrupted... In that case you must execute a REPAIR command on that table (see below). However we don't know which is the faulty table for the log you show me. Do you get any other errors or warning in logs or just this? Maybe it is an other problem we are facing with. Enable full logging and check error.log, warning.log, notice.log

REPAIR TABLE table_name;
CHECK TABLE table_name;

I can't help more without more information.

[xmanhattan]

Hello Datahell,

REPAIR TABLE  - Your SQL query has been executed successfully.
CHECK TABLE  - Your SQL query has been executed successfully.

I also requested that pointer.gr check from their side.  They did not find any problem.

Everything seems to work except for the backup through Elxis.  I have backed up my db through their cpanel so this is not a priority.

Thank you for looking at it.

Here is some info from their cpanel:
Database server
Server: Localhost via UNIX socket
Server type: MariaDB
Server connection: SSL is not being used Documentation
Server version: 10.6.15-MariaDB-cll-lve - MariaDB Server
Protocol version: 10
User: xxxxxxx@localhost
Server charset: UTF-8 Unicode (utf8mb4)

Web server
cpsrvd 11.116.0.14
Database client version: libmysql - mysqlnd 8.1.27
PHP extension: mysqli Documentation curl Documentation mbstring Documentation
PHP version: 8.1.27

phpMyAdmin Version information: 5.2.1

PHP version 8.1.25
General
System    Linux linux44.name-servers.gr 4.18.0-477.27.2.lve.el8.x86_64 #1 SMP Wed Oct 11 12:32:56 UTC 2023 x86_64
Build Date    Oct 26 2023 15:09:29
Host    x86_64-redhat-linux-gnu
SSL Version    OpenSSL/1.1.1w
ZLib Version    1.2.11
libSSH Version    libssh2/1.10.0

[datahell]

I don't know Peter, I have nothing else to propose. If you want send me with a personal message access details to the site to see it.

[xmanhattan]

Datahell, I won't be making many changes and I can backup using phpadmin.
Thanks for looking at it.