Error while exporting to CVS file

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

Code Select Expand

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

[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

Code Select Expand

. " GROUP_CONCAT(jos_abbookauth.idauth SEPARATOR ',') as autori "
to

Code Select Expand

. " GROUP_CONCAT(#__abbookauth.idauth SEPARATOR ',') as autori "

3) change row 96
from

Code Select Expand

. ' GROUP BY jos_abbook.id';
to

Code Select Expand

. ' GROUP BY #__abbook.id';
4) save a file and try to export

[Freya]

That did the trick. Thank you so much!

[federica]

Right! I fix this bug in the next version.