Twitter Module no Images

[Tigersign]

CMS Version

3.0.6 via Docker on Windows

Player Type

Windows

Player Version

3 R301.1

Issue

Images not appearing. Neither profile no content photos.
Not showing in CMS preview or on player.

In the logs I seem to be getting “General error: 1366 Incorrect integer value: ‘’ for column ‘fileSize’ at row 1”,ERROR"

When the CMS tries to fetch the images.
See log sample below.
Any idea how to fix?
Thanks!

16556,5f56699,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/115/236,GET,“Process queue of 1 display notifications”,DEBUG
16557,5f56699,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/115/236,GET,“Process queue of 1 display actions”,DEBUG
16558,5f56699,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/115/236,GET,“Player Action Service is looking to send 1 actions”,DEBUG
16559,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“saveFile for "twitter_234137899" [478] with storedAs = "twitter_234137899", fileName = "http://pbs.twimg.com/profile_images/1413643432732528642/w-JJtO0t_bigger.jpg" to "478.jpg". Always Copy = "", Cloned = ""”,DEBUG
16560,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Moving temporary file: /var/www/cms/library/temp/twitter_234137899”,DEBUG
16561,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Unable to save:478. SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘fileSize’ at row 1”,ERROR
16562,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“saveFile for "twitter_242061800" [480] with storedAs = "twitter_242061800", fileName = "http://pbs.twimg.com/profile_images/1400572358252011533/s00e0Xt0_bigger.jpg" to "480.jpg". Always Copy = "", Cloned = ""”,DEBUG
16563,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Moving temporary file: /var/www/cms/library/temp/twitter_242061800”,DEBUG
16564,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Unable to save:480. SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘fileSize’ at row 1”,ERROR
16565,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“saveFile for "twitter_2431204724" [476] with storedAs = "twitter_2431204724", fileName = "http://pbs.twimg.com/profile_images/1364447894783229960/yxInefMw_bigger.jpg" to "476.jpg". Always Copy = "", Cloned = ""”,DEBUG
16566,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Moving temporary file: /var/www/cms/library/temp/twitter_2431204724”,DEBUG
16567,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“Unable to save:476. SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ‘’ for column ‘fileSize’ at row 1”,ERROR
16568,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“Loading 1. All Objects = 0”,DEBUG
16569,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“Install Fonts called with options: {"invalidateCache":false}”,DEBUG
16570,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“CMS font CSS returned from Cache.”,DEBUG
16571,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“Install Fonts called with options: {"invalidateCache":false}”,DEBUG
16572,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“CMS font CSS returned from Cache.”,DEBUG
16573,e9183c7,“2022-01-31 15:37:45”,WEB,/playlist/widget/resource/112/233,GET,“saveFile for "twitter_photo_234137899" [479] with storedAs = "twitter_photo_234137899", fileName = "http://pbs.twimg.com/media/FKcFkCrX0AEjm-J.jpg" to "479.jpg". Always Copy = "", Cloned = ""”,DEBUG
16574,3cb82e9,“2022-01-31 15:37:45”,WEB,/library/fontcss,GET,“Request stats: {
"default": {
"select": 6
},
"log": {
"insert": 5
},
"length": 0.09920310974121094,
"memoryUsage": 18306512,
"peakMemoryUsage": 18477344
}.”,INFO

[Tigersign]

Well, I half fixed my problem, but now there are others!
I did a little research on the forum and added this line to the docker-compose.yml:

command: mysqld --sql_mode=“ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

That finally got BOTH the profile and photo image showing up in the Twitter module on the CMS preview and the player. GREAT! (Seems like that should be included in the template, but moving on…)

However, only the profile image changes with the tweet text. The photo is stuck from the first tweet and will not change.

Second, this seems to be causing the player to crash after a few minutes.
(It seems to relaunch and run okay, but the Twitter photo still won’t change.)

Any idea where to go from here? Thanks

[Tigersign]

I should clarify, when using a regular search term it will show tweets from different users with different photos.
When using from:username to display the tweets from a specific user, it will change the text of the tweet, but it sticks on the first photo and will not update the photos as the tweets change.