I upgraded everything from nginx to php to mysql and everything is configured correctly seeing as i can install a fresh version of joomla, but my previous project is now showing a blank page, no errors on nginx logs, php logs or joomla logs. The only thing i can see is that the new joomla installation is using innodb engine on the database and utf8mb4 coallation while my previous project is using mylsam and utf8 general. I have tried to run this query to convert all the tables to innodb but it doesnt even convert them after success. So my question is split into two, am i missing something thats giving me a blank joomla, and is this query if successful going to resolve the issue im facing. Thank you in advance.
SELECT CONCAT('ALTER TABLE joomlaDB.', TABLE_NAME,' ENGINE=InnoDB;') FROM Information_schema.TABLES WHERE TABLE_SCHEMA = 'joomlaDB' AND ENGINE = 'MyISAM' AND TABLE_TYPE = 'BASE TABLE'