[Answered] Sql Errors Since The Last Bugged Down

[buteekee]

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.

[buteekee]

Update:

--------------------------------------

 

Ok since strict mode of SQL they say is better than non strict, I will be just re coding all my scripts to comply with strict mode SQL.

 

Thanks anyway and please kindly close this thread.

[wolstech]

I have 2 programs that are broken due to strict mode. Mostly fields with no default, though there are some issues with bad values as you're having trouble with. The software that I run (a custom system) was originally written on MySQL 5.0 non-strict. The fact it works at all is surprising.

 

They say strict is better, but I feel like that's really only true if the software running on it was designed to take it into consideration...