1 Topic by RedSonja (edited by RedSonja 2016-06-02 22:02:37)

  • Registered: 2015-12-27
  • Posts: 17

I am suddenly having trouble creating a clean Character db.  This is the error I am getting, hopefully someone can help me figure out why.


Query:
CREATE TABLE `group_member` (
  `leaderGuid` int(11) unsigned NOT NULL,
  `memberGuid` int(11) unsigned NOT NULL,
  `assistant` tinyint(1) unsigned NOT NULL,
  `subgroup` smallint(6) unsigned NOT NULL,
  PRIMARY KEY (`leaderGuid`,`memberGuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups'


Error Code: 1031 - Table storage engine for 'group_member' doesn't have this option


Is this possibly because I updated MySQl Server from 5.6 to 5.7? And if so is there a safe way to downgrade it?

  • Registered: 2015-12-27
  • Posts: 17

I got it figured out.
I changed ROW_FORMAT=FIXED  to   ROW_FORMAT=COMPACT and it ran fine. Hope this will help someone else at some point in time.