Author Topic: PHP : Alexandria Library  (Read 9671 times)

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.063
  • Karma: +1/-0
Re: PHP : Alexandria Library
« Reply #7 on: 24 March 2011, 20:51:10 »
Hi Simon,
open the file your_site/components/com_abook/models/author.php line 69
change the code from:
Code: [Select]
. ' 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]
. ' 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.

Quote
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)
« Last Edit: 28 March 2011, 10:08:33 by federica »
Al mondo ci sono 10 tipi di persone, quelli che hanno capito il codice binario e quelli che non l'hanno capito.
http://www.antivirushelp.it
stacca la spina!

Vox Populi(x) forum

Re: PHP : Alexandria Library
« Reply #7 on: 24 March 2011, 20:51:10 »

simon79

  • Guest
Re: PHP : Alexandria Library
« Reply #8 on: 28 March 2011, 14:16:58 »
I solved the problem with the joomla forum. I hid the error messages from my system

Problem solved

Vox Populi(x) forum

Re: PHP : Alexandria Library
« Reply #8 on: 28 March 2011, 14:16:58 »