Hi, I cannot find a way to get a list of all websites running a specific PHP version, not in GUI or accessing the DB (I'm sure that it will exist some field but I cannot find it). How can I perform this? thanks
There is no simple way through the GUI, but you can check in the database which PHP versions have which ID and then check the list of websites with their php version ID's.
I was looking for something similar, but I cannot find the field. In websites table I can find a string field with only "php-fpm" value and I cannot find the other field that has the ID of the PHP version...
server_php_id which you'll need to cross reference with the 'server_php_id' and 'name' fields in the server_php table.
got it, thank you! full query for who need it: Code: SELECT domain, web_domain.server_php_id, server_php.name FROM web_domain INNER JOIN server_php ON server_php.server_php_id = web_domain.server_php_id ORDER BY NAME
