Student Conduct

[packerdency]

I have installed the app multiple time but when ever i try to enter student conduct i get this error Error Message!
Ooops Database Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tcom_fi' in 'field list' and it is affecting every thing that has to do with results, please @igweze kindly help

[packerdency]

I was able to figure it out, a particular column was missing in the db

[igweze]

@packerdency So sorry for the late reply.

Please, contribute your result here to help others.

Don't forget to star/like my project if you like it above. Thanks

Best Regards

[igweze]

Please, if you are experiencing this error, run this SQL queries below to solve it

ALTER TABLE nur_wizgrade_class_one_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE nur_wizgrade_class_two_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE nur_wizgrade_class_three_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_one_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_two_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_three_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_four_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_five_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

ALTER TABLE pri_wizgrade_class_six_remark ADD tcom_fi VARCHAR(100) NULL AFTER princ_th, ADD tcom_se VARCHAR(100)
NULL AFTER tcom_fi, ADD tcom_th VARCHAR(100) NULL AFTER tcom_se;

Best Regards