MySQL strict mode enabled - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL strict mode enabled (/showthread.php?tid=369917)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL strict mode enabled (/showthread.php?tid=369917)
MySQL strict mode enabled - sidney123 - 18.08.2012
Hello there,
I downloaded a gamemode and I requested a database by my hosting company, but when I configured everything.. I started the gamemode and I couldn't create an account. Problem is that the script is not created with strict mode enabled, and my hosting company refuses to disable it. My question is:
How can I convert the script so that it disable strict mode?
Thanks in advance,
Sidney.
Re: MySQL strict mode enabled - sidney123 - 18.08.2012
No-one who can help me?
Re: MySQL strict mode enabled - sidney123 - 18.08.2012
Nope, that doesn't work.. the server returns the following:
Quote:
|
#1227 - Access denied; you need the SUPER privilege for this operation |
Thanks.
Re: MySQL strict mode enabled - Jstylezzz - 18.08.2012
I never heard of strict mode or something..
It's not enabled on my gamemode nor the servers I host as far as i know..
What MYSQl plugin are you using?
Re: MySQL strict mode enabled - sidney123 - 19.08.2012
I am using G-Stylezz MySQL plugin (I think it's outdated too).
Strict mode is for debugging I think, it's more strict returning warnings and errors someone told me, and the queries are not based and created for the strict mode, really weird. My experience with MySQL is 0%, I am learning it now.
Re: MySQL strict mode enabled - Jstylezzz - 19.08.2012
Let me check a few things..
GStylezzz mysql plugin, was updated in June..
So, i don't think it's outdated..
Anyways, the problem is I can't find anything on the net about strict mode and sa-mp, maybe someone else knows more about it..
and, let's hope the one that does know much about it, looks to this thread.. i'm curious too.
Sorry I couldn't help you further :\
EDIT: maybe i can help..
which script did you download?
i can take a look at it, and maybe i can find something..
just a wild try, you never know
Re: MySQL strict mode enabled - sidney123 - 19.08.2012
Well, thing is that it's not from my script I think. When I start my server on my localhost and with xampp, it works fine.. everything works fine, but when I update the script with the information of my hosting company, it refuses to work. And I got the script with plugins from my friend on a USB stick.
Re: MySQL strict mode enabled - Jstylezzz - 19.08.2012
aah, now i get it, so the script doesn't have strict mode enabled, and that's what you want to achieve...
did you check the debug log already?
Re: MySQL strict mode enabled - sidney123 - 19.08.2012
Found some information about strict mode:
Quote:
|
Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. (For a NULL column, NULL is inserted if the value is missing.) Source: http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html |
EDIT:
Yes belhot, that's what I get. This is the string:
Quote:
|
errorid: 1364 | error: Field 'ContractBy' doesn't have a default value | callback: OnQueryFinish | query: INSERT INTO players (Username, Password) VALUES('My_Name', 'hashed_password') | connection handle: 1 | resultid: 4 | extraid: 0 |
Re: MySQL strict mode enabled - sidney123 - 19.08.2012
Yes, that's working for me. Thanks for your help.