Disabling Strict Mode SQL

[Special Ed 2]

Hi,

I'm getting a Bambi Character Creation Timeout message and i'm trying to disable the strict mode in my sql as is mentioned in other posts.

My problem is that I cannot locate the file i need to do this. Other directories given with other posts aren't on my server at all and i'm sorta confused.

Could anyone help? Or tell me what sort of information they need to help?

[GamersRoost 265]

17 minutes ago, Special Ed said:

Hi,

I'm getting a Bambi Character Creation Timeout message and i'm trying to disable the strict mode in my sql as is mentioned in other posts.

My problem is that I cannot locate the file i need to do this. Other directories given with other posts aren't on my server at all and i'm sorta confused.

Could anyone help? Or tell me what sort of information they need to help?

open windows explorer

in the address bar type %programdata% hit enter.

Look for My.ini in a MySQL folder.

open the file with a plain text editor like NP++ or notepad

Find  and change strictsql-mode=XXXXXXXX  to  strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

SAVE the file and restart the MySQL service.

Report if it works

Thanks,

Josh

Edited April 15, 2016 by GamersRoost

[Special Ed 2]

6 minutes ago, GamersRoost said:

open windows explorer

in the address bar type %programdata% hit enter.

Look for My.ini in a MySQL folder.

Find it and change it to  strictsql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

SAVE the file and restart the MySQL service.

Report if it works

Thanks,

Josh

Hi Josh,

Thanks for the quick reply!

Is this on the server? I'm working on a server Hosted by Host Havoc and I don't have direct access to the files via explorer, just filezilla.

[GamersRoost 265]

ok then.

what MySQL tool do you have " MyPHP Admin"?

 

[GamersRoost 265]

I did not want to leave you hanging.

Contact host and ask them to make the change.

I am off to bed. Without access to my.ini, you are reserved to contacting the host.

[Special Ed 2]

Thats ok, sorry for the late reply. Ill look in that program

[Special Ed 2]

Hi anyone who's still reading this. I contacted the server provider and they said that strict mode is off by default, and that they checked it to be sure.

Any other ideas?

[GamersRoost 265]

15 minutes ago, Special Ed said:

Hi anyone who's still reading this. I contacted the server provider and they said that strict mode is off by default, and that they checked it to be sure.

Any other ideas?

Have you ever had a working server on this host / machine?

If so what's changed?

Post your RPT and MySQL logs in pastebin.com

Post the link here. We can look at that and try to help.

sql logs are probably in @exileserver\extDB\logs

 

[Special Ed 2]

Hey so yes I did have the server working before.

The changes I made before the error started occuring were:

Changes to starting loadout

Changes to default starting money

Various changes to the exile.altis.pbo mission file.

Here are the sql logs, it looks like the error is there. (I seperated different logs with ---------)

http://pastebin.com/JqxqMY61

[GamersRoost 265]

Looks like you have duplicate ID's somehow. I would either blow out the database and start over, or post this in the SQL section of this site.

The error is related to Error: UniqueID: 1 Input String: and then has the playerUID of a player that apparently matches another . Maybe do a search and delete one of the duplicates using PHPMyAdmin

That's all i can offer man sorry for the lack of knowledge.

Josh

[Special Ed 2]

3 hours ago, GamersRoost said:

Looks like you have duplicate ID's somehow. I would either blow out the database and start over, or post this in the SQL section of this site.

The error is related to Error: UniqueID: 1 Input String: and then has the playerUID of a player that apparently matches another . Maybe do a search and delete one of the duplicates using PHPMyAdmin

That's all i can offer man sorry for the lack of knowledge.

Josh

Thanks for your help man. I'm new to all this and will now post in the SQL section.

What is the database for generally speaking? I'm not really sure what SQL is or what it even does TBH.

Also, how would I go about doing a full database wipe using myadminphp?

Edited April 16, 2016 by Special Ed