We use BookLibrary to document, record, manage the books in our founder's library (~6K titles)
I upgraded from BookLibrary 2.2 to BookLibrary 3.0 following these instructions:
All seemed to work well, especially in the administration panels. However, on the front-end, where all we use is the search module, we receive a database error whenever we try to navigate to another page of results or if we try to view a specific book from displayed by the search results.
We receive the following error:
1054 - Unknown column 'c.language' in 'field list' SQL=SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display FROM #__booklibrary_main_categories as c LEFT JOIN #__booklibrary_categories AS bc ON c.id=bc.catid LEFT JOIN #__booklibrary AS b ON b.id=bc.bookid AND b.published=1 AND b.approved=1 WHERE c.section='com_booklibrary' AND c.published = 1 AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' ) AND (c.langshow LIKE'English (United Kingdom)' OR c.language='' OR c.language IS NULL OR c.language='*'
GROUP BY c.id ORDER BY parent_id DESC, c.ordering
It appears that there is a column (language) missing from the #__booklibrary_main_categories and maybe #__booklibrary tables. Perhaps the install script (administrator/components/com_booklibrary/install.booklibrary.php, lines 173 and 180) is missing a column in the ALTER TABLE statement for these tables.
To test this idea, I added the 'language' column to the #__booklibrary_main_categories (varchar (100)) and that eliminated the error, but I did not get the results I expected when I tried to go to the next page or view the details of the book. Instead of taking me to the next page of search results or the details for the book, I received an category list.
Can I get the search results to page properly or the book details to display from the search results? Keep in mind that our front-end has no BookLibrary menu item, only a 'Home' link. The only thing that displays on the front-end home page is the BookLibrary search module. Do we need to something special to get the search results to page properly or the book details to display when we click on a cover?