search

igweze / wizgrade

PHP school management system
http://www.fobrain.com
26 stars 16 forks source link

Student Conduct #9

Closed packerdency closed 2 weeks ago

packerdency commented 3 years ago

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 commented 3 years ago

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

igweze commented 3 years ago

@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 commented 3 years ago

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