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!
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!