Problem with search in file manager
Permalink
Every time I try to search for a file by name, (i put "marbella" as the search term in this instance, the file manager throws this error...
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 ["%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_internal_link_cid' in 'where clause'
Any ideas what is wrong?
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 ["%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%", "%marbella%"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_internal_link_cid' in 'where clause'
Any ideas what is wrong?
Any ideas guys?
What version of concrete5 are you using?
What is the website address?
What is the website address?
# concrete5 Version
Core Version - 8.4.4
Version Installed - 8.4.4
Database Version - 20180717000000
Its a temporary domain, site updated to latest, but this was happening before. The images upload and show on site just fine. Thumbs show in file manager, but if you try to search for a file by name, it throws the error posted.
Core Version - 8.4.4
Version Installed - 8.4.4
Database Version - 20180717000000
Its a temporary domain, site updated to latest, but this was happening before. The images upload and show on site just fine. Thumbs show in file manager, but if you try to search for a file by name, it throws the error posted.
I just installed 8.4.4 on my test server and am unable to replicate the error?
I run 5 C5 sites and never had this before, so it's not the server, obviously a database error of some kind. Pain in the ass though!
I'm having the same issue. I was running version 8.4.5 and got the same error. I upgraded to 8.5.1 to see if the error went away. No luck.
Just in case anyone else stumbles on this thread - I was having the same problem - there is a solution here:
https://www.concrete5.org/community/forums/customizing_c5/error-mess...
https://www.concrete5.org/community/forums/customizing_c5/error-mess...