Version: ISPConfig 3.2.5 I'm trying to create a new website on my host, didn't have this issue before the upgrade, but this is the first time I add a website since the website. I did lookup the error, but couldn't find this specific one. If I try to create a website with no PHP selected, I get this message. Any PHP option, and it always comes back with the "fastcgi_php_version" issue. Can someone assist with this issue?
Sounds like your sql schema didn't update correctly, as that column was dropped. What version did you update from? Did you see any errors when you updated? You could try restoring the backup made before updating and run through the update again to try to find where things went wrong, or simply compare your current schema with the incremental sql update files to see what changes need made (see install/sql/incremental/upd_*.sql, and probably only need to look at the last few files, depending on what version you updated from).
I did update from 3.2.2 to 3.2.5 so I did skip a two versions. I'll take some time and compare the update sql files and see what got missed. I did not get any error messages specifically, the update went smoothly.
Just a quick follow-up on the solution. As mentioned by Jesse, It looks like one of the SQL updates failed to apply during the installation, and I must have missed the error. I located the update file by going to the directory incremental folder, and searched for grep -w fastcgi_php_version * I found the offending lines in the upd_0031.sql file. I looked at the file, and compared it to the SQL database, and I noticed the alter command at the end was no applied. I manually ran "ALTER TABLE `web_domain` ADD `fastcgi_php_version` VARCHAR( 255 ) NULL DEFAULT NULL;" in phpmyadmin, and it resolved my issue. Thank you
Thanks for pointing to the solution. I also encountered the same issue. Your post helped me to resolve. But I did in the command line as follows:: Code: # mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 71243 Server version: 10.5.12-MariaDB-0+deb11u1 Debian 11 Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use dbispconfig; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [dbispconfig]> ALTER TABLE `web_domain` ADD `fastcgi_php_version` VARCHAR( 255 ) NULL DEFAULT NULL; Query OK, 84 rows affected (0.018 sec) Records: 84 Duplicates: 0 Warnings: 0 MariaDB [dbispconfig]> flush privileges; Query OK, 0 rows affected (0.002 sec) MariaDB [dbispconfig]> quit Bye Hope this could be helpful to those who encounters the similar issue and would like to resolve in command line. Cheers.
