Topic: Auto Tweet Embed

[Arantor]

@vbgamer45: if someone ever does a UTF-8 conversion in SMF, it'll force convert it to non-mb4, in spite of what the database says. Things are better in 2.1.

[vbgamer45]

Bah, didn't know that.

[natcip]

I had it setup on the field level on the install

Code: [Select]

ALTER TABLE {db_prefix}tweet_cache CHANGE html html text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci


Code: [Select]

Incorrect string value: '\xF0\x9F\x92\x80 <...' for column `brandyso_sql1`.`brandy4f_sql1_smf_tweet_cache`.`html` at row 1
File: /home/www/brandyso/tweet-cache.php
Line: 93

Try the attached file and see if it helps
Copy to root of your SMF install and make sure right permissions are set.

Thank you for this. Unfortunately no change. File is set to 644.

[vbgamer45]

Can you rerun this query on your database

Code: [Select]

ALTER TABLE smf_tweet_cache CHANGE html html text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci


[natcip]

Just did it
tweet-cache.php now shows this

Code: [Select]

{"html":"

Tweet error (blank ID)
"}But the tweets still don't embed

[chrishicks]

Is there a way to have the embeds use a dark theme instead of the white? Like this:

https://i.imgur.com/DnigklQ.png

It's not a huge deal I was just curious since my theme is entirely dark colored.

[vbgamer45]

Maybe might have to tweak the embed code.

[natcip]

Hi there,
I just tried posting a tweet link and instead of showing an embedded tweet, the post literally looks like this:

Code: [Select]

<blockquote class="twitter-tweet"><p lang="en" dir="ltr">I digress .</p>&mdash; SZA (@sza) <a href="https://twitter.com/sza/status/1398527644115738624?ref_src=twsrc%5Etfw">May 29, 2021</a></blockquote><script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>https://twitter.com/sza/status/1398527644115738624

[vbgamer45]

What mods to have insalled?

that is the right code except it is showing the html instead of running it.

[natcip]

What mods to have insalled?

Simple Audio Video Embedder
Yet Another YouTube BBCode Tag
Yet Another Spoiler Mod
Soundcloud BBcode
NiceTooltips

Also, I just checked my test post from yesterday. Now it simply shows the tweet link, not the html code.