search

edenroseFR / Web-based-SSIS

A web-based student information system made using Flask framework and MySQL.
MIT License
19 stars 9 forks source link

fix database ONLY_FULL_GROUP_BY mode #68

Open moyalx opened 6 months ago

moyalx commented 6 months ago

please add this command to the script.sql file :

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

if ONLY_FULL_GROUP_BY be active, this cause error on colleges pages !

edenroseFR commented 6 months ago

@moyalx can you paste the error it causes on the Colleges page? Thanks

moyalx commented 6 months ago

@edenroseFR Screenshot from 2024-02-27 11-07-16

another problem I have is that login page not working at all . http://127.0.0.1:8080/students page comes without any authentication

edenroseFR commented 6 months ago

@moyalx, I'll look into this whenever I have the time. Meanwhile, you can create a PR if you find a fix. Thanks for submitting this btw :)