Re: [Emilda] Searching gives 'A Database error has occurred....'

[Christoffer L. <lan...@re...>]

Jerry Leahy wrote:
> Hi Guys,
> 
> I downloaded the latest nightly build of Emilda and tried to get it 
> going but am having problems. I have something misconfigured but I don't 
> know what it is.
> On the 'Quick Search' page, search by Title, giving a word that I know 
> is in the title of one of the books in the Library, I get:
> 
> 
>        A Database error has occurred, please retry (Code: 207)
> 
> 

Hello,


Code 207 is as You maybe noticed related to the sort statement that 
search.php issues. If You have read http://www.emilda.org/book/view/36 
You will see, that as of 1.2-alpha, Emilda supports sorting (to some 
extent) and thus You need to update Your Zebra configurations 
(usmarc.abs to be more specific)

If You download 
http://prdownloads.sourceforge.net/emilda/emilda-zebra-folder-1.2-alpha.tar.gz?download 
and unpack it You will find a usmarc.abs file there. The char sequence

!:s

that You can find at the end of some directives is the key to 
everything. This tells that this field is sortable. If You, however have 
not upgraded Your zebra folder since Emilda 1.1, I would suggest 
replacing it with the above example Zebra tarball, as it contains all 
new zebra directives. If You nevertheless want to keep Your folder, 
tab/usmarc.abs and zebra.cfg are the important files that You will need 
to crosscheck and see that they are up to date.

Lets hope that this will help You solve the issue, and if not, just ask 
and I'll try to reformulate to less cryptic language ;-)

>        1 book found
> 
> on the more recent version of Emilda
> 
> and
> 
> 
>        A Database error has occurred, please retry (Code: 207 - Cannot
>        sort according to sequence)
> 
> 
>        1 book found
> 
> on the older version I had (1.2-alpha I think).
> 
> Probably related is that when I do Reports/All borrowed Books I get:
> *Fatal error*: Call to a member function on a non-object in 
> */srv/www/htdocs/emilda/lib/MARC.inc* on line *417*
> 
> Any ideas on what I am doing wrong?
> 
> Thanks,
> 
> Jerry.
> 
> PS Any chance there might be a browse all books rather than having to 
> know the book ID/title/author etc? (thought I'd stick that in to make 
> your lives more interesting ;-)

There currently is a "list" under Management->Reports->All books a that 
contains all books in the system. To my shame, I just noticed that it 
does not works ;-) so I will have to attack it asap, and see what is 
wrong. The biggest problem with displaying all books is that if You have 
a database of more than 1000 books, PHP will timeout before it will be 
able to handle and print all books. But lets see what future brings :-)

> 
> _______________________________________________
> Emilda mailing list
> Em...@li...
> http://lists.realnode.com/mailman/listinfo/emilda


-- 
Christoffer Landtman
Oy Realnode Ab
Partner, Sales
+358 (0)41 510 1073
lan...@re...
www.realnode.fi