Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug] Index length limit #48

Closed
azlux opened this issue Jun 4, 2019 · 12 comments
Closed

[Bug] Index length limit #48

azlux opened this issue Jun 4, 2019 · 12 comments
Assignees
Labels
bug Something isn't working

Comments

@azlux
Copy link

azlux commented Jun 4, 2019

Describe the bug
The installation fail during the database creation.

www-data@urlhum:~/html$ php artisan migrate
**************************************
*     Application In Production!     *
**************************************

 Do you really wish to run this command? (yes/no) [no]:
 > yes

Migration table created successfully.
Migrating: 2014_10_12_000000_create_users_table

   Illuminate\Database\QueryException  : SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes. (SQL: alter table `users` add unique `users_email_unique`(`email`))

To Reproduce
Steps to reproduce the behavior:

  1. Use mariadb database
    this limitation is link to the default database innoDB and the char-set you use (utf8mb4_bin)

The best is to reduce the index length or to use the char-set utf8_bin.

Best regards,
Az

@Azocki
Copy link

Azocki commented Jun 5, 2019

do you have discord?
i know this issue simple to fix the error say it already.

@optiroot
Copy link
Member

optiroot commented Jun 5, 2019

Thank you for creating this issue.
This issue is pretty common with Laravel and MariaDB: Will work on a fix as soon as possible.
Thanks!

@optiroot optiroot added the bug Something isn't working label Jun 5, 2019
@optiroot optiroot self-assigned this Jun 5, 2019
@azlux
Copy link
Author

azlux commented Jun 5, 2019

@Azocki Yes I have it. You can send me invation with my github email (on my public profile)

@Azocki
Copy link

Azocki commented Jun 5, 2019

hey optiroot, you dont need to fix this, you just increase the limit

@Azocki
Copy link

Azocki commented Jun 5, 2019

@azlux add me on discord: ! Hiro い 💉#5943

@azlux
Copy link
Author

azlux commented Jun 5, 2019

@Azocki I think you need a fix (or at least a change in the wiki ) because it's not on the doc.

On my case, my database is used my multiple services. I hope increasing some limit will not break anything.

@Azocki
Copy link

Azocki commented Jun 5, 2019

noo

@Azocki
Copy link

Azocki commented Jun 5, 2019

its not increasing db, its fixing in the laravel boot file

@Azocki
Copy link

Azocki commented Jun 5, 2019

added

@optiroot
Copy link
Member

optiroot commented Jun 5, 2019

For that purpose I need fix the Laravel boot file.
Please, don't use this issue as a discussion forum. If you want to help each other using a forum-like community you can use UrlHum Docs center.

Thanks!

@Azocki
Copy link

Azocki commented Jun 5, 2019

yeah, optiroot i told him that im gonna fix it for him.

@optiroot
Copy link
Member

optiroot commented Jun 9, 2019

Fixed in #51.

@optiroot optiroot closed this as completed Jun 9, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

3 participants