Syntax error or access violation: 1059 Identifier name is too long

Question

I receive a MySQL error when I create a table:

SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'FK_SALES_FLAT_CREDITMEMO_GRID_ARCHIVE_STORE_ID_CORE_STORE_STORE_ID' is too long

How can the default Identifier name size be increased or how can I solve this otherwise?

Welcome to SO. Please read the [FAQ] and [Ask] for tips on writing good questions. You have to include relevant information, which in your case is the `create table` statement. — Jim Garrison, Oct 30 '12 at 06:06
That is a good comment, however, this is enough information to start the investigation - if you have any identifiers over 64 chars. — Michael, Oct 30 '12 at 06:07
May this will help https://stackoverflow.com/questions/30170268/laravel-5-migration-identifier-name-too-long — Pankaj Agrawal, Jul 26 '17 at 06:03

score 43 · Answer 1 · answered Oct 30 '12 at 06:06

43

Please take a look at http://dev.mysql.com/doc/refman/5.5/en/identifiers.html - you are limited to 64 chars to an identifier.

answered Oct 30 '12 at 06:06

Michael

10,124
1
34
49

Hi, please see the mysql error message below SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'FK_SALES_FLAT_CREDITMEMO_GRID_ARCHIVE_STORE_ID_CORE_STORE_STORE_ID' is too long How to solve the problem – vinoth kumar Oct 30 '12 at 07:29
1

How to increase it to more than 64 chars? – vinoth kumar Oct 30 '12 at 07:33
10

you cannot, you have to rename the foreign key – Michael Oct 30 '12 at 08:13

score 18 · Answer 2 · edited Jul 27 '18 at 08:19

18

Provide your own shot name to key.

$table->unique(['product_id', 'company_id', 'price', 'delivery_hours'], 'prices_history_index_unique');

edited Jul 27 '18 at 08:19

rink.attendant.6

44,500
61
101
156

answered Jul 27 '18 at 08:02

Muzammil Hussain

201
2
4

For context, this answer explains how you can fix this issue with **Laravel**, when it automatically creates unique keys that are too long. In your migration you can ad the line above – Kerwin Sneijders Mar 30 '23 at 14:47

score 0 · Answer 3 · answered Dec 02 '22 at 21:59

0

Just give the primary key a shorter name.

Like this:

$table->primary(['company_store_id', 'company_product_id'], 'product_store_id');

answered Dec 02 '22 at 21:59

DeviOus

11
2

Syntax error or access violation: 1059 Identifier name is too long

3 Answers3

Linked