We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
PHP Fatal error 500 mysqli_sql_exception
-
- 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.