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