Flarum SEO

jordanjay29 There is no errors in weblogs

And in flarum logs at 21.03.2019 I have only this (I change path to ###)

[2019-03-21 14:05:42] production.ERROR: PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '66-50' for key 'PRIMARY' in #####/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '66-50' for key 'PRIMARY' in #####/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119
Next Illuminate\Database\QueryException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '66-50' for key 'PRIMARY' (SQL: insert into `discussion_user` (`discussion_id`, `user_id`, `last_read_post_number`, `last_read_at`) values (50, 66, 3, 2019-03-21 14:05:42)) in #####/public_html/vendor/illuminate/database/Connection.php:664

JasperVriends sorry for my bad English) If I see - discussion have empty tags description, I go to the database, take the text of first post, paste it to the notepad++, and after that I find one space between 75 and 84 symbols and add one more space. After that description generate. If my English very bad, i can do video )

JasperVriends hi, home titles are generally used like this:
Site - Site Slogan
when I use like this, home titles completely adding to of discussion title.
like this: discussion title-site-site-slogan

How can I use without site slogan:
like this: discussion title-site

JasperVriends New problem, If i add any image with embed code and manually post that discussion on twitter, embed image not appear on tweet, just shows site favicon.

Problem is in source code:

<meta name="twitter:image" content="https://site.com/assets/favicon.png">

Why does ignore embedded image within the topic? This code needs to be updated dynamically.
Please fix it for twitter and facebook.

Temporary fix for facebook: Remove codes in PageListener.php
under vendor/v17development/flarum-seo/src/listeners

 if($applicationFavicon !== null)
        {
            $this->setMetaPropertyTag('og:image', $this->applicationUrl . '/assets/' . $applicationFavicon);
            $this->setMetaTag('twitter:image', $this->applicationUrl . '/assets/' . $applicationFavicon);
            $this->setSchemaJson('image', $this->applicationUrl . '/assets/' . $applicationFavicon);
        }[/code)

Fixing issue with Cyrillic descriptions not showing in meta tags.

This is not recommended to directly edit your vendor files. But for quick fix like in my situation this is great solution.
@JasperVriends please consider to reviewing this issue. For lack of time i can't create PR or etc fixing this bug.

This method also works with any other multibyte language.
Notice: php mb_string extension must be turned on

Open /vendor/v17development/flarum-seo/src/Listeners/PageListener.php

Find setDescription() function

Change
$description = trim(preg_replace('/\s+/', ' ', substr($description, 0, 157))) . (strlen($description) > 157 ? '...' : '');

To
$description = trim(preg_replace('/\s+/', ' ', mb_substr($description, 0, 157))) . (mb_strlen($description) > 157 ? '...' : '');

I don't even noticed that descriptions doesn't showing on my website. So Google and Yandex bots index entire site without descriptions.

ReaZzon Tnx bro!!! It works perfect!!! I have my site on russian language and Yandex bot doesn't want to set the description for main page in Yandex Search, it always shows "somethings went wrong (in russian)" but another pages is ok. Can you help me?)))