Dashboard File Manager Error - Locked out

Permalink
I'm not entirely sure what caused this to happen, but I was setting up some advanced permissions on the file manager and now I can't get back in, and I'm receiving this error when I try to access the "search" portion of the file manager (5.4.0.5):

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1066: Not unique table/alias: 'fsf0'] in EXECUTE("SELECT DISTINCT f.fID, u.uName as fvAuthorName FROM Files f INNER JOIN FileVersions fv ON f.fID = fv.fID LEFT JOIN Users u on u.uID = fv.fvAuthorUID left join FileSetFiles fsf0 on fsf0.fID = f.fID left join FileSetFiles fsf0 on fsf0.fID = f.fID left join FileSearchIndexAttributes on (fv.fID = FileSearchIndexAttributes.fID) where 1=1 and fsf0.fsID = NULL and fsf0.fsID = NULL and fv.fvType = '1' and fvIsApproved = '1' and ((select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) and (f.uID = 2 or (select count(fID) from FileSetFiles where FileSetFiles.fID = f.fID and fsID in (-1)) = 0) order by fDateAdded desc limit 0,10 ") ' in /var/www/vhosts/epicproductionsllc.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/vhosts/epicproductionsllc.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): ad in /var/www/vhosts/epicproductionsllc.com/httpdocs/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78

I switched the version of a particular image to an earlier one right before I started getting the error - I suspect it has something to do with that. Any ideas would be appreciated, I'm locked out in the meantime!

hursey013
 
hursey013 replied on at Permalink Reply
hursey013
Cleared Firefox cache and it worked this morning - too weird.