school-management-system icon indicating copy to clipboard operation
school-management-system copied to clipboard

I can’t upload any data, and I get an error when trying to add new students, teachers, or other information,

Open bilalnoob opened this issue 1 year ago • 1 comments

Fatal error: Uncaught mysqli_sql_exception: Field 'request_date' doesn't have a default value in /opt/lampp/htdocs/project/school-management-system-main/assets/addStudent.php:80 Stack trace: #0 /opt/lampp/htdocs/project/school-management-system-main/assets/addStudent.php(80): mysqli_stmt_execute(Object(mysqli_stmt)) #1 {main} thrown in /opt/lampp/htdocs/project/school-management-system-main/assets/addStudent.php on line 80

bilalnoob avatar Jul 21 '24 12:07 bilalnoob

Reason - The main reason for this error is that the request date does not have a default value. As a result, when entering data into the table, the data is not set properly and does not satisfy the table structure.

Solution -

  • Add a default value to the column causing the error, such as NULL or an empty string ('').
  • You can manually change it from your phpMyAdmin dashboard.

Conclusion - The project was built on PHP version 8.1 and is designed to run in its native environment. Making changes could affect its performance on other platforms. Therefore, we recommend trying to run the project on a different platform where it should work perfectly.

Help - If you need any assistance, feel free to reach out to us.

ProjectsAndPrograms avatar Aug 08 '24 17:08 ProjectsAndPrograms