In ERPNext 8 schools module Assessment Result Tool doesn't work

In the schools module, after creating an assessment plan and assessment result, it doesn’t show anything in the Assessment Result Tool, why is that? It appears that ERPNext version 8 is full of bugs…

Ilyes,

To troublesheet, check the database for the expected data that you entered there -

From a terminal console please run these commands:

frappe@erpnext:~/frappe-bench$ bench mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 2835
Server version: 10.0.27-MariaDB-1~trusty mariadb.org binary distribution

Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [d56cb677eaab3383]>

MariaDB [d56cb677eaab3383]> select * from `tabAssessment Result`;
Empty set (0.00 sec)

MariaDB [d56cb677eaab3383]> select * from `tabAssessment Plan`;
Empty set (0.01 sec)

Here is the result of these commands:

MariaDB [d56cb677eaab3383]> select * from tabAssessment Result;
ERROR 1146 (42S02): Table ‘d56cb677eaab3383.tabAssessment’ doesn’t exist
MariaDB [d56cb677eaab3383]> select * from tabAssessment Plan;
ERROR 1146 (42S02): Table ‘d56cb677eaab3383.tabAssessment’ doesn’t exist
MariaDB [d56cb677eaab3383]>

Pardon me, the select requires backtick quotes, like this

MariaDB [d56cb677eaab3383]> select * from `tabAssessment Result`;

MariaDB [d56cb677eaab3383]> select * from `tabAssessment Plan`;

Here is the result for select * from tabAssessment Result;

MariaDB [d56cb677eaab3383]> select * from tabAssessment Result;
±----------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±------±-------------±-------±----------±--------±----------±----------±--------±--------------±-------------±--------------±-----------±------------±--------------------+
| name | creation | modified | modified_by | owner | docstatus | parent | parentfield | parenttype | idx | grade | student_name | result | student | comment | _liked_by | _comments | _assign | grading_scale | amended_from | maximum_score | _user_tags | total_score | assessment_plan |
±----------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±------±-------------±-------±----------±--------±----------±----------±--------±--------------±-------------±--------------±-----------±------------±--------------------+
| RES000001 | 2017-04-26 14:06:46.866642 | 2017-04-26 14:06:55.448204 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | 18 | Karim Houari | NULL | STUD00001 | NULL | NULL | NULL | NULL | note sur 20 | NULL | 20.000000 | NULL | 18.000000 | interro math-1 |
| RES000002 | 2017-04-26 14:49:25.423804 | 2017-04-26 14:49:29.200206 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | 12 | Hamid | NULL | STUD00002 | NULL | NULL | NULL | NULL | note sur 20 | NULL | 20.000000 | NULL | 12.000000 | interro math-1 |
| RES000003 | 2017-04-26 14:52:53.886727 | 2017-04-26 14:52:56.343913 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | 18 | Hamid | NULL | STUD00002 | NULL | NULL | NULL | NULL | note sur 20 | NULL | 20.000000 | NULL | 18.000000 | test français |
| RES000004 | 2017-04-26 15:07:17.422458 | 2017-04-26 15:07:20.376013 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | 19 | Karim Houari | NULL | STUD00001 | NULL | NULL | NULL | NULL | note sur 20 | NULL | 20.000000 | NULL | 19.000000 | test français |
| RES000005 | 2017-04-27 18:24:27.240254 | 2017-04-27 18:24:38.368618 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | NULL | Hamid | NULL | STUD00002 | NULL | NULL | NULL | NULL | Note sur 10 | NULL | 10.000000 | NULL | 8.500000 | Examen de Français |
±----------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±------±-------------±-------±----------±--------±----------±----------±--------±--------------±-------------±--------------±-----------±------------±--------------------+
5 rows in set (0.00 sec)

and the result for select * from tabAssessment Plan;

MariaDB [d56cb677eaab3383]> select * from tabAssessment Plan;
±--------------------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±-----------±----------±---------±--------------------±----------------±------------------±-----------±-------------±----------±------------------------------------------±--------±--------------±----------------±--------------±----------±----------------±-------±--------------±----------------±--------------±-------------------------±--------------+
| name | creation | modified | modified_by | owner | docstatus | parent | parentfield | parenttype | idx | supervisor | examiner | course | assessment_name | supervisor_name | grading_structure | _user_tags | amended_from | _liked_by | assessment_group | _assign | student_group | to_time | schedule_date | _comments | from_time | room | examiner_name | assessment_code | student_batch | maximum_assessment_score | grading_scale |
±--------------------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±-----------±----------±---------±--------------------±----------------±------------------±-----------±-------------±----------±------------------------------------------±--------±--------------±----------------±--------------±----------±----------------±-------±--------------±----------------±--------------±-------------------------±--------------+
| Examen de Français | 2017-04-27 18:23:28.534394 | 2017-04-27 18:23:55.270221 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | INS/00001 | NULL | francais | Examen de Français | Laouni | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 19:26:11.000000 | 2017-04-28 | NULL | 19:26:11.000000 | NULL | NULL | NULL | 1AP-A-2018-19 | 10.000000 | Note sur 10 |
| interro math | 2017-04-26 13:59:43.299521 | 2017-04-26 14:04:21.228779 | Administrator | Administrator | 2 | NULL | NULL | NULL | 4 | NULL | NULL | math | interro math | NULL | NULL | NULL | NULL | NULL | Premieres interrogations du 1er trimestre | NULL | NULL | 10:21:36.000000 | 2017-04-26 | NULL | 08:21:36.000000 | RM0001 | NULL | NULL | 1AP-A-2018-19 | 20.000000 | note sur 20 |
| interro math-1 | 2017-04-26 14:06:12.125833 | 2017-04-26 14:06:15.279806 | Administrator | Administrator | 1 | NULL | NULL | NULL | 4 | NULL | NULL | math | interro math | NULL | NULL | NULL | interro math | NULL | Premieres interrogations du 1er trimestre | NULL | NULL | 17:37:23.000000 | 2017-06-05 | NULL | 14:21:36.000000 | RM0001 | NULL | NULL | 1AP-A-2018-19 | 20.000000 | note sur 20 |
| test arabe | 2017-01-05 18:08:40.047834 | 2017-01-05 18:08:42.569347 | Administrator | Administrator | 1 | NULL | NULL | NULL | 0 | NULL | NULL | Arabe | test arabe | NULL | | NULL | NULL | NULL | NULL | NULL | | 18:08:26.000000 | 2017-01-05 | NULL | 18:08:26.000000 | NULL | NULL | 0001 | 1AP-A-2017-18 | 0.000000 | |
| test français | 2017-04-26 14:52:14.140709 | 2017-04-26 14:52:17.420135 | Administrator | Administrator | 1 | NULL | NULL | NULL | 4 | NULL | INS/00001 | francais | test français | NULL | NULL | NULL | NULL | NULL | Premieres interrogations du 1er trimestre | NULL | NULL | 11:18:00.000000 | 2017-04-27 | NULL | 10:18:51.000000 | RM0001 | Laouni | NULL | 1AP-A-2017-18 | 20.000000 | note sur 20 |
±--------------------±---------------------------±---------------------------±--------------±--------------±----------±-------±------------±-----------±----±-----------±----------±---------±--------------------±----------------±------------------±-----------±-------------±----------±------------------------------------------±--------±--------------±----------------±--------------±----------±----------------±-------±--------------±----------------±--------------±-------------------------±--------------+
5 rows in set (0.00 sec)

i solved it, i’m really sorry for bothering you.

Good to hear you solved your problem!

A quick sentence or note of what you learned or the difficulty you overcame would help so others may benefit too, thanks…

It was my fault, i didn’t add students to the student batch.
i’m really new to erpnext

1 Like