Question

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?

Share this post


Link to post
Share on other sites

12 answers to this question

  • 0

Posted (edited)

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 by GamersRoost

Share this post


Link to post
Share on other sites
  • 0
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.

Share this post


Link to post
Share on other sites
Advertisement
  • 0

ok then.

what MySQL tool do you have " MyPHP Admin"?

 

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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?

Share this post


Link to post
Share on other sites
  • 0
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

 

Share this post


Link to post
Share on other sites
  • 0

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

JqxqMY61

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.