Help with database

[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.

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

[TheCipher01]

How is your server hosted? VPS or zap hosting?

[ump50099]

vps thru nfo

on ubuntu 16.04

with php myadmin

Edited July 5, 2020 by ump50099

[TheCipher01]

Access the mysql command line and enter those commands.

[BGHDDevelopment]

Please do what was said above, if you do not know how I recommend contacting a system admin

[NorthCam18]

This content has been locked by the Community Team. If you feel this was a mistake, please report this reply with a valid reason.