[Koha] error in acquisition in 3.6 version

[Ian Walls]

Sunita,


This error is coming up because the owner of one of your baskets is not a
valid borrower anymore.  Either the value in the aqbasket.authorisedby is
not a borrowernumber, or it belongs to a deleted borrower.

You can identify all baskets with 'problem' owners with this Report:

SELECT basketno FROM aqbasket LEFT JOIN borrowers USING (borrowernumber)
WHERE borrowers.borrowernumber IS NULL

You'll just need to go into your database, then, and update those basket
owners to a valid borrower.

We've run into this bug before, and a patch has been generated, but it
doesn't look like it made it into 3.6.  If you're on a git install, once
it's patched, you can pull the newest code, and not have to worry about
this. Otherwise, modifying your database is probably going to be the fastest
way to make this issue go away.

Cheers,


-Ian

2011/10/24 Sunita Barve <sunitabarve at gmail.com>

> While checking acquisitions in 3.6 the following error occured while
> searching the vendors as well as while closing the basket in acquisitions
> module.
> Software error:
>
> Can't use an undefined value as a HASH reference at /usr/share/koha/intranet/cgi-bin/acqui/booksellers.pl line 114.
>
>  For help, please send mail to the webmaster (webmaster at localhost<webmaster at lib-pc>),
> giving this error message and the time and date of the error.
> reg
>
> Sunita Barve, Ph. D.
> SIRC-In-Charge
> National Centre for Radio Astrophysics
> Post Bag No. 3, Pune Univ. Campus
> Pune 411 007, INDIA
> Phone : Office : 91-20-25719211
>             Residence : 91-020- 24470022
>             Mobile: 9922753827
> Email : sunitab at ncra.tifr.res.in ; sunitabarve at gmail.com
>
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>


-- 
Ian Walls
Lead Development Specialist
ByWater Solutions
Phone # (888) 900-8944
http://bywatersolutions.com
ian.walls at bywatersolutions.com
Twitter: @sekjal
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.katipo.co.nz/pipermail/koha/attachments/20111024/f59e1ad0/attachment.html>