I can’t upload any data, and I get an error when trying to add new students, teachers, or other information,
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
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.