<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
p
{margin-right:0cm;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif"}
span.EmailStyle18
{font-family:"Calibri","sans-serif";
color:windowtext}
span.BalloonTextChar
{font-family:"Tahoma","sans-serif"}
.MsoChpDefault
{font-family:"Calibri","sans-serif"}
@page WordSection1
{margin:72.0pt 72.0pt 72.0pt 72.0pt}
div.WordSection1
{}
-->
</style>
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">Phil,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">It’s also often worth checking exactly what’s being executed against the database – you can do this by setting the environment variable DBI_TRACE=1</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">I’ve not tried this with eprints, but putting this in any script or .pm file that gets loaded usually just works:</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">BEGIN {</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> $ENV{DBI_TRACE} = 1;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">}</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">You can also output the data to a file, like so:</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">BEGIN {</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> $ENV{DBI_TRACE} = “1=/path/to/logfile”;</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">}</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">Hope this helps,</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">Carl Franks</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">Technology and Innovation in Learning Team</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">Medical Education Institute</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Arial","sans-serif"">University</span><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> of Dundee</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">School of Medicine</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"">ext 35508</span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
<p class="MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif""> </span></p>
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk]
<b>On Behalf Of </b>sf2<br>
<b>Sent:</b> 25 July 2012 13:41<br>
<b>To:</b> eprints-tech@ecs.soton.ac.uk<br>
<b>Subject:</b> [EP-tech] Re: We are at our wits end,</span></p>
<p class="MsoNormal"> </p>
<p>Hi Phil,</p>
<p>For info, which EPrints version are you using?</p>
<p>Worth a try:</p>
<p>- have you tried to reindex the eprint dataset? (bin/epadmin reindex <archive_id> eprint)</p>
<p>- have you tried debugging the search to see which SQL statement gets executed (**) ?</p>
<p>Seb</p>
<p>(**) to enable SQL debugging, edit perl_lib/EPrints/Search/Condition.pm, look at the end of "sub sql" for:</p>
<p>#print STDERR "\nsql=$sql\n\n";</p>
<p>Un-comment the line above, restart apache and re-run the problematic search - feel free to copy/paste the SQL query here so we can have a look.</p>
<p> </p>
<p>On Wed, 25 Jul 2012 22:12:26 +1000, "Phil" <philpearson@iinet.net.au> wrote:</p>
<blockquote style="border:none; border-left:solid #1010FF 1.5pt; padding:0cm 0cm 0cm 4.0pt; margin-left:3.75pt; margin-top:5.0pt; margin-bottom:5.0pt">
<div>
<p class="MsoNormal" style="">If anyone can help we would very much appreciate it, we have posted this issue numerous times and had someone control our eprints server but the problem will not go away. </p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">I will explain it step by step</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">If I look at the database directly and query the index I get the following result</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""><span style="border:solid windowtext 1.0pt; padding:0cm"><img width="542" height="276" id="Picture_x0020_1" src="cid:image001.jpg@01CD6A6D.970C5600" alt="Description: Image removed by sender."></span></p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">You can see the word “Green” and “Bans” are in the index</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">So we should be able to find this book in the advanced or simple search using the term “green bans”</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""><span style="border:solid windowtext 1.0pt; padding:0cm"><img width="860" height="157" id="Picture_x0020_2" src="cid:image002.jpg@01CD6A6D.970C5600" alt="Description: Image removed by sender."></span></p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">Unfortunately when we do we get only one result below</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""><span style="border:solid windowtext 1.0pt; padding:0cm"><img width="934" height="333" id="Picture_x0020_3" src="cid:image003.jpg@01CD6A6D.970C5600" alt="Description: Image removed by sender."></span></p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">Whilst this is correct, it is incomplete, the search should have also returned record 3594</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">If you look back at the SQL above you will see the other words in the title</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">If I put a few of them in the search as per below, I get the correct result:</p>
<p> </p>
<p class="MsoNormal" style=""><span style="border:solid windowtext 1.0pt; padding:0cm"><img width="829" height="124" id="Picture_x0020_4" src="cid:image004.jpg@01CD6A6D.970C5600" alt="Description: Image removed by sender."></span></p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style=""><span style="border:solid windowtext 1.0pt; padding:0cm"><img width="859" height="347" id="Picture_x0020_5" src="cid:image005.jpg@01CD6A6D.970C5600" alt="Description: Image removed by sender."></span></p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">I have erased the index record and reindexed the item to no avail.</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">This is not the only record that does not return from a search and it makes our catalogue unusable.</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">I have installed xapian but that also gives me problems as per a post of mine two days ago.</p>
<p> </p>
<p class="MsoNormal" style=""> </p>
<p> </p>
<p> </p>
<p class="MsoNormal" style="">We have put a lot of effort into this migrating from the old system, if we cannot fix this we will have to go through the whole process again with something else.</p>
<p> </p>
</div>
</blockquote>
<p> </p>
</div>
<br>
The University of Dundee is a registered Scottish Charity, No: SC015096
</body>
</html>