Thanks for figuring that out!  I’ll take a look in a little while and see if/how it affects 2.0.

 

From: Stephen Hovey [mailto:hoveys@buffalolib.org]
Sent: Tuesday, April 30, 2013 12:52 PM
To: Demian Katz; Nathan Tallman
Cc: vufind-general@lists.sourceforge.net
Subject: RE: [VuFind-General] Duplicate tags

 

One of the librarians here figure out what causes it.  If they go in and enter a tag over the 25 character width of the mysql field, it looks to accept it, but truncated.. and apparently the internal search to see if the tag exists fails, so it does that new tag insert, instead of just attaching a new resource to the existing tag.

 

So my quick answer is to change the popup to not allow more than 25 chars in the input field.

 

From: Demian Katz [mailto:demian.katz@villanova.edu]
Sent: Tuesday, April 30, 2013 12:39 PM
To: Stephen Hovey; Nathan Tallman
Cc: vufind-general@lists.sourceforge.net
Subject: RE: [VuFind-General] Duplicate tags

 

That is very odd behavior, and I’ve never heard of such a thing before.  Can you reproduce the problem consistently by creating more duplicate tags, or was it a weird thing that happened once and now fails to recur?

 

In VuFind 1.3, the database abstraction is handled by the PEAR DB_DataObject library.  The actual tag search happens in the _processTagSearch() method of web/sys/SearchObject/Solr.php, but the real heavy lifting is done by the library.  It might be possible to address the duplicate tag issue by changing the if() statement to some kind of while() loop (can’t remember the exact DB_DataObject syntax offhand); of course it would be better to prevent the bad data from being created in the first place.

 

I suspect that this problem is not present in 2.0 even if there is a bug in 1.3 – all the database logic has been completely rewritten, so if there are bugs, chances are they’re at least different bugs.  But in any case, I’d be interested to hear if you find out more, and please let me know if I can be of further assistance.

 

- Demian

 

From: Stephen Hovey [mailto:hoveys@buffalolib.org]
Sent: Monday, April 29, 2013 12:50 PM
To: Nathan Tallman
Cc: vufind-general@lists.sourceforge.net
Subject: Re: [VuFind-General] Duplicate tags

 

Thanx – I installed that this morning and it does offer a nice way to find and fix things. 

 

I do want to ferret the code out in vufind though.. Sometimes I find the levels of abstraction a little daunting..

 

From: Nathan Tallman [mailto:ntallman@gmail.com]
Sent: Monday, April 29, 2013 12:48 PM
To: Stephen Hovey
Cc: vufind-general@lists.sourceforge.net
Subject: Re: [VuFind-General] Duplicate tags

 

Stephen,

 

Not sure what's going in your case, but you may want to have a look at Vufind Manager <http://www.evolveplus.com.au/download-vufind-manager>. It's a third-party developed add-on that provides a GUI for managing the social aspects, such as user accounts, tags, comments, etc. All that info lives in a MySQL database anyway, but this is a nice interface your librarians can use.

 

It might help with troubleshooting this issue too.

 

Best,

Nathan

 

On Mon, Apr 29, 2013 at 12:15 PM, Stephen Hovey <hoveys@buffalolib.org> wrote:

Vufind 1.3

 

Is there a known bug related to this?

 

A librarian mentioned they placed the same tag on 5 items, but a search produces just 1 result.

 

I looked in the database and I see, instead of 1 tag record, with 5 resource records, 5 tag records with 1 resource record each.  My single result is the first tag/resource pair.

 

The tag text is identical – case, no spaces etc.. – browse tag confirms this, as well as a handcrafted sql query.

 

I tried to find the search code, to remove what appears to be the assumption of unique tag text so that it would cope with the multiples but am not making good headway.

 


The Buffalo & Erie County Public Library System has more than 2.6 million materials available for borrowing including books, eBooks, DVDs, music and more. Free library card applications can be downloaded and taken to any of the 37- local public libraries for processing. A valid form of identification and proof of address is necessary. For more information call 716-858-8900 or visit www.BuffaloLib.org .


------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
VuFind-General mailing list
VuFind-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/vufind-general

 

 


The Buffalo & Erie County Public Library System has more than 2.6 million materials available for borrowing including books, eBooks, DVDs, music and more. Free library card applications can be downloaded and taken to any of the 37- local public libraries for processing. A valid form of identification and proof of address is necessary. For more information call 716-858-8900 or visit www.BuffaloLib.org .

 


The Buffalo & Erie County Public Library System has more than 2.6 million materials available for borrowing including books, eBooks, DVDs, music and more. Free library card applications can be downloaded and taken to any of the 37- local public libraries for processing. A valid form of identification and proof of address is necessary. For more information call 716-858-8900 or visit www.BuffaloLib.org .