archive search error: Column 'description' ambiguous

[hymeno]

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)

[federica]

Many thanks for your notice!

To fix this bug you have to modify plugins/search/book/book.php line 198
from

Code Select Expand

.'description AS text,'
to

Code Select Expand

.'a.description AS text,'

I will fix the bug in the next release.

[hymeno]

thx for the quick reply
mmh ...
this changes the error messages
Unknown column 'a.publish_up' in 'where clause'

[hymeno]

I quote out that

Code Select Expand


// .'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
... 

[federica]

Modify also line 206 and 207
from:

Code Select Expand

.'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

Code Select Expand

);

Now it is ok?

[hymeno]

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