We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it soon. Read more about it: https://vestacp.com/docs/vesta-2-development
PHP Fatal error 500 mysqli_sql_exception
-
carlomarchioro
- Posts: 1
- Joined: Tue Jan 17, 2023 1:52 pm
- Os: CentOS 7x
- Web: nginx + php-fpm
PHP Fatal error 500 mysqli_sql_exception
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.
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.