1 - I created a link to the present authors. In presenting the authors there yard line "Publications
author, "however, nothing is displayed below. how to see the books published by that author?
(Example on my page: here)
2 - What is the file to edit to change the word "COMMENT" (on this page for example : here) with "SUMMARY" please?
After several searches, I can not find the file
Thank you for your prompt response
Hi simon 79,
1)
* open this file: your_site/components/com_abook/models/author.php
* add this code after row 76
$this->_db->setQuery($query);
print_r( $this->_db->getErrorMsg());
* refresh the front-end author page on you browser
* post the error you see
2) the translations are on your_site/language/it-IT/it-IT.com_abook.ini
Bye bye
1- After adding the code at line 77, this code is visible in my autor page :
Table 'db362457357.jos_abbookauth' doesn't exist SQL=SELECT book.*, CASE WHEN CHAR_LENGTH(book.alias) THEN CONCAT_WS(':', book.id, book.alias) ELSE book.id END as slug, CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END as catslug, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count FROM jos_abbookauth AS authbook JOIN jos_abbook AS book ON authbook.idbook=book.id JOIN jos_abcategories AS cat ON cat.id=book.catid JOIN jos_abauthor AS author ON author.id=authbook.idauth LEFT JOIN rfg_abrating AS v ON book.id = v.book_id WHERE author.id=7 AND book.published = 1 AND cat.published = 1 ORDER BY title LIMIT 0, 10
2- Thank's
4- Can you explain what is the module : abook related ?
Thank's you
5- for the search function, how to put each criterion at the start line?
Example:
- Keyword
- Category
- City
- ...
What is the file to edit?
I think we should return to the line after each function
Html is </ br> for a return at the line... but I do not know if it's an html file or other
Because my page (http://www.livreoccaz.fr/index.php/rechercher-un-livre) is poorly presented I find
Thank you for your help with this last request
it's ok for the question 3-.
A question at a time. This is a forum managed by volunteers people. If you hurry, this is not the place for you.
1) the table jos_abbookauth does not exist or you have renamed it. Check your database.
Quote from: federica on 07 April 2011, 12:28:14
A question at a time. This is a forum managed by volunteers people. If you hurry, this is not the place for you.
1) the table jos_abbookauth does not exist or you have renamed it. Check your database.
my table is : rfg_abbookauth
how to rename it?
If the other tables start with "jos_" prefix then rename rfg_abbookauth table to jos_abbookauth.
To rename the table you can use the manager tool of your database application. This forum does't provide support for other applications.
Hello,
All my tables start with rfg_
Table begins with a single table is jos_ownbiblio
Is it possible to edit a file, so to solve this problem?
you do not know?
Should I go through another forum ?
I have already answered.
QuoteTo rename the table you can use the manager tool of your database application.
if I rename jos_ownbiblio to rfg_ownbiblio it's not problem to pose concerns for the component ?
I renamed rfg_abbookauth table to jos_abbookauth but no change in publication of the author
What I do not understand is that in all my tables, only 1 to prefixed jos_: josownbiblio
All other starting rfg_...
I no longer had access to my book list in the administrator, so I put as before.
An error message appeared. I saw no longer the element author on my site in the description of a book.
This problem is strange ...
How to solve it?
I tried renaming the table jos_ownbiblio to rfg_ownbiblio
(Now, all my table starting with rfg_ prefix)
No changes on the site, no bugs...
So I do not know what to do :s
Problem solved
"components/com_abook/models/author.php, line 60 replace all the "jos_" to "#__" :
function _buildQuery()
{
$where = $this->_buildContentWhere();
$orderby = $this->_buildContentOrderBy();
$query = "SELECT book.*, "
. ' CASE WHEN CHAR_LENGTH(book.alias) THEN CONCAT_WS(\':\', book.id, book.alias) ELSE book.id END as slug, '
. ' CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(\':\', cat.id, cat.alias) ELSE cat.id END as catslug, '
. ' ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count '
. ' FROM jos_abbookauth AS authbook '
. ' JOIN jos_abbook AS book ON authbook.idbook=book.id '
. ' JOIN jos_abcategories AS cat ON cat.id=book.catid '
. ' JOIN jos_abauthor AS author ON author.id=authbook.idauth '
. ' LEFT JOIN #__abrating AS v ON book.id = v.book_id '
. $where
. $orderby
;
return $query;
}
I see the publications of each author here (http://www.livreoccaz.fr/index.php?option=com_abook&view=author&id=3&Itemid=111)
However only the last books we see the various descriptions ...
Have you any idea?
Thank's
Is it possible to put books in a row in horizontal?
Thank you
Quote from: simon79 on 14 April 2011, 22:37:24
Is it possible to put books in a row in horizontal?
Thank you
Same problem...
Thank you for the extension
Hi MKemal and simon79,
To fix this bug you can install the new module Abook all-in-one (http://www.alexandriabooklibrary.org/en/downloads/viewcategory/20-modules.html)