Hi

I am using the school_administration module.
I got problem in entering the parent to a student while saving the parent.

the error occour is

Error
The website encountered an unexpected error. Please try again later.

Status message
•fyadav is registered as parent.
ID: 8
•username: fyadav
password: efwBATxi

Error message
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8-5' for key 'PRIMARY': INSERT INTO {users_roles} (uid, rid) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 8 [:db_insert_placeholder_1] => 5 ) in school_administration_parent_write() (line 2211 of C:\xampp\htdocs\drupal7\modules\school_administration\school_administration.module).

so please help me what i will do now???

Comments

tutumlum’s picture

It seems that the module is trying to add the parent to the roles table second time. Can you tell me the steps you have followed in detail? Additionally, is it version 1.0? If so, can you upgrade to the last version?

pankajyadav’s picture

HI

I have 1st enter the staff then when i enter the student automatically parent is add after every student.
when i enter the parent detail to it it show that error and after refresh it it show the email id which i enter for a parent is allready
having and show it like that
(The e-mail address fatherb@gmail.com is already taken.)

so please please help me in solving this problem .........

tutumlum’s picture

Title: school administration » Problem in entering the parent to a student while saving the parent
Version: 7.x-1.0 » 7.x-1.6
Assigned: pankajyadav » Unassigned
Status: Active » Fixed

The issue is fixed in 7.x-1.7 version.

pankajyadav’s picture

Hi

When i start adding class. It show Student without any class.
After clicking on it it show list of all the student when i mark all the student to register to class no class list is displayed .
And when i click on register button it show an error .

The error it show is like
(Error
The website encountered an unexpected error. Please try again later.
Error message
Notice: Undefined variable: classes in classes_and_lessons_st_no_cl_form() (line 415 of C:\xampp\htdocs\drupal7\modules\school_administration\classes_and_lessons\classes_and_lessons.module).
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3' for key 'PRIMARY': INSERT INTO {classes_and_lessons_student_classes} (id, academic_year, term, class, school_no) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 3 [:db_insert_placeholder_1] => 2012 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => 12 ) in drupal_write_record() (line 6888 of C:\xampp\htdocs\drupal7\includes\common.inc). )

so please help me What will i do now??????????

pankajyadav’s picture

Title: Problem in entering the parent to a student while saving the parent » school administration
Version: 7.x-1.6 » 7.x-1.0
Status: Fixed » Active

Hi

When i added the student to the classes it show the population to the classes is 0.
It will display like this:-
Classes
Add New Class

View Recent Terms: [ 2012/1 ]

Recorded classes for 2011-2012 / 1:
Class Capacity Population Supervisor Homeroom Teacher
Medical 12 0 Anil Yadav
Non Medical 12 0 Raj Kumar

But when i check the classes it will show the added student to it .
so what's the problem please help me

pankajyadav’s picture

Hi

When i add the teacher, class and lesson to assign teacher and class to it will show error like

Error
The website encountered an unexpected error. Please try again later.
Error message
Notice: Undefined offset: 0 in classes_and_lessons_tcl_edit_form() (line 117 of C:\xampp\htdocs\drupal7\modules\school_administration\classes_and_lessons\classes_and_lessons.inc).
PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'lesson_hour' at row 1: INSERT INTO {classes_and_lessons_tcl} (class, academic_year, term, lesson_hour, lesson, teacher) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 14 [:db_insert_placeholder_1] => 2012 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 5:30 [:db_insert_placeholder_4] => 12 [:db_insert_placeholder_5] => 4 ) in classes_and_lessons_tcl_edit_form_submit() (line 306 of C:\xampp\htdocs\drupal7\modules\school_administration\classes_and_lessons\classes_and_lessons.inc)

so please help me??????????????

pankajyadav’s picture

Hello

I am having problem in adding the teacher, class and lesson it show's error in doing so
so please help me how i will add it to my project so that it will work properlly .
so please help me???????????

tutumlum’s picture

Title: school administration » Problem in entering the parent to a student while saving the parent
Status: Active » Fixed

Please open separate issues for every issue.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.