[PR #757] [MERGED] Fix AWS S3 related issues. #1336

Closed
opened 2026-02-26 03:30:38 +03:00 by kerem · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/koel/koel/pull/757
Author: @nob
Created: 6/15/2018
Status: Merged
Merged: 6/16/2018
Merged by: @phanan

Base: masterHead: aws_fix


📝 Commits (2)

  • e4f76f4 Avoid an error from MySQL, "Column cannot be null".
  • d784028 Clears the media cache after storing a new song.

📊 Changes

1 file changed (+3 additions, -2 deletions)

View changed files

📝 app/Http/Controllers/API/ObjectStorage/S3/SongController.php (+3 -2)

📄 Description

I had 2 troubles when running Koel with the official Koel-AWS package

  1. MySQL Error: "Integrity constraint violation - Column 'lyrics' cannot be null" when AWS Lambda function request to Koel's Song API. (Environment: MySQL v5.5.47 & PHP v7.1)
    error log
    Similar to this issue.

  2. After storing a new songs, the song, album and artist didn't show up in Koel UI, because media cache remains.


🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/koel/koel/pull/757 **Author:** [@nob](https://github.com/nob) **Created:** 6/15/2018 **Status:** ✅ Merged **Merged:** 6/16/2018 **Merged by:** [@phanan](https://github.com/phanan) **Base:** `master` ← **Head:** `aws_fix` --- ### 📝 Commits (2) - [`e4f76f4`](https://github.com/koel/koel/commit/e4f76f4bc3072a2f75d42005e00fd4db3a47f734) Avoid an error from MySQL, "Column cannot be null". - [`d784028`](https://github.com/koel/koel/commit/d7840285e6d60456abbc42b1d17c6b9d297962c7) Clears the media cache after storing a new song. ### 📊 Changes **1 file changed** (+3 additions, -2 deletions) <details> <summary>View changed files</summary> 📝 `app/Http/Controllers/API/ObjectStorage/S3/SongController.php` (+3 -2) </details> ### 📄 Description I had 2 troubles when running Koel with [the official Koel-AWS package](https://github.com/koel/koel-aws) 1. MySQL Error: "Integrity constraint violation - Column 'lyrics' cannot be null" when AWS Lambda function request to Koel's Song API. (Environment: MySQL v5.5.47 & PHP v7.1) ![error log](https://d.pr/i/l7p6vZ+) Similar to [this issue](https://stackoverflow.com/questions/43860634/laravel-5-4-upgrade-integrity-constraint-violation-column-cannot-be-null). 2. After storing a new songs, the song, album and artist didn't show up in Koel UI, because media cache remains. --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
kerem 2026-02-26 03:30:38 +03:00
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/koel-koel#1336
No description provided.