unlcms / project-herbie

Drupal 10 implementation at the University of Nebraska–Lincoln
https://cms.unl.edu
GNU General Public License v2.0
6 stars 7 forks source link

Can't add specific media hub remote video Gives error. https://mediahub.unl.edu/media/8412 #768

Closed dmerriman2 closed 2 months ago

dmerriman2 commented 3 months ago

The website encountered an unexpected error. Please try again later.

Drupal\Core\Entity\EntityStorageException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'm_rv_html_representation_value' at row 1: INSERT INTO "media__m_rv_html_representation" ("entity_id", "revision_id", "bundle", "delta", "langcode", "m_rv_html_representation_value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 350 [:db_insert_placeholder_1] => 350 [:db_insert_placeholder_2] => remote_video [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 815 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

sarongebre commented 3 months ago

Hi @dmerriman2, thanks for reporting. How are you going about adding the Mediahub remote video? Thanks.

dmerriman2 commented 3 months ago

Media->Add Media->Remote Video, Past URL, Save, Error.

Have also tried within a text area or simple media component.

No other videos have had any issues, just this particular one.

[https://ucomm.unl.edu/images/email-signature/Nebraska_N_RGB_small_on_white.gif] David Merriman Web Developer University of Nebraska–Lincoln College of Education & Human Sciences 4024131531

From: Saron Solomon Gebre @.> Sent: Wednesday, July 17, 2024 7:59 AM To: unlcms/project-herbie @.> Cc: David Merriman @.>; Mention @.> Subject: Re: [unlcms/project-herbie] Can't add specific media hub remote video Gives error. https://mediahub.unl.edu/media/8412 (Issue #768)

Caution: Non-NU Email

Hi @dmerriman2https://urldefense.com/v3/__https:/github.com/dmerriman2__;!!PvXuogZ4sRB2p-tU!AqCK8dmlnUFld7FmgnhcisvFZp9WHtZeITh0PmCtaiSYvzP4N5iYNUiMVCM_iXOZk741v9--QCMeVnA0pg_Q6sIv4Q$, thanks for reporting. How are you going about adding the Mediahub remote video? Thanks.

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/unlcms/project-herbie/issues/768*issuecomment-2233264095__;Iw!!PvXuogZ4sRB2p-tU!AqCK8dmlnUFld7FmgnhcisvFZp9WHtZeITh0PmCtaiSYvzP4N5iYNUiMVCM_iXOZk741v9--QCMeVnA0pg9JkV6Ttg$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AJIRNNHFE2CI5VRDORVJCP3ZMZTCHAVCNFSM6AAAAABK2VA5K6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMZTGI3DIMBZGU__;!!PvXuogZ4sRB2p-tU!AqCK8dmlnUFld7FmgnhcisvFZp9WHtZeITh0PmCtaiSYvzP4N5iYNUiMVCM_iXOZk741v9--QCMeVnA0pg9qjicHkg$. You are receiving this because you were mentioned.Message ID: @.**@.>>

dmerriman2 commented 2 months ago

Same issue with the follow vids... name too long? https://mediahub.unl.edu/media/9819 https://mediahub.unl.edu/media/9820 https://mediahub.unl.edu/media/9821

sarongebre commented 2 months ago

Same issue with the follow vids... name too long? https://mediahub.unl.edu/media/9819 https://mediahub.unl.edu/media/9820 https://mediahub.unl.edu/media/9821

I am not sure. Maybe? Sorry, I haven't gotten a chance to look into this issue yet. I will do that as soon as I finish some tasks I am currently working on.

sarongebre commented 2 months ago

@dmerriman2 This issue should be resolved by pull request #786. I also noticed a problem when adding a remote media hub video and trying to center it with the narrow view mode. That issue should be fixed as well.

This hasn't been pushed to the production servers yet as it hasn’t gone through the deployment process. In the meantime, if you need the remote videos to work urgently, you could reduce the title length to fewer than 100 characters.