Vox Populi(x) forum

Alexandria Book Library => Errori (Bugs) => Topic started by: hymeno on 29 April 2019, 13:02:18

Title: archive search error: Column 'description' ambiguous
Post by: hymeno on 29 April 2019, 13:02:18
hi,

there could be a little archive search error:

Search - Alexandria Book Library
Search in booklists
Archived Books: "On"

that creates with the J!-search a:
Column 'description' in field list is ambiguous

regards,
hym

(latest J! & abbook)
Title: Re: archive search error: Column 'description' ambiguous
Post by: federica on 29 April 2019, 14:57:54
Many thanks for your notice!

To fix this bug you have to modify plugins/search/book/book.php line 198
from
.'description AS text,'
to
.'a.description AS text,'

I will fix the bug in the next release.
Title: Re: archive search error: Unknown column 'a.publish_up'
Post by: hymeno on 29 April 2019, 15:23:42
thx for the quick reply
mmh ...
this changes the error messages
Unknown column 'a.publish_up' in 'where clause'
???
Title: Re: archive search error: Column 'description' ambiguous
Post by: hymeno on 29 April 2019, 15:50:13
I quote out that
// .'AND (a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up <= '.$db->Quote($now).') '
// .'AND (a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).')'
then the search works, but for a click on an archived entry, then unfortunately I get a
View not found [name, type, prefix]: archive, html, abookView
...  :-\


Title: Re: archive search error: Column 'description' ambiguous
Post by: federica on 29 April 2019, 16:26:22
Modify also line 206 and 207
from:
.'AND (a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up <= '.$db->Quote($now).') '
.'AND (a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).')' );

to
);

Now it is ok?
Title: Re: archive search error: Column 'description' ambiguous
Post by: hymeno on 03 May 2019, 00:28:21
Yes. Thank you!

(the a.publish_up- and the view-error did not occur after a while ?? ... so i don't comment it out)

regards