PHP : Alexandria Library

[federica]

Hi Simon,
open the file your_site/components/com_abook/models/author.php line 69
change the code from:

Code Select Expand

. ' 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 '

to:

Code Select Expand

. ' FROM #__abbookauth AS authbook '
. ' JOIN #__abbook AS book ON authbook.idbook=book.id '
. ' JOIN #__abcategories AS cat ON cat.id=book.catid '
. ' JOIN #__abauthor AS author ON author.id=authbook.idauth '

Tell me if this changes have fix the error.

I have a library book on google.
Is it possible to export the library to csv and then import it on alexandria book?

The CSV files to import must have this fields sequence:
title, subtitle, alias, ideditor, price, pag, user_id, created_by_alias, html, image, file, year, idlocation, idlibrary, vote, numvote, hits, published, qty, isbn, approved, userid, url, url_label, dateinsert, catalogo, checked_out, checked_out_time, access, metakey, metadesc, authors
The field "authors" is a list of comma separated id_author (eg: 1,3,5)

[simon79]

I solved the problem with the joomla forum. I hid the error messages from my system

Problem solved