[Koha] Auto- increment problem reoccurred after machine restart

[Shivendra]

Hi Friends, recently I set up koha 18.05 versions on Ubuntu 18.04 and
migrated data from local software after doing necessary marc editing.
Everything worked well, however while checking for missing barcodes, I came
across a good number of duplicate barcode, which I later deleted using
batch item deletion module. In between I also edited lots of data having
both minor and major corrections. Simultaneously I created patrons and
checked for book check-in and check-outs and to my surprise, I was able to
check-out books, but was not able to check-in. while looking for the
reasons, the problem emerged of auto- increment with an exact error “The
following ids exist in both tables issues and old_issues:”. While looking
for solution, I came across “DELETE FROM old_issues WHERE issue_id IN (1,
2);” command and applied it after making necessary changes in numbers as
per system information. This solution worked and I was once again able to
check-in and check-out. But, the moment I restarted machine, the problem
reoccurred and am still wondering for solution.  Of late, I upgraded my
machine to koha 19.05, but the problem still persists.

I shall feel grateful, should you help me to fix this auto increment
problem and do share the reasons, as what actuated this problem .

Thanking you.

Shivendra Singh
Assistant Librarian
BFUHS, Faridkot, Punjab 151203
India
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Unknown column 'metadata' in 'field list'

[Shivendra]

Dear Vimal,

Please try with this query

SELECT biblio.biblionumber, biblio.author, biblio.title,
biblioitems.editionstatement, biblioitems.publishercode,
SUBSTRING(biblioitems.marcxml, LOCATE('',
   biblioitems.marcxml, LOCATE('', biblioitems.marcxml, LOCATE('',
   biblioitems.marcxml, LOCATE('',
biblioitems.marcxml,
   LOCATE('https://www.researchgate.net/profile/Shivendra_Singh3/contributions

On 9 August 2017 at 10:36, Vimal Kumar V. <vimal0...@gmail.com> wrote:

> Dear Friends,
> I am trying to generate a book list with keywords from 650$a using the
> following SQL query,
>
> SELECT ExtractValue( metadata,
> '//datafield[@tag="650"]/subfield[@code="a"]' ) AS Keyword, items.barcode,
> items.dateaccessioned, items.itemcallnumber, biblio.author, biblio.title,
> biblioitems.pages, biblioitems.publishercode, biblioitems.place,
> biblio.copyrightdate
> FROM items
> LEFT JOIN biblioitems ON
> (items.biblioitemnumber=biblioitems.biblioitemnumber)
> LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber)
> ORDER BY LPAD(items.barcode,40,' ') ASC
>
> After running the report, I got the following error message,
>
> The database returned the following error:
> Unknown column 'metadata' in 'field list'
> Please check the log for further details.
>
> Please review the SQL query and help me to solve the problem.
>
>
> Regards,
> --
> Vimal Kumar V.
> Librarian
> School of Indian Legal Thought
> Mahatma Gandhi University
> Kottayam, Kerala
> Web: http://www.vimalkumar.info
> Blogs: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in
> http://dspacegeek.blogspot.in
> http://moovandan.blogspot.in  <http://moovandan.blogspot.in>
> 
> ---
> "I forget what I was taught. I only remember what I have learnt"
> -Patrick White
> _______
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>



-- 
Shivendra
9815526163
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How to search in OPAC with the authorized values which are defined with filed 952$8

[Shivendra]

Dear Tripathi Ji,


How I can search in OPAC with  the authorized values which are defined by
Authorized values in category CCODE,matching with filed 952$8.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Error - Exported database from the tools

[Shivendra]

When I Exported database from the tools menu fails with the message
Internal Server Error


Can't use an undefined value as a HASH reference at
/usr/share/koha/intranet/cgi-bin/tools/export.pl line 75

For help, please send mail to the webmaster ([no address given]),
giving this error message
and the time and date of the error.

I am using Koha version 16.11.05


Please help me


-- 
Shivendra
9815526163
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] How to merge two subfield data into one subfield through Marcedit?

[Shivendra]

How to merge two subfield data into one subfield through  Marcedit?



Shivendra Singh
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] The barcode was not found

[Shivendra]

during the checking out. the message displayed The barcode was not found
how can i resolve this issue?

-- 
Shivendra
India
9815526163
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha