BookLibary Component Support

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:

ordasoft.com/News/Book-Library/upgrade-b...n-to-20-version.html

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?

Hello, If you have upgraded component, you should upgrade all modules. Try updating modules.

Thanks,
OrdaSoft team.

Thank you for the quick response!

The only module that I am using, BookLibrary or otherwise, is the search module. I am using version 3.0. I downloaded the module a few days ago. Is there a new version that I need to use?

Had the same problem. My solution was:
1.In Booklibrary 2.2 export all data records, xml full export.
2. Delete Booklibrary Component 2.2 AND manually all Booklibrary tables with Phpmyadmin
3. Install Booklibrary Component 3
4. Import data records from v.2.2
5. Upgrade finished, everything works well

I'm just now getting back around to this. Pix, thank you for the response.

We use BookLibrary as an internal tool to track our founder and president's library. We use the front-end infrequently. After I performed the upgrade to 3.0, when the back-end appeared to be in proper working order, I removed my 2.2 installation. So, I do not have a 2.2 backup anymore that would allow me to try your suggestion. Thank you again.

I'm sorry for the slow response.

Hello,

Can we help anything else?

Thanks,
Taras
OrdaSoft team.