Skip to content
New issue

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

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

Already on GitHub? # 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

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

No branches or pull requests

4 participants