problems with create_universe.php

[wolverine]

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]

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.

[TheMightyDude]

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?

[wolverine]

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

[TheMightyDude]

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.

[wolverine]

same folder

[Ron]

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....