I'm getting an error during database migration. I'm on branch "dev" and it ran successfully yesterday. Pixelfed comes up regardless but also discovery doesn't show anything. Timeline seems to be ok:
Migrating: 2019_12_25_042317_update_stories_table
Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the m anual that corresponds to your MariaDB server version for the right syntax to use near 'json null, `expires_at` timestamp not null, `created_at` t imestamp null, `update' at line 1 (SQL: create table `stories` (`id` bigint unsigned not null auto_increment primary key, `profile_id` bigint unsi gned not null, `type` varchar(191) null, `size` int unsigned null, `mime` varchar(191) null, `duration` smallint unsigned not null, `path` varchar (191) null, `cdn_url` varchar(191) null, `public` tinyint(1) not null default '0', `local` tinyint(1) not null default '0', `view_count` int unsig ned null, `comment_count` int unsigned null, `story` json null, `expires_at` timestamp not null, `created_at` timestamp null, `updated_at` timesta mp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')
at /var/www/pixelfed/vendor/laravel/framework/src/Illuminate/Database/Connection.php:669 665| // If an exception occurs when attempting to run a query, we'll format the error 666| // message to include the bindings with SQL, which will make this exception a 667| // lot more helpful to the developer instead of just the database's errors. 668| catch (Exception $e) { > 669| throw new QueryException( 670| $query, $this->prepareBindings($bindings), $e 671| ); 672| } 673|
Exception trace:
1 Doctrine\DBAL\Driver\PDOException::("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, `expires_at` timestamp not null, `created_at` timestamp null, `update' at line 1") /var/www/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63
2 PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that correspo nds to your MariaDB server version for the right syntax to use near 'json null, `expires_at` timestamp not null, `created_at` timestamp null, `upd ate' at line 1") /var/www/pixelfed/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61
pixelfed
Unbekannter Ursprungsbeitrag • •J K 🇯🇵🏴
Unbekannter Ursprungsbeitrag • •Not seeing an option to post stories.
pixelfed
Unbekannter Ursprungsbeitrag • •Martin Winkler
Als Antwort auf pixelfed • •Gregory
Als Antwort auf pixelfed • •