Opened 16 years ago

Closed 16 years ago

#904 closed Defect (fixed)

Database creation fails if default engine is InnoDB

Reported by: Nicolas Owned by: davea
Priority: Minor Milestone: Undetermined
Component: Server - Setup Version: 6.6.28
Keywords: Cc:

Description

schema.sql doesn't set an explicit storage engine for all tables, some of which have fulltext indexes. If the default storage engine in MySQL is set to InnoDB, tables needing fulltext indexes will fail to create (because InnoDB doesn't support fulltext).

In the attached patch, I add engine=MyISAM to all tables needing fulltext indexes.

Attachments (1)

explicit-db-engine.diff​ (871 bytes) - added by Nicolas 16 years ago.

Download all attachments as: .zip

Change History (2)

Changed 16 years ago by Nicolas

Attachment: explicit-db-engine.diff​ added

comment:1 Changed 16 years ago by davea

Resolution: → fixed
Status: new → closed

(In [18201]) - DB: for tables w/ fulltext indices, specify engine as MyISAM

from Nicolas; fixes #904

Note: See TracTickets for help on using tickets.