Comments (5)
Out of curiosity, which MySQL/MariaDB version are you using?
from lychee.
@jgbellin but you are losing the multi byte version of utf8mb4
which add emojies and cover additional characters: https://stackoverflow.com/a/30074553/3981163
Might be useful for the cn
people...
from lychee.
Here's my STATUS
dump:
MariaDB [(none)]> status;
--------------
mysql Ver 15.1 Distrib 10.1.37-MariaDB, for debian-linux-gnueabihf (armv8l) using readline 5.2
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.1.37-MariaDB-0+deb9u1 Raspbian 9.0
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
from lychee.
try to edit the /config/database.php file :
at line 50,
repace 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci',
with 'charset' => 'utf8', 'collation' => 'utf8_unicode_ci',
it should work (worked for me)
from lychee.
Ok, finally looping back to this. I removed all Laravel directories and tables. Short of rebuilding the server, I was starting from a blank slate. Running php artisan migrate
continues to throw the key error.
In Connection.php line 664:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_username_unique`(`username`))
Following @jgbellin's advice, changing /config/database.php
allowed the migration to proceed without error. I don't know enough PHP to debug this one, though.
from lychee.
Related Issues (20)
- Directories with '[' symbols cannot be imported
- Cannot upload images HOT 3
- Share Button does not get disabled using share_button_visible 1/0
- Image selecting does not work on chrome + MacOS HOT 4
- HTTP Exception 500: "CC-BY" is not a valid backing value for enum App\Enum\LicenseType (View: /var/www/html/Lychee/resources/views/livewire/pages/gallery/album.blade.php) HOT 1
- Missing tools on desktop browser
- Overflow in the details panel HOT 1
- [5.2.0] Maps on image detail is not updated when switching left right.
- #2392 recurring in Lychee 5.2.2 ("CC-BY-SA" is not a valid backing value for enum) HOT 1
- If you can read me, it means that you misconfigured Lychee. HOT 6
- Inverted date on album tiles with multiple months HOT 1
- [5.3.0] Clean installation without error but image is not showing... again HOT 1
- `additional_footer_text` not displayed
- Can not move photos into album containing apostrophe in title
- File-Suffixes duplicated in Downloaded Album HOT 2
- Sharing - Select all users HOT 1
- Could not Upload Photos HOT 2
- Laravel/Eloquent query builder failed when viewing Tag Album contents HOT 1
- Inverted date on album tiles with multiple months HOT 3
- Error in german translation for "GALLERY" HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from lychee.