red1
Site Admin
Joined: 06 Jul 2004
Posts: 1756
Location: Kuala Lumpur, Malaysia
|
 Posted: Tue Nov 21, 2006 3:10 pm Post subject: Library System - Issues and Bugs |
 |
|
| khairin wrote: | New problem came up today. The librarian cannot add new books into the catalogue.
Succeeded only up to adding new title.
Failed when adding new item for the new title.
Problem seemed to occur also when adding new item to existing old titles. |
Actions Checked on own instance, no problem, item can be created. Checked on college instance, problem exist.
Reverting back to own instance to id which tables show ok. Lib_Book_Item.
In there there is item_id that is auto set somewhere else, everytime a new book is added. Problem is that id increments from some last count, but it is wrong.
Have to locate the source of that by tracing jsp that sets item_id.
Found and set break at Item.java.setId(id) and found it to increment whenever we add new id. finally solved it when encounter DualItem() which does the nextID increment from a hard c data file in C:\Library.
So that is the cause becos we did not copy over the library from C:\folder the last time. How many new records created since then last week? If no new items created i think ok. Actually it can be solved by going into C:\library\data\dual > item (open that file and changed the figure in it to next ID or larger number so that it wont overlap with old running number and so cannot be new item. Another way is just to delete the dual files so that it fails to get next id and return a UID instead but i m not sure if it creates impact on other areas. So just copy over C:\Library contents to new server. |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
