Elxis CMS Forum

Support => Administration => Topic started by: xmanhattan on February 05, 2024, 11:38:36

Title: settings backup db
Post by: xmanhattan on February 05, 2024, 11:38:36

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?

Title: Re: settings backup db
Post by: xmanhattan on March 06, 2024, 11:58:14

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

Quote

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

Title: Re: settings backup db
Post by: datahell on March 06, 2024, 19:34:12

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

Title: Re: settings backup db
Post by: xmanhattan on March 07, 2024, 09:13:26

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.

Title: Re: settings backup db
Post by: datahell on March 07, 2024, 19:40:36

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.

Title: Re: settings backup db
Post by: xmanhattan on March 08, 2024, 15:25:06

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

Title: Re: settings backup db
Post by: datahell on March 10, 2024, 21:05:41

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.

Title: Re: settings backup db
Post by: xmanhattan on March 12, 2024, 11:57:23

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