Page 1 of 1

PHP Fatal error 500 mysqli_sql_exception

Posted: Wed Jan 18, 2023 8:51 am
by carlomarchioro
Hello everyone, I'm new on the forum, I'm trying VestaCP.
I installed VestaCP on a VPS with CentOS7, nginx + apache and MySQL db, the installation was successful, then I generate a new web host, then a database.

For example, I try to install Wordpress (or other CMS) and I get a HTTP ERROR 500 error during configuration.
In the log I find:

2023/01/17 11:07:56 [error] 6656#6656: *800 FastCGI sent in stderr: "PHP message: PHP Fatal error: Uncaught mysqli_sql_exception: Unknown column 'wp_' in 'field list' in /home/admin/web/***domain***/public_html/wp-includes/wp-db.php:2024
Stack trace:
#0 /home/admin/web/***domain***/public_html/wp-includes/wp-db.php(2024): mysqli_query()
#1 /home/admin/web/***domain***/public_html/wp-includes/wp-db.php(1912): wpdb->_do_query()
#2 /home/admin/web/***domain***/public_html/wp-admin/setup-config.php(315): wpdb->query()
#3 {main}
thrown in /home/admin/web/***domain***/public_html/wp-includes/wp-db.php on line 2024" while reading response header from upstream, client: 2.193.42.252, server: ***domain***, request: "POST /wp-admin/setup-config.php?step=2 HTTP/1.1", upstream: "fastcgi://127.0.0.1:9002", host: "***domain***", referrer: "http://***domain***/wp-admin/setup-config.php?step=1&language=it_IT"

I also tried with other CMS or other software, all those that have to work with the DB generate a similar error with HTTP ERROR 500 on the browser side.
I've tried reinstalling VestaCP multiple times, switching from MySQL to PostgreSQL, then Apache to php-fpm, but could never get it to work.