CP error when entering "Files" pages #4800
Description
Description of the problem
I deleted about 1600 PDF purchase orders from their upload directory manually and when I went back into the CP and navigated to the "Files" tab I got the error below. I have done this before with no issues but this time ... the error.
I had someone else take a look at it & they seem to think it's an EE issue.
How To Reproduce
Steps to reproduce the behavior:
Delete images mapped to an upload directory manually from the server.
Navigate to the CP -> Files tab
Error Messages
Exception Caught
SQLSTATE [42522]: 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
Stack Trace: Please include when reporting this error
#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php (112): CI
_D _mysqli_connection->query()
#1 ee/legacy/database/DB_driver-php(262): CI DB_mysqli_driver-›>_execute()
#2 ee/legacy/database/DB_driver.php (177): CI DB_driver->simple_query ()
#3 ee/legacy/database/DB_active_rec.php (1084) : CI_DB_
_driver->query ()
#4 ee/ExpressionEngine/Library/CP/FileManager/Traits/FileManagerTrait.php(484): CI DB_active_record->get ()
#5 ee/ExpressionEngine/Library/CP/FileManager/Traits/FileManagerTrait.php(97): ExpressionEngine\Controller\Files\AbstractFiles->crea
teTypeFilter ()
#6 ee/ExpressionEngine/Controller/Files/Files.php(33): ExpressionEngine\Controller\Files \AbstractFiles->listingsPage ()
#7 [internal function]: ExpressionEngine\Controller\Files\Files->index ()
#8 ee/ExpressionEngine/Core/Core.php(269): call_user_func_array ()
#9 ee/ExpressionEngine/Core/Core.php (125): ExpressionEngine\Core\Core->runController()
#10 ee/ExpressionEngine/Boot/boot.php(184): ExpressionEngine\Core|Core->run ()
#11 admin-php (139): require_once(' ...')
#11 admin-php (139): require_once('...')
Screenshots / Videos / Template Code
Environment Details:
- Version: EE 7.5.7
- PHP Version 8.1
- MySQL Version 8
- OS: Laravel DO Droplet
- Web Server: nginx
Possible Solution
Additional context
I am not 100% certain that deleting the files caused this issue, but as I said, I had someone else take a look & the ysuggested it might be an EE issue.