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 (c) 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