L2JMobius

MySQL Error

ioioioii · 8 · 6310

Offline ioioioii

  • Vassal
  • *
    • Posts: 5
Hello, What's wrong? I install the game server in the database...

"MySQL Error: Comment for table 'bbs_favorites' is too long (max = 60)"


Online gigilo1968

  • Black Sheep
  • Elder
  • ****
    • Posts: 187
    • Hi5
change table

Code: [Select]
DROP TABLE IF EXISTS `bbs_favorites`;
CREATE TABLE IF NOT EXISTS `bbs_favorites` (
`favId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`playerId` INT UNSIGNED NOT NULL,
`favTitle` VARCHAR(50) NOT NULL,
`favBypass` VARCHAR(127) NOT NULL,
`favAddDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`favId`),
UNIQUE INDEX `favId_playerId` (`favId`, `playerId`)
)
COMMENT='This table saves the Favorite links.'
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;


Online Mobius

  • Distinguished King
  • *****
    • Posts: 16152

Offline ioioioii

  • Vassal
  • *
    • Posts: 5
change table

Code: [Select]
DROP TABLE IF EXISTS `bbs_favorites`;
CREATE TABLE IF NOT EXISTS `bbs_favorites` (
`favId` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`playerId` INT UNSIGNED NOT NULL,
`favTitle` VARCHAR(50) NOT NULL,
`favBypass` VARCHAR(127) NOT NULL,
`favAddDate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`favId`),
UNIQUE INDEX `favId_playerId` (`favId`, `playerId`)
)
COMMENT='This table saves the Favorite links.'
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;

Thank you!!!!!


Offline ioioioii

  • Vassal
  • *
    • Posts: 5
Why I don't get this error?  ???

As an ordinary user, can I publish an error report? (bug report ?)


Online Mobius

  • Distinguished King
  • *****
    • Posts: 16152
Of course you can.
Your question doesn't answers my question tho.


Offline ioioioii

  • Vassal
  • *
    • Posts: 5
Of course you can.
Your question doesn't answers my question tho.

One more question: can I use a patch with the protocol 109/110 to build Helios ?