Error while exporting to CVS file

Started by Freya, 12 March 2011, 14:41:52

Previous topic - Next topic
A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

Freya

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 :
<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!

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9

federica

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
. " GROUP_CONCAT(jos_abbookauth.idauth SEPARATOR ',') as autori "
to
. " GROUP_CONCAT(#__abbookauth.idauth SEPARATOR ',') as autori "

3) change row 96
from
. ' GROUP BY jos_abbook.id';
to
. ' 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.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

Freya

That did the trick. Thank you so much!

federica

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.
Informatizzati [url="https://informatizzati.org"]https://informatizzati.org[/url]
Stacca la spina [url="https://disconnessi.org"]https://disconnessi.org[/url]

A financial contribution is greatly appreciated as a support, to help us to keep live the project.
If you like this project you can donate some piece of BitCoin to this address: bc1qy5tgq6tvrckac2a57unxvqcnxamrvhduve9sj9