vccw-team / vccw

A Vagrant based development environment.
http://vccw.cc/
MIT License
1.02k stars 181 forks source link

Unknown collation: 'utf8mb4_unicode_520_ci' (Wordmove::ShellCommandError) #229

Closed mrky007 closed 7 years ago

mrky007 commented 7 years ago

Operating System: Ubuntu 16.04. Vagrant Version: Vagrant 1.9.1 Virtual Box Version: 5.1.14 r112924 (Qt5.5.1)

I've setup my development environment and everything works great, but when I try to push all to production server I always get: Unknown collation: 'utf8mb4_unicode_520_ci' (Wordmove::ShellCommandError) for Database Pushig.

I've read somwhere that this might be a problem with mysql version, development server uses: 5.7.16 and live server has 5.5.54 installed.

Has anyone encountered / fixed this issue?

mrky007 commented 7 years ago

In case anyone else out there has this problem, the solution by @pioneerskies can be found here

miya0001 commented 7 years ago

Oh, this solution looks nice. 👍