Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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

Error running migrations #84

Open
bobonov opened this issue May 17, 2018 · 2 comments
Open

Error running migrations #84

bobonov opened this issue May 17, 2018 · 2 comments
Labels

Comments

@bobonov
Copy link

bobonov commented May 17, 2018

*** applying m160501_124615_create_table_eav_attribute_rules
> create table {{%eav_attribute_rules}} ...Exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1101 BLOB, TEXT, GEOMETRY or JSON column 'rules' can't have a default value
The SQL being executed was: CREATE TABLE eav_attribute_rules (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
attributeId int(11) DEFAULT 0,
rules text DEFAULT ''
) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB'

I'm using mysql 5.7.22

@serjlaw
Copy link

serjlaw commented May 18, 2018

Go to mysql.
Input:
SET @@global.sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

@Mirocow Mirocow added the bug label Mar 10, 2019
@mazurva
Copy link

mazurva commented Dec 24, 2021

#96

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants