search

igweze / wizgrade

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

Nursery Student Bulk Upload/ Admit Student Error #7

Closed adegbuyikk closed 2 weeks ago

adegbuyikk commented 4 years ago

Dear Igweze, I encountered this error while uploading students and when admitting student after online application;

Ooops Database Error: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

Kindly help to review it appropriately.

igweze commented 3 years ago

@adegbuyikk

Did you manually delete any column from the database ?

Did you export the excel from the system ?

Did you manually add/remove column from the excel files.

This might be the issue here because it seem the database and excel file doesn't match or correspond.

Thanks

adegbuyikk commented 3 years ago

Thank you for your feedback.

  1. I didn't alter the database
  2. I didn't add/remove any column in excel
  3. I have downloaded the excel from the system and it was used for Primary and Secondary. Only the Nursery section has issue.

Thank you

igweze commented 3 years ago

@adegbuyikk Good to hear from you again,

The issue is that the database and excel file doesn't match, please can you manually and separately count the field to know if the match. Thanks