search

diydeveloper / cms-canvas

Laravel CMS
36 stars 33 forks source link

Database error in istalling CMS Canvas #19

Closed bhandarims-dev closed 7 years ago

bhandarims-dev commented 7 years ago

Hi,

I have install cms canvas all good but if I rum php artisan migrate command in my terminal the following database error is occurred, please solve my problem as soon as possible.

[Illuminate\Database\QueryException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table entries add index entries_url_title_index(url_title))

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

diydeveloper commented 7 years ago

What version of MySQL are you using?

diydeveloper commented 7 years ago

Nevermind, I believe I found the answer on http://stackoverflow.com/questions/15157227/mysql-varchar-index-length which states:

If you specify an index prefix length that is greater than the allowed maximum value, the length is silently reduced to the maximum length. In MySQL 5.6 and later, specifying an index prefix length greater than the maximum length produces an error.

I will work on getting a fix that explicitly specifies the index size.

diydeveloper commented 7 years ago

This has been address by commit 0e8d3e1aae216adcdbd85facbb2cd52e40949ab3 which has been tagged as v2.1.1.

If you do a composer update and re-run the migrations it should work.