Cannot access File manger
Permalink
I'm having a problem on a 8.5.0 site that is in development. The search in the File manager has seemed to be very buggy/unreliable since the start of the content population. As things stand I cannot access the file manager at all now due to an Exception. It happened after running a search for a specific word.
This is the error I am getting - I was searching for the term 'Donovan':
=========
Doctrine \ DBAL \ Exception \ InvalidFieldNameException
An exception occurred while executing 'SELECT f.fID, fv.fvDateAdded 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 WHERE (fv.fvFilename LIKE ?) OR (fv.fvDescription LIKE ?) OR (fv.fvTitle LIKE ?) OR (fv.fvTags LIKE ?) OR (uName = ?) OR (ak_image_tag LIKE ?) OR (ak_gallery_columns LIKE ?) OR (ak_internal_link_cid LIKE ?) OR (ak_external_link_url LIKE ?) OR (ak_link_type LIKE ?) ORDER BY fv.fvDateAdded desc, f.fID desc LIMIT 10' with params ["%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_internal_link_cid' in 'where clause'
=========
I have tried rebooting the server, and Refreshing Database Entities (ie here: mysite.com/index.php/dashboard/system/environment/entities/view) but that hasn't helped.
Has anyone experienced this or have any suggestions?
Thanks.
This is the error I am getting - I was searching for the term 'Donovan':
=========
Doctrine \ DBAL \ Exception \ InvalidFieldNameException
An exception occurred while executing 'SELECT f.fID, fv.fvDateAdded 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 WHERE (fv.fvFilename LIKE ?) OR (fv.fvDescription LIKE ?) OR (fv.fvTitle LIKE ?) OR (fv.fvTags LIKE ?) OR (uName = ?) OR (ak_image_tag LIKE ?) OR (ak_gallery_columns LIKE ?) OR (ak_internal_link_cid LIKE ?) OR (ak_external_link_url LIKE ?) OR (ak_link_type LIKE ?) ORDER BY fv.fvDateAdded desc, f.fID desc LIMIT 10' with params ["%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%", "%Donovan%"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_internal_link_cid' in 'where clause'
=========
I have tried rebooting the server, and Refreshing Database Entities (ie here: mysite.com/index.php/dashboard/system/environment/entities/view) but that hasn't helped.
Has anyone experienced this or have any suggestions?
Thanks.
Found a solution for this:
https://www.concrete5.org/community/forums/customizing_c5/error-mess...