Follow

Houston, we are go for liftoff ๐Ÿš€

ยท Web ยท 4 ยท 14 ยท 33

@pixelfed

No stories available atm?

Added "STORIES_ENABLED=true" to .env and ran "php artisan config:cache"

No changes.

@memo @pixelfed

Likewise, I've tried "INSTANCE_STORIES_ENABLED=true" and INSTANCE_STORIES=true" and cleared cache etc.

Not seeing an option to post stories.

@jk @memo 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

@memo You need to run "php artisan cache:clear" and reload php-fpm workers if opcache is enabled.

@pixelfed

It is available now ๐Ÿค—

Better add this to changelog instead of answering questions after updates ๐Ÿ˜†

@pixelfed

Works fine, but the notification widget is gone ๐Ÿ˜ฎ

So there is no chance anymore to see new notifications without looking to every single picture?

@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.

Sign in to participate in the conversation
Mastodon

Server run by the main developers of the project ๐Ÿ˜ It is not focused on any particular niche interest - everyone is welcome as long as you follow our code of conduct!