problem in Check in and check out

[srinaththota]

Hi Good evening,

I just re-installed newgenlib on my system. I have restored the backup perfectly. But when I check in document it is showing me "critical error occurred on newgenlib server". while check out it is showing "invalid item barcode."

But I am able find the all the records by searching and all the records I am accessing through OPAC. But I am not able to Issue or returning them. Please help me in this context.

One more thing While modifying and creating new record it is showing following message.

Please configure sublocation or collection.

I have executed following query in pgadmin III
update library_holdings set sublocation_id=1;

But it giving me following error.

ERROR:  column "sublocation_id" of relation "library_holdings" does not exist

What should I do now. Please give me a reply. I am sending Jboss server log file as well as postgresql log file. please find the attachments.

Thanks in advance
srinath
server.rar
postgresql-2011-02-15_150946.log

[verussolutions]

Please download this file http://sourceforge.net/projects/newgenlib/files/NewGenLib/version2.2/scripts2_2From2_1.txt/download

This is a text file that has sql scripts, run this script file against your database using psql tool

[srinaththota]

Thanks.

It's working.

[srinaththota]

Some of the records I am able to modifying/deleting. but some of them are not. what could be the reason.
I have check the postgres logs it is showing me like this.

ERROR:  update or delete on "document" violates foreign key constraint "fk__cir_transaction__1bc8ed34" on "cir_transaction"

2011-02-17 15:04:05 DETAIL:  Key (accession_number,library_id)=(PH-45,1) is still referenced from table "cir_transaction".

whatever I am modifying/deleting the records are not on Circulation.

I also executed following line in pgadmin III.
update library_holdings set sublocation_id=1; It has given me following  message.

Query returned successfully: 493 rows affected, 78 ms execution time.

I dont know where to save that after executing the script. I just saved on my C Drive.

Please guide me.

srinath

[verussolutions]

Circulation is done on Barcodes (Accession numbers). Hence if any circulation takes place
1. You cannot delete the catalog record. But you can modify it
2. You can neither edit or delete accession number. However you can still change call number, shelving location, physical/presentation form

[ramesh, g.]

Sir,
Please let me know whether NGL is available to work on WINDOWS 7 platform.

Our systems are upgraded with windows 7.  I am unable to install NGL, what is the solution.

Awaiting your valuable reply.

--
G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540

[verussolutions]

Yes NGL runs on Windows 7
However you must install Postgresql 8.3 or 8.4 on Windows 7. Postgresql 8.0 does not run on Windows 7
Secondly, in C:/NewGenLibFiles/SystemFiles/Env_Var.txt file add another property
POSTGRESQL_VERSION=8.3

Even if you are installing Postgresql 8.4, still the property value must be 8.3

[ramesh, g.]

Dear Sir,
Please let me know the steps involved in installing Sql 8.4 on windows 7.  Even I could not succeed several attempts.  Except SQL 8.4 remaining procedure is working.

Awaiting your early reply.

G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540

[verussolutions]

just disable the UAC(user account control) on 'users' for anyone w the same problem.

[kiprawi]

dear sir,

i have problem checking out. it stated "problem occurred while checking out".

please give me advise.

tq

[verussolutions]

Pls let us know the version of NGL being used

[kiprawi]

thanks for your reply

we using version 2.5

[Amol]

Sir please tell me how to delete a catalog record which is already checked in and checked out  

[srinaththota]

I dont think. you cannot delete the records as per my knoledge. You can post this query in newgelib forum. you will get promt reply from Newgenlib guys.

 

Thank you

srinath

On Tue, Jan 31, 2012 at 2:51 PM, Amol [via NewGenLib] <[hidden email]> wrote:

Sir please tell me how to delete a catalog record which is already checked in and checked out  

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7239337.html

To unsubscribe from problem in Check in and check out, click here.
NAML

[Verus Open Source Support]

Hi,
A catalog record cannot be deleted, once you have made any transactions on the same. However the future updates will have
1. Force deletion
2. Publish/Un-publish catalog records from OPAC
Regards
NewGenLib Open Source Team

On Tuesday 31 January 2012 02:51 PM, Amol [via NewGenLib] wrote:

Sir please tell me how to delete a catalog record which is already checked in and checked out  

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7239337.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[mavic]

hi.
can you delete transaction record so that you can delete an item.
i also need to delete some items that has already been borrowed and i need to do it asap.
thanks.

[Verus Open Source Support]

Hi, currently it is not possible to delete a catalogue record or even the barcode after transactions are made on the same. The following functionalities are planned for the future
1. Publish/Un-publish records from the OPAC
2. Force delete of catalogue records and accession numbers

However if this procedure is very urgent, you may send an email to the info email id the list of accession numbers. We will send you queries to remove the circulation transactions. This will allow you to delete the catalogue records

On Friday 17 February 2012 07:17 AM, mavic [via NewGenLib] wrote:

hi.
can you delete transaction record so that you can delete an item.
i also need to delete some items that has already been borrowed and i need to do it asap.
thanks.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7292967.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[pedroparkero]

Hello, I have a problem. An item is still charged to a patron even though it is already checked in. As a result, whenever I input the Userid, "Patron holds overdue Material" message shows. I have tried to check in the item that shows in "Items held by patron" in Patron Information, but the Check in module say "Document available in library". I have also tried using "Re-index catalogue record" module to reindex the affected accession number, but it still shows as charged to that patron. Please tell me how to remove it.

[Verus Open Source Support]

Hi,
Open your Pgadmin3-> SQL Window and type the below 2 queries. Each query will yield a result. Send me the results of both these queries

select status from document where accession_number='your accession number.Note single quotes must be there';

select * from cir_transaction where accession_number='your accession number.Note single quotes must be there';


On 02/22/2012 07:42 AM, pedroparkero [via NewGenLib] wrote:

Hello, I have a problem. An item is still charged to a patron even though it is already checked in. As a result, whenever I input the Userid, "Patron holds overdue Material" message shows. I have tried to check in the item that shows in "Items held by patron" in Patron Information, but the Check in module say "Document available in library". I have also tried using "Re-index catalogue record" module to reindex the affected accession number, but it still shows as charged to that patron. Please tell me how to remove it.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/problem-in-Check-in-and-check-out-tp6027050p7306950.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[pedroparkero]

select status from document where accession_number='898';
returns '8'.
select * from cir_transaction where accession_number='898';
returns 3 rows, and is attached as csv: query.csv