Help Installing Wave!

sanderkdna

October 19, 08:01 PM

Hi, guys, i'm having some issues installing wave, while i'm making de migrations, i'm having the next error message SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table translations add unique translations_table_name_column_name_foreign_key_locale _unique(table_name, column_name, foreign_key, locale))

I try the fix this with google and i found this code use

Illuminate\Support\Facades\Schema; public function boot() { Schema::defaultStringLength(191); }

in the app/Providers/AppServiceProvider.php file, but it didn't work, I also upgrade my mysql version, because I had 5.7 mysql now i'm 8, but still i'm having the issue. Hope you guys can help me! thanks for your help!

Select One:
bobbyiliev

October 19, 09:12 PM

Hi there,

What I could suggest trying is to set your default database engine to InnoDB, to do that edit the config/database.php file and under the mysql section change the engine from null to InnoDB:

'mysql' => [
    ...,
    'engine' => 'InnoDB',
 ]

Then clear your cache:

php artisan config:cache

And after that try again.

Let me know how it goes!

Select One:
Write
Preview
Help

Markdown Basics

DevDojo uses Markdown syntax for writing posts, commments, and other content throughout the site. Below you will find some commonly used markdown syntax. For a deeper dive in Markdown check out this Cheat Sheet


Bold & Italic

Italics *asterisks*

Bold **double asterisks**


Code

Inline Code `backtick`

Code Block

```
Three back ticks and then enter your code blocks here.
```

Headers

# This is Heading 1
## This is Heading 2
### This is Heading 3
#### This is Heading 4
##### This is Heading 5

Here is an example of how each heading will looks

Heading 1

Heading 2

Heading 3

Heading 4
Heading 5

Quotes

> type a greater than sign and start typing your quote.

Links

You can add links by typing the alt text inside of [] and the link inside of (), like so:

[links](https://devdojo.com)

Images

You can add images by selecting the image icon, which will upload and add an image to the editor, or you can manually add the image by adding an exclamation !, followed by the alt text inside of [], and the link inside of (), like so:

![alt text for image](https://cdn.devdojo.com/images/image.png)

Embedding Codepens

You can also embed a codepen pen by writing the following:

{% codepen https://codepen.io/your/pen/url %}

You may also choose the default tabs you wish to show your pen by writing the default-tab like so: (default is result)

{% codepen https://codepen.io/your/pen/url default-tab=result,html %}

That's about it. It's time to start crafting your story.

Please login, or signup to write a response.

© 2020 DevDojo LLC. All rights reserved.