Searched For: Specifiedkeywastoolong;maxkeylengthis767bytes
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ddProjectsTable.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-m3atn8f1/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … me` varchar(255) NOT NULL PRIMARY KEY default '',
`video_url` varchar( … es/../sql/video.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-2zh95mun/socket)
```
…
This is merely a support request. I am m … eters TINYBLOB NOT NULL,
PRIMARY KEY (afa_filter,afa_consequence),
KEY (afa_consequence)
) ENGINE=InnoD … sefilter.tables.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-abv … charset have a size of up to 1020 bytes. That exceed the 767 bytes limit for an index. The easy workaround is to limit the size of the key/index to 191 VARCHAR (764 bytes).
----
I had the issue with a f … /r/#/c/419858/ . Given the schema …
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ` varchar(255) NOT NULL,
PRIMARY KEY (`tl_user_id`),
UNIQUE KEY `tl_twitter_id` (`tl_twitter_id`) … ma/twitter_user.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-sjvjl7fw/socket)
```
…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … trs_order int unsigned,
PRIMARY KEY (trs_page, trs_key)
) ENGINE=Inn … nslate_sections.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-ep8z8kxd/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … rvey/sql/Survey.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-wueppkqp/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … tinyint(1) DEFAULT NULL,
PRIMARY KEY (`ns_name`)
) ENGINE=InnoDB
F … namespace_names.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-n27678zx/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … /sql/spam_regex.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-l826fx_q/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … hemas/shorturls.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-cvzytjs7/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … Poll/SecurePoll.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-yead1jrg/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … gexblock_schema.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-uch67_ru/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … re` varchar(255) primary key not null,
`number` in … l/create_counts.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-n85izmlw/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … hes/GlobalUsage.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-deferw2q/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … /globalblocking.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-kop6x54u/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … d integer unsigned NULL,
PRIMARY KEY (ft_rev_id,ft_namespace,ft_title) … sql/FlaggedRevs.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-5u5evtc_/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … on` (
fe_id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
fe_name VARCHAR( … s/Farmer/farmer.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-9lepgyop/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ql/contributors.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-m56c_s4w/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … /ConfirmAccount.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-8hjkpc_4/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ../sql/comments.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-egsudwcr/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ext varchar(255) binary,
primary key (ca_repo_id, ca_author)
) ENGINE … s/../codereview.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-1p4obusw/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ./CentralNotice.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-4ltb10d0/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … Cargo/sql/Cargo.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-7ndq25ne/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … text NOT NULL,
PRIMARY KEY ( bm_bibtexCitation )
) ENGINE=I … ance/bibmanager.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-6q4zvd7s/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … re` varchar(255) primary key not null,
`number` int … l/create_counts.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-hiiwttb5/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … al BOOL,
su_error TEXT,
PRIMARY KEY (su_name),
KEY(su_normalized, su_name)
) ENGINE … antispoof.mysql.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-u0z8hu64/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ` datetime default NULL,
PRIMARY KEY (`poll_id`,`poll_user`)
) ENGIN … --ajaxpoll_vote.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-hkzoeqmk/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … re` varchar(255) primary key not null,
`number` int … l/create_counts.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-8g9g9lae/socket)
```…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ation-watchlist.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-y_7gguhv/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … Contest/Contest.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-peszq8_b/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … eters TINYBLOB NOT NULL,
PRIMARY KEY (afa_filter,afa_consequence),
KEY (afa_consequence)
) ENGINE=InnoD … sefilter.tables.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes…
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ducationProgram.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-pcb0oor6/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … ../sql/comments.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-wp_s7n4r/socket)
```
When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fail … trs_order int unsigned,
PRIMARY KEY (trs_page, trs_key)
) ENGINE=Inn … nslate_sections.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-n7dsyle6/socket)…
s an error in creating the user table `ERROR 1071 (42000) at line 3: Specified key was too long; max key length is 767 bytes`,
* the latter makes sqlalchemy … tabase server.
CC T194691 T192698
310 characters (in Unicode) results in keys that are larger than the 767 byte limit in MySQL. The update.p … ils with this error:
Error: 1071 Specified key was too long; max key length is 767 bytes (127.0.0.1:3306)
If I manually h … cess appears to be successful.
I was able to reproduce the problem whe … m trying to set up a project that is powered by Wikibase along the lin … n work with the Wikidata instance.
NULL,
imgcomment_description_id bigint unsigned NOT NULL,
PRIMARY KEY (imgcomment_name, imgcomment_desc … ment_temp-table.sql )
Error: 1071 Specified key was too long; max key length is 767 bytes (localhost)
Backtrace:
#0 /.../i …
Other tickets suggest that this is the result of using utf8mb4, which is resulting in, well, primary keys longer than 767 bytes.
The only related code changes that I could find was T227662 (f1f96285b0aa), but I don … "ltr">57.1</td>
</tr>
</table>…
are interesting to reallocate to cloudcontrol2001-dev and which not.
uteBatchSerially(PreparedStatement.java:1751)
... 55 more
```
file: '/vagrant/mediawiki/extensions/CentralAuth/central-auth.sql': Specified key was too long; max key length is 767 bytes
```
rite_rows_v1 event on table s51290__dpl_p.i_psub; The table 'i_psub' is full, Error_code: 1114; handler e … _dpl_p.i_psub; The table 'i_psub' is full, Error_code: 1114; handler e … -171975945-12881250735
```
This is the affected table:
```
mysql:roo … in NOT NULL DEFAULT '',
PRIMARY KEY (`ps_id`),
UNIQUE KEY `u_i_psub` (`ps_title`)
) ENGINE= … 1.5T 37% /srv/labsdb
```
This is the event:
```
#171114 19:42:51 s … TIMESTAMP=1510688571/*!*/;
```
…