MariaDB Migrate Errors #453

New Issue

OVERLORD · 2026-02-04T20:08:18+03:00

OVERLORD commented

2026-02-04 20:08:18 +03:00

Originally created by @vClouds on GitHub (Oct 2, 2017).

For Feature Requests

Desired Feature:

For Bug Reports

BookStack Version (Found in settings, Please don't put 'latest'): v0.18.2
PHP Version: 7.1.19
MySQL Version: 10.1.28 (MariaDB)

Expected Behavior

Following the installation instructions along with https://www.bookstackapp.com/docs/admin/ut8mb4-support/ results in the below shown current behavior.

Database already created using the below,

mysql -u root -p
CREATE DATABASE `bookstack` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
GRANT ALL ON bookstack.* to 'bookstack'@'localhost' IDENTIFIED BY 'P@ssW@rd';
FLUSH PRIVILEGES;

and adjusted using the below,

ALTER DATABASE `bookstack` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
USE `bookstack`;

Current Behavior

[Illuminate\Database\QueryException]                                         
  SQLSTATE[HY000]: General error: 1709 Index column size too large. The maxim  
  um column size is 767 bytes. (SQL: alter table `search_terms` add index `se  
  arch_terms_term_index`(`term`))
[PDOException]                                                               
  SQLSTATE[HY000]: General error: 1709 Index column size too large. The maxim  
  um column size is 767 bytes.

Steps to Reproduce

Originally created by @vClouds on GitHub (Oct 2, 2017). ### For Feature Requests Desired Feature: ### For Bug Reports * BookStack Version *(Found in settings, Please don't put 'latest')*: v0.18.2 * PHP Version: 7.1.19 * MySQL Version: 10.1.28 (MariaDB) ##### Expected Behavior Following the installation instructions along with [https://www.bookstackapp.com/docs/admin/ut8mb4-support/](url) results in the below shown current behavior. Database already created using the below, ``` mysql -u root -p CREATE DATABASE `bookstack` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; GRANT ALL ON bookstack.* to 'bookstack'@'localhost' IDENTIFIED BY 'P@ssW@rd'; FLUSH PRIVILEGES; ``` and adjusted using the below, ``` ALTER DATABASE `bookstack` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE `bookstack`; ``` ##### Current Behavior ``` [Illuminate\Database\QueryException] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maxim um column size is 767 bytes. (SQL: alter table `search_terms` add index `se arch_terms_term_index`(`term`)) [PDOException] SQLSTATE[HY000]: General error: 1709 Index column size too large. The maxim um column size is 767 bytes. ``` ##### Steps to Reproduce

OVERLORD closed this issue

2026-02-04 20:08:28 +03:00

OVERLORD commented

2026-02-04 20:08:34 +03:00

@juliusvaart commented on GitHub (Jan 11, 2018):

Had the same problem. Forgot to run php artisan key:generate

@juliusvaart commented on GitHub (Jan 11, 2018): Had the same problem. Forgot to run `php artisan key:generate`

OVERLORD commented

2026-02-04 20:08:39 +03:00

@dirsigler commented on GitHub (Feb 6, 2018):

Still have this error.
But I run the key generation...

@dirsigler commented on GitHub (Feb 6, 2018): Still have this error. But I run the key generation...

OVERLORD commented

2026-02-04 20:08:47 +03:00

@ssddanbrown commented on GitHub (May 7, 2019):

Since the last comment on this issue is relatively old I'm going to close this. If the issue remains and is something you still require to be fixed please open a new issue, referencing this one.

@ssddanbrown commented on GitHub (May 7, 2019): Since the last comment on this issue is relatively old I'm going to close this. If the issue remains and is something you still require to be fixed please open a new issue, referencing this one.

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/BookStack#453