Unable to create searchindex table on hosts that don't support MyISAM
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 3.6k
- Forks
- 705
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 134
Description
Description
Installation of Craft fails on hosts or systems that don't support the MyISAM storage engine. The searchindex table appears to be the only table that uses MyISAM, all the other tables use InnoDB.
I realize that not many hosts have MyISAM disabled, but on the off chance that you come across one that does, the error messages MySQL returns are less than clear.
I my case I was receiving an error that incorrectly indicated the system was out of disk space.
Switching the storage engine to InnoDB and creating the searchindex table manually solved the issue.
Steps to reproduce
- Attempt any installation or migration on/to a host running MySQL with MyISAM support disabled (i.e. Microsoft Azure MySQL instances)
- You will likely receive an error along the lines of "MySQL Error Code: 1030. Got error -1 from storage engine;"
Additional info
- Craft version: Any
- PHP version: Any
- Database driver & version: MySQL without MyISAM storage engine support
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Locate the schema or migration that creates the searchindex table and compare its storage engine with the other tables. Reproduce installation or migration against MySQL without MyISAM support; done means searchindex is created successfully without the misleading storage-engine error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- database
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100