if i megrate db i get this

pratiksh404 / doctype_admin

Laravel Admin Panel for lazy developers. Contains User Management, Roles and Permission Management, Activity Logging and integratable packages

MIT License

53 stars 12 forks source link

if i megrate db i get this #4

Closed visionto closed 4 years ago

visionto commented 4 years ago

hi, if i megrate db i get this 👍

C:\wamp64\www\laravel7\cms\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes")

2 C:\wamp64\www\laravel7\cms\vendor\laravel\framework\src\Illuminate\Database\Connection.php:464 PDOStatement::execute()

pratiksh404 commented 4 years ago

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

check out https://laravel-news.com/laravel-5-4-key-too-long-error or

Go to config/database.php -on connection array go to mysql array and change charset and collection from utf8mb4 and utf8mb4_unicode_ci to utf8 and utf8_unicode_ci

visionto commented 4 years ago

Thanks