Too Many Advanced Search Options in File Manager Results in Error
Permalink
Hello,
I have a user who was working in the File Manager. They added multiple parameters to the search using the Advanced Search, but still didn't find what they wanted so they left the File Manager. When they tried to go to the File Manager again via the Dashboard, they received this error:
I was able to see the error when I logged in as this user and tried to access the File Manager. The File Manager is working fine for everyone else. I cleared the cache but that didn't resolve the error.
It seems like maybe the File Manager is holding on to the user's multiple parameters and getting tripped up. It also looks like it's trying to order results based on Author Name but that's not an option in the File Manager as far as I can tell so I'm not sure how it got the idea to do that.
Is there a way to restore this user's view of the File Manager to the default view? Any other ideas about what this might be? Thank you for any help you can provide!
I have a user who was working in the File Manager. They added multiple parameters to the search using the Advanced Search, but still didn't find what they wanted so they left the File Manager. When they tried to go to the File Manager again via the Dashboard, they received this error:
An exception occurred while executing 'SELECT f.fID FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID and fv.fvIsApproved = 1 LEFT JOIN FileSearchIndexAttributes fsi ON f.fID = fsi.fID LEFT JOIN Users u ON f.uID = u.uID ORDER BY fvAuthorName desc LIMIT 1000': SQLSTATE[42S22]: Column not found: 1054 Unknown column 'fvAuthorName' in 'order clause'
I was able to see the error when I logged in as this user and tried to access the File Manager. The File Manager is working fine for everyone else. I cleared the cache but that didn't resolve the error.
It seems like maybe the File Manager is holding on to the user's multiple parameters and getting tripped up. It also looks like it's trying to order results based on Author Name but that's not an option in the File Manager as far as I can tell so I'm not sure how it got the idea to do that.
Is there a way to restore this user's view of the File Manager to the default view? Any other ideas about what this might be? Thank you for any help you can provide!
/concrete/tokb/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:71
The error I'm receiving (shown in the post above) seems similar to one experienced by another user here:https://www.concrete5.org/developers/bugs/8-3-1/error-with-address-a...
However, we have not upgraded to version 8.0+ and don't plan to do so.
Does anyone know the potential issues that could arise by refreshing the database entities, as the post above suggests to do?