New EE7 install File Manager produces 'caught exception'
Development and Programming
Just loaded a blank EE 7.4 install on a server with other EE 7 installs, that is running PHP 8.2.17 and MySQL 8 IONOS server. On clicking onto File Manager Tab…
Exception Caught
SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘directory’ in ‘where clause’:
SELECT DISTINCT file_type FROM (exp_files) WHERE file_type IS NOT NULL AND file_type != “directory”
ee/legacy/database/drivers/mysqli/mysqli_connection.php:146
Meaning that File Manager will not load.
Any ideas?
Hi Torchlight,
Thanks for posting this. Is there a larger stack trace you can pass along? The error doesn’t really line up with the query… the query is looking for “directory” as a value in the “field_type” column but the error is for directory as a column (which it is not).
Thanks,
-Tom Jaeger