Error: With file auto_chat.sql - auto_chat_txt.sql - etc

[obrian1180]

Good afternoon L2j community ... If not the right place for this question please do Move it ..

Community, I am creating a server Interlude. My first server. At the time of setup the tables with database_installer. Everything is going well but when creating the file table gives me an error auto_chat.sql

To be more specific on the error:
"Something Caused an error while executing instruction: mysql-h localhost-u root - password = root-D l2jdb
with file auto_chat.sql "
The rest of the text is asking me if I want to skip or reconfigure but remember that you can not leave anything "I think"

Ok, I decided to delete that file above to test whether he is alone. I went to run the auto_chat.sql, everything went well until the file auto_chat_txt.sql presented the same error above, I deleted too.

I went to run the database_installer ---- ran fine until I get to random_spawn_loc. I deleted this and turned to run database_installer

Installed everything. But the files that had missed errors.

Community In conclusion, these three files:
auto_chat
auto_chat_text
random_spawn_loc

I get an error when the tables created why?


I'm using the data_pack and server_pack of INTERLUDE
http://www.l2jserver.com/nightly/index.php?dir=old% 2FInterlude% 2F

I tried to use the most current server_pack data_pack and features more errors but I ...

Thanks, I hope I understand. I try to be as specific ...

[obrian1180]

Thanks to "Pendragon" could fix I explain;
The auto_chat.sql have this header file:

DROP TABLE IF EXISTS `auto_chat`;
CREATE TABLE `auto_chat` (
   `groupId` INT NOT NULL default '0 ',
   npcId `` INT NOT NULL default '0 ',
   chatDelay `` BIGINT NOT NULL default '-1',
   PRIMARY KEY (`groupId`)
) ENGINE = InnoDB

The sentence ") ENGINE = InnoDB" must be deleted, leaving this:
DROP TABLE IF EXISTS `auto_chat`;
CREATE TABLE `auto_chat` (
   `groupId` INT NOT NULL default '0 ',
   npcId `` INT NOT NULL default '0 ',
   chatDelay `` BIGINT NOT NULL default '-1',
   PRIMARY KEY (`groupId`)
);

gracias