Error on migration

[iainhamilton]

Hi, I followed the process in the install section but am getting the error at the end of the below.

I hope it helps that I copide the full install process.

cucmauqpjd:public_html$ composer require spatie/laravel-server-monitor
Using version ^1.3 for spatie/laravel-server-monitor
./composer.json has been updated
Loading composer repositories with package information
Updating dependencies (including require-dev)
Package operations: 4 installs, 0 updates, 0 removals

• Installing spatie/regex (1.3.0): Downloading (100%)
• Installing spatie/blink (1.0.1): Downloading (100%)
• Installing spatie/laravel-blink (1.1.1): Downloading (100%)
• Installing spatie/laravel-server-monitor (1.3.2): Downloading (100%)
  Writing lock file
  Generating optimized autoload files

Illuminate\Foundation\ComposerScripts::postAutoloadDump
@php artisan package:discover
Discovered Package: arrilot/laravel-widgets
Discovered Package: botman/botman
Discovered Package: botman/driver-web
Discovered Package: botman/studio-addons
Discovered Package: fideloper/proxy
Discovered Package: intervention/image
Discovered Package: larapack/voyager-hooks
Discovered Package: laravel/tinker
Discovered Package: laravelcollective/html
Discovered Package: spatie/laravel-blink
Discovered Package: spatie/laravel-server-monitor
Discovered Package: tcg/voyager
Package manifest generated successfully.
cucmauqpjd:public_html$ php artisan vendor:publish --provider="Spatie\ServerMonitor\ServerMonitorServiceProvider" --tag="migrations"
Copied File [/vendor/spatie/laravel-server-monitor/database/migrations/create_hosts_table.php.stub] To [/database/migrations/2018_06_01_1320441_create_hosts_table.php]
Copied File [/vendor/spatie/laravel-server-monitor/database/migrations/create_checks_table.php.stub] To [/database/migrations/2018_06_01_1320442_create_checks_table.php]
Publishing complete.
cucmauqpjd:public_html$ php artisan migrate

In Connection.php line 664:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u
se near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1 (SQL: create table hosts (id int unsigned not null auto_increment primary key
, name varchar(255) not null, ssh_user varchar(255) null, port int null, ip varchar(255) null, custom_properties json null, created_at timestamp null, updated_at timest
amp null) default character set utf8 collate utf8_unicode_ci)

In PDOConnection.php line 82:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u
se near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1

In PDOConnection.php line 80:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to u
se near 'json null, created_at timestamp null, updated_at timestamp null) default cha' at line 1

[sebastiandedeyne]

I think you might be using a database that doesn't support JSON columns. What MySQL version are you using?

[spatie-bot]

Dear contributor,

because this issue seems to be inactive for quite some time now, I've automatically closed it. If you feel this issue deserves some attention from my human colleagues feel free to reopen it.

[herryswastika]

change json to text for MariaDb