eyetea Posted October 22, 2014 Posted October 22, 2014 Hi all, Having a bit of a problem with our Microlib / MLS! My initial feeling is something is up with the borrowers database. When we try to edit or add a user in borrowers, the window pops up as it should and hangs for about 10 secs, then displays the following error: If we have any users in the intake, we can edit (and import mass users from CSV!) Other than not being able to edit borrowers / add individual borrowers functionality seems fine. Any thoughts would be gratefully received, not sure what to do! J
LazyFanatic Posted October 22, 2014 Posted October 22, 2014 Hi, What error message do you get if you run Microlib from the server and try to insert a new borrower?
win Posted October 22, 2014 Posted October 22, 2014 Do you have a support contract? If you phone them they might have an SQL script for you to run that will sort it
bennz Posted October 23, 2014 Posted October 23, 2014 Hi, What error message do you get if you run Microlib from the server and try to insert a new borrower? If you phone MLS they will ask you to do the above as it will display exactly what the issue is, try it and post up another screenshot
eyetea Posted October 23, 2014 Author Posted October 23, 2014 Hi Guys, thanks for the replys. Here is the screenshot from when I attempt to edit / add a borrower from the server itself.
bennz Posted October 23, 2014 Posted October 23, 2014 Do you have a yeargroup or tutorgroup with a value "9.." ?
eyetea Posted October 23, 2014 Author Posted October 23, 2014 (edited) Only ones that begin with 9 that I can see are: 9A, 9S, 9ARTS, 9T, 9R Edit - and just the Year Group 9 Edited October 23, 2014 by eyetea
LazyFanatic Posted October 23, 2014 Posted October 23, 2014 I am no sql expert but it appears to me as though you have managed to get some illegal characters into a field on your database. Did you import your new students via csv? did the problems start to happen after the import? If you did import the data do you still have the csv, if so have a look at the data, I am guessing that there is something in (probably) the barcode field that is not an integer.
bennz Posted October 23, 2014 Posted October 23, 2014 Did you check the recycle bin as-well? Do you have any duplicate tutor groups? It may be an idea to phone MLS and have them take a look, they may ask you to run Fiddler at the point you get the error to show exactly what is failing. 1
eyetea Posted October 23, 2014 Author Posted October 23, 2014 After a quick chat with a nice helpful person there, they've now upped it to 2nd line!
eyetea Posted October 23, 2014 Author Posted October 23, 2014 I am no sql expert but it appears to me as though you have managed to get some illegal characters into a field on your database. Did you import your new students via csv? did the problems start to happen after the import? If you did import the data do you still have the csv, if so have a look at the data, I am guessing that there is something in (probably) the barcode field that is not an integer. We're unsure how long it's been going on - our old Librarian never said anything about it after this years Y7 intake, it's only now we have a new Librarian and they've mentioned it that we know about it!
eyetea Posted October 28, 2014 Author Posted October 28, 2014 Solved! Ended up being a problem with a tutor group! MLS Were very helpful and prompt in helping us solve this. 1
MLSInstallations Posted November 5, 2014 Posted November 5, 2014 Eyetea, we're glad to hear that you got this issue solved. Thank you for the kind feedback, if any new issues do arise please don't hesitate to get in contact with us.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now