problems with create_universe.php

Trying to install BNT? No guarantees we can help you (especially if you're hosting it on windows) but we''ll try.

Post Reply
wolverine
Posts: 5
Joined: Sat May 09, 2015 14:40 UTC

problems with create_universe.php

Post by wolverine » Sat May 09, 2015 14:45 UTC

Dropping stage complete.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=innodb' at line 1

wolverine
Posts: 5
Joined: Sat May 09, 2015 14:40 UTC

Re: problems with create_universe.php

Post by wolverine » Sat May 09, 2015 14:46 UTC

Creating Tables
Creating links Table Failed
Creating planets Table Failed
Creating traderoutes Table Failed
Creating ships Table Failed
Creating user_info Table Failed
Creating universe Table Failed
Creating zones Table Failed
Creating ibank_accounts Table Failed
Creating IGB_transfers Table Failed
Creating teams Table Failed
Creating news Table Failed
Inserting first news item Failed
Creating messages Table Failed
Creating xenobe Table Failed
Creating sector_defence Table Failed
Creating scheduler Table Failed
Creating ip_bans Table Failed
Creating logs Table Failed
Creating bounty Table Failed
Creating movement_log Table Failed
Hover over the failed row to see the error.
Database schema creation completed successfully.

User avatar
TheMightyDude
Site Admin
Posts: 311
Joined: Thu Apr 17, 2014 09:15 UTC

Re: problems with create_universe.php

Post by TheMightyDude » Mon May 11, 2015 03:33 UTC

Can you post the following:
  • What Versions of Apache, PHP and MySQL that you are using.
  • What OS are you using and its version.
  • What version of code?
To put the game into debug mode, can you create an empty file called "dev" (without the quotes and lower case) in the root folder of the game.
And then try and re-run create-universe.php

What error message is now being displayed?
TheMightyDude::Blacknova Development.
Development Blog YouTube Dev Channel Twitter Twitch

wolverine
Posts: 5
Joined: Sat May 09, 2015 14:40 UTC

Re: problems with create_universe.php

Post by wolverine » Tue May 19, 2015 23:15 UTC

i get nothing.

Server Information
Apache version: 2.2.15
PHP version: 5.4.25
MySQL version: 5.6.13
Operating System Linux
Kernel Version 3.2.40
Architecture i686

User avatar
TheMightyDude
Site Admin
Posts: 311
Joined: Thu Apr 17, 2014 09:15 UTC

Re: problems with create_universe.php

Post by TheMightyDude » Tue May 19, 2015 23:32 UTC

What folder are you putting the dev file in?
It needs to be in the same folder as setup_info.php just in case you have it in a different folder.
TheMightyDude::Blacknova Development.
Development Blog YouTube Dev Channel Twitter Twitch

wolverine
Posts: 5
Joined: Sat May 09, 2015 14:40 UTC

Re: problems with create_universe.php

Post by wolverine » Wed May 20, 2015 05:06 UTC

same folder

Ron
Posts: 21
Joined: Sat Aug 29, 2015 00:07 UTC

Re: problems with create_universe.php

Post by Ron » Sat Aug 29, 2015 00:16 UTC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=innodb' at line 1
I know this is an old post but I'll answer to help anyone who may have this in the future. This error is generated by MySQL when an older sql import is attempted to import into a newer version of MySQL. The TYPE= has been replaced with ENGINE= so the correct line entry should read ENGINE=innodb.

With this said finding this error means that you need to edit the sql import file and replace every entry that has the TYPE= to read ENGINE= and then save the file.

This will fix your database and allow the import to be a success....

Post Reply