Author Topic: Error while exporting to CVS file  (Read 7070 times)

Freya

  • Guest
Error while exporting to CVS file
« on: 12 March 2011, 14:41:52 »
Hi,

I've been working with the Library component shortly, but when I am trying to export files to a .cvs file, I recieve the following error :
Code: [Select]
<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/home/nlepubsn/public_html/administrator/components/com_abook/models/importexport.php</b> on line <b>99</b><br />
I am not the only one experiencing this problem, so it looks like a bug. Is there a way to solve this? I like your program very much, but without the .cvs import-option it is gonna take a lot of time to fill the database.

Front-end adding of books hasn't been added yet, is that correct? This would also be a major improvement.

Thanks in advance for the help!

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.048
  • Karma: +1/-0
Re: Error while exporting to CVS file
« Reply #1 on: 12 March 2011, 20:47:17 »
Hello Freya,
I suppose you've changed the database table prefix. I set statically the tables name. This is a bug!
Follow this steps to fix it:
1) open the file administrator/components/com_abook/models/importexport.php
2) change row 92
from
Code: [Select]
. " GROUP_CONCAT(jos_abbookauth.idauth SEPARATOR ',') as autori "to
Code: [Select]
. " GROUP_CONCAT(#__abbookauth.idauth SEPARATOR ',') as autori "
3) change row 96
from
Code: [Select]
. ' GROUP BY jos_abbook.id';to
Code: [Select]
. ' GROUP BY #__abbook.id';4) save a file and try to export
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!

Freya

  • Guest
Re: Error while exporting to CVS file
« Reply #2 on: 12 March 2011, 21:02:49 »
That did the trick. Thank you so much!

Offline federica

  • Amministratore
  • Delfino
  • *****
  • Posts: 1.048
  • Karma: +1/-0
Re: Error while exporting to CVS file
« Reply #3 on: 15 March 2011, 10:42:17 »
Right! I fix this bug in the next version.
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!