This article applies to:

KnowledgeBox version: 1.5
Browser versions: all

Symptoms:
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:
 

1. Remove /home/knowledgebox/resources/LASTCOREDATASUCCESS from the KnowledgeBox server.
   
2. Have the equivalent file removed from the backend.
   
3. Re-run a normal Core Data from the KnowledgeBox administrator interface.
   
4. 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