• 0
Sign in to follow this  
Habits

Exile SQL file import error

Question

The SQL file that came with the exile server files was meant to create a database from scratch but with a NFO web host that isn't possible since databases have to be created through the cpanel. I had an error that stated access denied because it was trying to create a database but because of security reasons it's not allowed to do so. I quickly fixed this error by deleting the code that was trying to create this database and just have it import the tables from the SQL file. Unfortunately it came back with an error stating ...

Error
MySQL said: 

#1215 - Cannot add foreign key constraint

I cannot figure this out for anything. I am quite new to SQL so help would be much appreciated.

here's a dropbox link to the file

https://www.dropbox.com/s/pd7md0gfv407s69/exile.sql?dl=0

Share this post


Link to post
Share on other sites

4 answers to this question

  • 0

Did you......

 

Change:


# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 

To:


# Set the SQL mode to strict
sql-mode=""

Share this post


Link to post
Share on other sites
  • 0
38 minutes ago, jimmya3 said:

Did you......

 

Change:


# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
 

To:


# Set the SQL mode to strict
sql-mode=""

I haven't touched anything else except for deleting this from the beginning of the file.

 

CREATE DATABASE IF NOT EXISTS `exile` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `exile`; 

Share this post


Link to post
Share on other sites
Advertisement
  • 0
47 minutes ago, WURSTKETTE said:

Send supportticket to your host, creating the database.

I did but even they weren't able to figure it out. They suggested I post on their forums for arma and here.

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
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.