Page 1 of 1

problems with create_universe.php

Posted: Sat May 09, 2015 14:45 UTC
by 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

Re: problems with create_universe.php

Posted: Sat May 09, 2015 14:46 UTC
by 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.

Re: problems with create_universe.php

Posted: Mon May 11, 2015 03:33 UTC
by 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?

Re: problems with create_universe.php

Posted: Tue May 19, 2015 23:15 UTC
by 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

Re: problems with create_universe.php

Posted: Tue May 19, 2015 23:32 UTC
by 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.

Re: problems with create_universe.php

Posted: Wed May 20, 2015 05:06 UTC
by wolverine
same folder

Re: problems with create_universe.php

Posted: Sat Aug 29, 2015 00:16 UTC
by 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....