This article applies to:
KnowledgeBox version:
1.5
Browser versions:
allSymptoms:
When you try to create a new teacher, you are able to edit all fields in the ‘New Teacher’ window until you click the drop down menu to select a Teacher Type. Following this the mouse pointer remains as a hand symbol, and the only clickable field is the close button (cross symbol) in the top right hand corner of that window.
Fault:
The Teacher Type list is not present in the KnowledgeBox database.
Solution:
If you are a school administrator or ICT co-ordinator, please contact KnowledgeBox who will decide on the best course of action to resolve the problem.
If you are a KnowledgeBox Engineer, first check to see if the Teacher Type list exists in the database by logging into KnowledgeBox as root and typing the following commands:
cd /home/knowledgebox
/home/knowledgebox/sapdb/indep_prog/bin/dbmcli -d KBUKEN -u dba,qpalzm9
sql_connect dba,qpalzm9
sql_execute select * from lp_types
exit
The output from the sql_execute line should be:
OK
END
1;’Classroom teacher’;’Normal class teacher’;0;(null)
2;’Supply teacher’;’Temporary supply teacher’;0;(null)
255;’KB Administrator’;’Assumes normal class teacher + Admin privilages’;0;(null)
However, if you see something similar to the following, the teacher list is missing from the database and needs to be recreated:
ERR
-24988, ERR_SQL: sql error
1--, Row not found
To recreate the teacher list in the database:
- Remove
/home/knowledgebox/resources/LASTCOREDATASUCCESS from the KnowledgeBox server.
- Have the equivalent file removed from the backend.
- Re-run a normal Core Data from the KnowledgeBox administrator interface.
- When the Core Data has finished, log into KnowledgeBox as administrator and confirm that you can create a teacher user account.
(c)
Copyright Pearson Education Ltd. 2004