ump50099 Posted July 5, 2020 Share Posted July 5, 2020 Was having issues with database where people can’t submit reports was given this othion for your support but not sure where I install this even after reading article help would be appreciated https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql 2nd answer. mysql> set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; mysql> set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; Quote Link to post Share on other sites More sharing options...
0 Community Administrator TheCipher01 Posted July 5, 2020 Community Administrator Share Posted July 5, 2020 How is your server hosted? VPS or zap hosting? TheCipher01 Community Administrator Link to post Share on other sites More sharing options...
0 ump50099 Posted July 5, 2020 Author Share Posted July 5, 2020 (edited) vps thru nfo on ubuntu 16.04 with php myadmin Edited July 5, 2020 by ump50099 Link to post Share on other sites More sharing options...
0 Community Administrator TheCipher01 Posted July 6, 2020 Community Administrator Share Posted July 6, 2020 Access the mysql command line and enter those commands. TheCipher01 Community Administrator Link to post Share on other sites More sharing options...
0 BGHDDevelopment Posted July 6, 2020 Share Posted July 6, 2020 Please do what was said above, if you do not know how I recommend contacting a system admin YouTube | Callouts | Twitter Link to post Share on other sites More sharing options...
0 NorthCam18 Posted July 7, 2020 Share Posted July 7, 2020 This content has been locked by the Community Team. If you feel this was a mistake, please report this reply with a valid reason. NorthCam18 Arguably the best VIP member here GitHub Account Link to post Share on other sites More sharing options...
Question
ump50099
Was having issues with database where people can’t submit reports was given this othion for your support but not sure where I install this even after reading article help would be appreciated
https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql
2nd answer.
Link to post
Share on other sites
5 answers to this question
Recommended Posts