Solved!<br><br>The collection field (ccode in the item table) was not filled in on the imported items so Koha would not check the item out. I've gone through and executed conditional SQL commands to get this information into the database and it now works brilliantly.<br>
<br clear="all">Seth Mayo<br>IT Technical Manager<br>Email: <a href="mailto:smayo@stpeters.nsw.edu.au" target="_blank">smayo@stpeters.nsw.edu.au</a><br>-------------------------------------------------------<br>St Peter's Anglican Primary School<br>
Howe Street<br>Campbelltown NSW 2560<br>PH: 02 4627 2990<br>DID: 02 8203 1368<br>Website: <a href="http://www.stpeters.nsw.edu.au" target="_blank">http://www.stpeters.nsw.edu.au</a><br><br><br>
<br><br><div class="gmail_quote">On 25 January 2011 12:38, Chris Cormack <span dir="ltr"><<a href="mailto:chris@bigballofwax.co.nz">chris@bigballofwax.co.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
2011/1/25 Seth Mayo <<a href="mailto:smayo@stpeters.nsw.edu.au">smayo@stpeters.nsw.edu.au</a>>:<br>
<div class="im">> We've just installed a new 3.2.2 installation of Koha in our library. Calyx<br>
> in Sydney Australia has helped us import data from our old system and all<br>
> the data seems quite sound and accurate barring a few adjustments which were<br>
> expected. However I have a strange problem that I'm hoping there is an easy<br>
> and quick answer to...<br>
><br>
> If looking up a book in any search box (backend or frontend) by barcode, the<br>
> system will successfully retrieve it. However when you go to checkout a<br>
> book, you find a patron - this works, then you are asked to scan the barcode<br>
> to loan the item out. When we do this, we get "Barcode was not found". So<br>
> we know the data is fine because we can search otherwise for the barcodes,<br>
> but scanning them into the checkout doesn't work. I've looked at what the<br>
> barcode reader is doing and found it to be scanning the barcode correctly.<br>
> I also tried copying and pasting the barcode form the OPAC into the checkout<br>
> box in case there is some data problem there but this still returns nothing.<br>
><br>
> Any suggestions or help would be very appreciated! We have students<br>
> returning Thursday and, while other features can be worked through slowly,<br>
> this one is sort of critical as we all know!<br>
><br>
</div>Hi Seth<br>
<br>
Do you have commandline access to the database? If so try running<br>
<br>
SELECT barcode FROM items LIMIT 10;<br>
<br>
That should get you 10 barcodes, if they are all null, then I think we<br>
have found your problem.<br>
<font color="#888888"><br>
Chris<br>
</font></blockquote></div><br><div style="visibility: hidden; left: -5000px; position: absolute; z-index: 9999; padding: 0px; margin-left: 0px; margin-top: 0px; overflow: hidden; word-wrap: break-word; color: black; font-size: 10px; text-align: left; line-height: 130%;" id="avg_ls_inline_popup">
</div>