MohmmedAshraf / laravel-translations

Laravel Translations UI package provides a user-friendly interface for managing translations in your Laravel application. It simplifies tasks such as adding, editing, deleting, and exporting translations. The package also includes a handy search feature and the ability to invite collaborators for easy translation management
MIT License
649 stars 91 forks source link

Update create_phrases_table.php #55

Closed NoahNxT closed 10 months ago

NoahNxT commented 10 months ago

Solves the issue on the installation of running the migrations. Reference issue: https://github.com/MohmmedAshraf/laravel-translations/issues/53

In Connection.php line 822:

SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'status' can't have a default value (Connection: mysql, SQL: create table ltu_phrases (id bigint unsigned not null auto_increment primary key, uuid char(36)
not null, translation_id bigint unsigned not null, translation_file_id bigint unsigned not null, phrase_id bigint unsigned null, key varchar(255) not null, group varchar(255) not null, value text null, status longtext not null default 'activ
e', parameters json null, note text null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

In Connection.php line 574:

SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'status' can't have a default value

MohmmedAshraf commented 10 months ago

Thanks @NoahNxT

NoahNxT commented 10 months ago

Don't forget to update and close https://github.com/MohmmedAshraf/laravel-translations/issues/53 💪 Keep up the good work! We already integrated it at our company and we are very happy with it 🫡

MohmmedAshraf commented 10 months ago

Glad you're enjoying the package! 😍, The status field wasn't intended to be there; it was initially planned for upcoming features related to versions and history. Unfortunately, I forgot to remove it before the release, since you've fixed the error, I'll keep it for now and consider you a new contributor. 😃 Thanks