STEARsoft
School
Teachers'
Electronic
Attendance
Register
software
Home page
Download
Tutorials
Support
Forum
Forum thread: Logging in a teacher first time
| Gideon Kay 02 December 2014 13:10 |
Component: Importing teacher data via ODBC What I did: Log in aa at teacher for the first time Error Message:None The resulting problem is:Service stops and crashes every time I try again. I've created a blank DB. I also reset the data to blank by renaming old data directory and reinstalling. Os is windows server 2012 R2 Many Thanks Gideon |
| Marcus Butler (STEARsoft) 02 December 2014 14:03 |
Dear Gideon, Thank you for this. Thank you also for the crash log you posted. I'd like to try and recreate the problem here as that's obviously pretty bad and shouldn't happen. It would appear to be a data-driven crash, so I'm wondering if the data you have is non-sensitive enough at this stage to send to me. I'll send you a separate email so that you can respond in that fashion. Yours, Marcus |
| Marcus Butler (STEARsoft) 02 December 2014 14:15 |
Gideon, Actually, I'm re-reading your post... Are you saying that it continues to crash even after resetting the data and reinstalling (and before connecting to your database via ODBC)? Marcus |
| Marcus Butler (STEARsoft) 03 December 2014 21:43 |
Dear Gideon, Thank you for your email with the admin data. Having looked at that I've not found any problems and it loads fine for me without crashing, so my first thought of what might be wrong was clearly incorrect. I probably need to understand exactly how and when it's crashing, and I'm not sure I'd read your post carefully enough before. My understanding is that you: 1) Import teacher accounts using ODBC 2) Log into one of these new teacher accounts 3) At that point it crashes. Assuming this to be correct, this probably points more to something in the db-user.csv file making STEARsoft unhappy. To save sending this file which might contain sensitive data, here's a little experiment if you're willing: (but if you're happy, just send the file instead) 1) Stop the server (use the 'STEAR Administrator' program to do this) 2) rename the data directory again to zap all data 3) Start the server (using STEAR Administrator) 4) Stop the server 5) A new 'data' directory will have been created. copy your db-adminnameval.csv file across (to save going through some of the 'wizard') 6) Start the server 7) Go to the web page for Administrator and jump straight to 'Add detached user' 8) Create a user account with a simple username and password. 9) Log in to this teacher account to see if it works. I'm expecting this to work, but it's a good check 10) Then stop the server 11) Copy across your db-user.csv file 12) Start the server 13) Try and log in as the teacher you've created. I'm expecting this to fail which will confirm it's some user details upsetting STEARsoft. If you're game to see if you can work out what is making it fail, try editing the db-user.csv file (deleting and simplifying things until it works). Note that to make any changes you must: - Stop the server - Open db-user.csv, make your changes, save and close the file - Start the server Let me know how you get on. Yours, Marcus |
| Gideon Kay 04 December 2014 12:53 |
Hi Marcus Tried as above and every teacher I log in as goes to (I may have this wrong) "Importing timetable, student etc. via odbc" and then it crashes. I will go back and try and create a dummy dataset and see what that does. A staff memebr without allocated pupils can get in absolutely fine (Reception power user). If it still fails I will happily send you the data. In the meantime any other ideas. Gideon |
| Marcus Butler (STEARsoft) 04 December 2014 13:24 |
Thanks Gideon, that's helpful. What I was suggesting is out the window in the light of that. Go to the STEAR Administrator program (where you can stop and start the server). In the 'Log files' bit change the 'show priorities' to 200. Read the short help and Press 'set'. Then stop and start the server. Log in as a failing teacher for it to crash. Then have a look at the log file. Once you've done this and got the log file, make sure you switch logging off or to priority 1 to avoid huge log files slowing things down. The last line in the log file will be the last thing that happened before it crashed. You may be able to work out what's going on from this, or you can send it my way... Either way I'd like to know as even if the data isn't good, STEARsoft shouldn't crash! Yours, Marcus |
| Gideon Kay 04 December 2014 14:07 |
Hi Marcus Got the error: 50,"Thurs 13:59:49.165","Sending SQL Query: SELECT CName, YearGroup, Primary FROM Class WHERE ID = '2C'" I had a mismatch on the ID column which was obviously returning a null result. I've fixed the DB and will try again from scratch. Thanks Gideon |
| Marcus Butler (STEARsoft) 04 December 2014 22:07 |
Gideon, Thank you for this and taking the time to get the bottom of it and report back. I've found and fixed the bug. Embarrasingly simple and obvious, so thank you for helping me find it. As a thank you for helping find this and to help you trial STEARsoft, I've given you a full license for 4 months to test STEARsoft more seriously including with iPads/iPhones. Just press the Activate button in the Administrator section to activate this. Yours, Marcus |
Please login to contribute to this thread.