Forums

Picture Search SQL Error

Permalink
Hello

I just tried to add a few pics to the Slideshow and got this strange sql error while searching for picture name in uploaded picture list:

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 ["%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%", "%spiel%"]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ak_internal_link_cid' in 'where clause'


This is a new installation without many changes, just an additional theme Neat v.0.9.2
+ Cookies Notice v.1.3.2 + Easy Image Gallery v.1.4.2

Additional Error Infos:
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php(71): Doctrine\DBAL\Exception\InvalidFieldNameException->null   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException->driverExceptionDuringQuery   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(107): Doctrine\DBAL\Driver\PDOException->null   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOException->null   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php(105): PDOStatement->execute   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(847): Doctrine\DBAL\Driver\PDOStatement->execute   
concrete5/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery   
concrete5/concrete/src/Search/ItemList/Database/ItemList.php(63): Doctrine\DBAL\Query\QueryBuilder->execute   
concrete5/concrete/src/Search/ItemList/ItemList.php(84): Concrete\Core\Search\ItemList\Database\ItemList->executeGetResults   
concrete5/concrete/src/Search/Pagination/Adapter/PagerAdapter.php(50): Concrete\Core\Search\ItemList\ItemList->getResults   
concrete5/concrete/src/Search/Pagination/PagerPagination.php(152): Concrete\Core\Search\Pagination\Adapter\PagerAdapter->getSlice   
concrete5/concrete/src/Search/Result/Result.php(117): Concrete\Core\Search\Pagination\PagerPagination->getCurrentPageResults   
concrete5/concrete/src/Search/Result/Result.php(163): Concrete\Core\Search\Result\Result->getItems   
concrete5/concrete/src/File/Search/Result/Result.php(32): Concrete\Core\Search\Result\Result->getJSONObject
Viewing 15 lines of 39 lines. View entire code block.
 
johannesri replied on at Permalink Reply 
# concrete5 Version
Core Version - 8.5.1
Version Installed - 8.5.1
Database Version - 20190301133300
# concrete5 Packages
Cookies Notice (1.3.2), Easy Image Gallery (1.4.2), Neat (0.9.2)
# concrete5 Overrides
themes/kunsthaus/elements/footer.php, themes/kunsthaus/elements/header.php, themes/kunsthaus/elements, themes/kunsthaus/credits.txt, themes/kunsthaus/thumbnail.png, themes/kunsthaus/description.txt, themes/kunsthaus/font-awesome/fonts/fontawesome-webfont.woff2, themes/kunsthaus/font-awesome/fonts/fontawesome-webfont.ttf, themes/kunsthaus/font-awesome/fonts/FontAwesome.otf, themes/kunsthaus/font-awesome/fonts/fontawesome-webfont.woff, themes/kunsthaus/font-awesome/fonts/fontawesome-webfont.eot, themes/kunsthaus/font-awesome/fonts/fontawesome-webfont.svg, themes/kunsthaus/font-awesome/fonts, themes/kunsthaus/font-awesome/HELP-US-OUT.txt, themes/kunsthaus/font-awesome/css/font-awesome.min.css, themes/kunsthaus/font-awesome/css, themes/kunsthaus/font-awesome, themes/kunsthaus/js/jquery.singlePageNav.min.js, themes/kunsthaus/js/jquery.min.js, themes/kunsthaus/js/bootstrap.min.js, themes/kunsthaus/js/ekko-lightbox.min.js, themes/kunsthaus/js, themes/kunsthaus/css/ekko-lightbox.min.css, themes/kunsthaus/css/bootstrap.min.css, themes/kunsthaus/css/style.css, themes/kunsthaus/css/ekko-lightbox-dark.css, themes/kunsthaus/css, themes/kunsthaus/default.php, themes/kunsthaus
# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).
# Server Software
Apache
Viewing 15 lines of 42 lines. View entire code block.


Same Problem here:
https://www.concrete5.org/community/forums/chat/problem-with-search-...

I found no solution for this bug, but this is a workaround (disable index search):
https://www.concrete5.org/community/forums/customizing_c5/error-mess...