Zum Inhalt der Seite gehen

Unbekannter Ursprungsbeitrag

pixelfed
It's "STORIES_ENABLED=true" and run "php artisan config:cache && php artisan cache:clear". It may log you out depending on your SESSION_DRIVER
Unbekannter Ursprungsbeitrag

J K 🇯🇵🏴󠁧󠁢󠁳󠁣󠁴󠁿
Likewise, I've tried "INSTANCE_STORIES_ENABLED=true" and INSTANCE_STORIES=true" and cleared cache etc.

Not seeing an option to post stories.
Unbekannter Ursprungsbeitrag

pixelfed
You need to run "php artisan cache:clear" and reload php-fpm workers if opcache is enabled.
Als Antwort auf pixelfed

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

Please use the argument -v to see more details.