OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
BookLibrary 3.0 - database error on view details (0 viewing) 
BookLibary Component Support
Go to bottom Favoured: 0
TOPIC: BookLibrary 3.0 - database error on view details
#12966
srosa (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
BookLibrary 3.0 - database error on view details 2 Years, 4 Months ago Karma: 0  
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?
 
Logged Logged  
 
Last Edit: 2014/07/16 20:37 By srosa.
  The administrator has disabled public write access.
#12979
Taras (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:BookLibrary 3.0 - database error on view details 2 Years, 4 Months ago Karma: 55  
Hello, If you have upgraded component, you should upgrade all modules. Try updating modules.

Thanks,
OrdaSoft team.
 
Logged Logged  
  The administrator has disabled public write access.
#12981
srosa (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:BookLibrary 3.0 - database error on view details 2 Years, 4 Months ago Karma: 0  
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?
 
Logged Logged  
  The administrator has disabled public write access.
#13215
Pix (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:BookLibrary 3.0 - database error on view details 2 Years, 4 Months ago Karma: 0  
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
 
Logged Logged  
  The administrator has disabled public write access.
#14025
srosa (User)
Fresh Boarder
Posts: 3
graphgraph
User Offline Click here to see the profile of this user
Re:BookLibrary 3.0 - database error on view details 2 Years, 1 Month ago Karma: 0  
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.
 
Logged Logged  
  The administrator has disabled public write access.
#14032
Taras (Admin)
Admin
Posts: 2858
graphgraph
User Offline Click here to see the profile of this user
Re:BookLibrary 3.0 - database error on view details 2 Years, 1 Month ago Karma: 55  
Hello,

Can we help anything else?

Thanks,
Taras
OrdaSoft team.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?