Back to Auto SEO Support

p35038
p35038

I can't install this plugin...

I get a sql error on install,

Update failed "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json null, twt_type varchar(255) not null, twt_data json null, created_at ' at line 1 (SQL: create table linkonoid_autoseo_metas (id int unsigned not null auto_increment primary key, theme varchar(255) not null, page varchar(255) not null, title_strategy varchar(255) not null, title varchar(255) null, description_strategy varchar(255) not null, description varchar(255) null, keywords_auto_enable varchar(255) not null, keywords varchar(255) null, redirect_url varchar(255) null, robots_noindex varchar(255) null, robots_nofollow varchar(255) null, canonical_url varchar(255) null, og_type varchar(255) not null, og_data json null, twt_type varchar(255) not null, twt_data json null, created_at timestamp null, updated_at timestamp null) default character set utf8 collate utf8_unicode_ci engine = InnoDB)" on line 664 of /home/pasqptzx/rstlyc-laser.ca/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Linkonoid
Linkonoid

It's global problem, not just my plugin. I open tested environment on my MariaDB server and see this:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'json not null, data json not null, flags json not null, sort_order int not' at line 1 (SQL: create table clake_userextended_fields (id int unsigned not null auto_increment primary key, name varchar(255) not null default '', code varchar(255) not null, description text not null, type enum('UE_FORM_TEXT', 'UE_FORM_CHECKBOX', 'UE_FORM_COLOR', 'UE_FORM_DATE', 'UE_FORM_EMAIL', 'UE_FORM_FILE', 'UE_FORM_NUMBER', 'UE_FORM_PASSWORD', 'UE_FORM_RADIO', 'UE_FORM_RANGE', 'UE_FORM_TEL', 'UE_FORM_TIME', 'UE_FORM_URL', 'UE_FORM_SWITCH') not null default 'UE_FORM_TEXT', validation json not null, data json not null, flags json not null, sort_order int not null default '1', deleted_at timestamp null, created_at timestamp null, updated_at timestamp null) default character set utf8 collate utf8_unicode_ci engine = InnoDB)

Last updated

Linkonoid
Linkonoid

Error on data of type json: $table->json('og_data'); $table->json('twt_data');

Versions MariaDB < 10.2 not supprt Json. Please install MariaDB 10.2 or MySQL (https://mariadb.com/resources/blog/json-with-mariadb-10-2/)

Last updated

1-3 of 3