[OPEN-ILS-DEV] OPAC searching

[Bill Ott]

I've discovered that my metabib tables are empty! 

While the following from the osrfsys.log seems to indicate that INSERTs 
are successful (just one of many entries), that doesn't appear to be the 
case.  At the same time, the biblio tables are being populated 
normally.  Any suggestions?


open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:oils_cstore.c:838:1175096773136430] open-ils.cstore: Insert 
SQL [INSERT INTO metabib.full_rec 
(ind1,subfield,ind2,id,record,value,tag) VALUES 
('','a','',DEFAULT,4,'','650');]
open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:oils_cstore.c:2287:1175096773136430] open-ils.cstore SQL =  
SELECT  "mfr".ind1, "mfr".subfield, "mfr".ind2, "mfr".id, "mfr".record, 
"mfr".value, "mfr".tag FROM metabib.full_rec AS "mfr" WHERE "mfr".id = 401;
open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:oils_cstore.c:2293:1175096773136430] Query returned with no 
errors
open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:oils_cstore.c:2297:117open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:osrf_app_session.c:547:1175096773136430] AppSession in 
queue_wait with timeout 0
open-ils.cstore 2007-03-28 11:50:35 
[INFO:13615:osrf_app_session.c:515:1175096773136430] [open-ils.cstore] 
sent 435 bytes of data to 
jabber at openils.grpl.org/open-ils.ingest_drone_at_openils.grpl.org_13587
open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:osrf_app_session.c:518:1175096773136430] Sent: [/*--S 
osrfMessage--*/{"threadTrace":"24","type":"RESULT","payload":/*--S 
osrfResult--*/{"status":"OK","statusCode":"200","content":/*--S 
mfr--*/[null,null,null,401,"","",4,"a","650",""]/*--E mfr--*/}/*--E 
osrfResult--*/}/*--E osrfMessage--*/,/*--S 
osrfMessage--*/{"threadTrace":"24","type":"STATUS","payload":/*--S 
osrfConnectStatus--*/{"status":"Request 
Complete","statusCode":"205"}/*--E osrfConnectStatus--*/}/*--E 
osrfMessage--*/]
open-ils.cstore 2007-03-28 11:50:35 
[DEBG:13615:osrf_application.c:335:1175096773136430] Postprocessing 
method open-ils.cstore.direct.metabib.full_rec.create with retcode 0
open-ils.cstore 2007-03-28 11:50:35 
[INFO:13615:osrf_stack.c:103:1175096773136430] Message processing 
duration 0.005457
5096773136430] Query returned at least one row



Bill Ott said the following on 03/26/2007 04:18 PM:
> I fear I have a really silly problem somewhere...
>
> I've entered a couple item records and tied some volumes to them, but 
> I can't seem to locate them in the OPAC.  From the record, if I choose 
> "OPAC View", it looks normal, but I can't locate it by searching, no 
> keyword, author, title, etc...
>
> Stranger yet, if I'm logged in through "My Account", I can do an 
> advanced search by Call No. and pull up the items, but if I'm not 
> logged in, I can never locate the items.
>
> I've verified that the holdings are all "OPAC Visible", changed item 
> statuses, moved them to different locations.  Nothing seems to help.
>
> Thoughts?