Can not save open graph

Question

Can not save open graph

nalakawula opened this issue 5 years ago · 5 comments

Here the log:

[2019-10-08 13:12:50] production.ERROR: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'description' at row 1 (SQL: insert into `open_graph_scans` (`title`, `description`, `image`, `url`, `icon`, `website_id`, `updated_at`, `created_at`) values
...

Thank you

Answer 1 · 2019-10-08T07:56:36.000Z

How long is your description?

Answer 2 · 2019-10-08T07:59:19.000Z

371 long.
I check your description column is varchar. So i just need to update into text type right?

Answer 3 · 2019-10-08T08:03:13.000Z

I would checkout -> https://blog.spotibo.com/meta-description-length/

That length is far too long for the description, which is why this is throwing an error.

But yes changing it to text will allow for longer descriptions

Answer 4 · 2019-10-08T08:05:27.000Z

nice best practice advise.
I will close this issue.

Thank you.

Answer 5 · 2019-10-08T08:10:50.000Z

I've added a migration which does cater for longer descriptions so it does not throw an error.

But has given me the idea for maybe a warning on the UI saying description/title is too long!