Search the Community

I am encountering a lot of SQL related errors, I tried to remedy it by doing dirty tricks like modifying a lot of scripts and values. All my scripts are all running good on my localhost test server but most failed when online, tried other free hosting and its all running good, except on this server. By the way, all of these scripts that I am using are all running smoothly before the 'invisible Database' Error in your server occured. One of the sample error that I encounted is this: SQL Error: 1366 - Incorrect integer value: 'NULL' for column 'gid' at row 1 Query: INSERT INTO mybb_settinggroups (`gid`,`name`,`title`,`description`,`disporder`,`isdefault` Which I get from simply trying to install a mybb plugin. Almost all of the errors that I encountered are related to SQL side. So I just want to ask if there is anything that I can do to fix this? Hoping someone could give a solution to this problem. Thanks in advance As an additional info, I already deleted the restored version of my database and created a new one, I also deleted and created a new database user and changed my Control panel password. Server: stevie user: buteekee Another thing about this error is its more about the STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION settings or the Strict mode of SQL, can it be disabled? Update: I recreated all the errors when using SQL's strict mode, so this thread is more on a request now if the strict mode for my sql be disabled.