0

I'm seeding a [skills] table but I'm getting an error in the console and it's so vague. If you check, nothing useful really. Just an exception.

enter image description here

The data that I'm trying to seed are string and images so naturally, the column that accepts the image is a BLOB.

MySQL Workbench:

enter image description here

Strangely, as you can see some seed data went through (HTML & CSS). These image files are stored in storage /storage/app/images/skills/MY_IMAGE_FILE.png.

I made sure that it isn't a typo in the PATH so something must be wrong with the file but this javascript /storage/app/images/skills/javascript_logo.jpg, the 3rd on the array is where the seeding throws an exception.

This is the array that I'm trying to seed. As you can see, the 3rd item on the array fails.

SkillsSeeder.php*

enter image description here

To test if the 3rd file is corrupt. I tried running the file directly in my view file.

<img src="data:image/png;base64, {{ base64_encode(file_get_contents(storage_path('app/images/skills/javascript_logo.jpg'))) }}" />

but it displays properly on the browser. So it must the format. I tried to change it to .png. Still getting Seeding error but if displayed directly on view, it works.

At this point, I am sure that:

  1. The image file is ok.
  2. The path to storage is ok.
  3. File format is NOT the issue.

My guesses:

  1. Something wrong with the seeder but how come, I had another table with the same columns (varchar & BLOB) in terms of data type and seeder class that uses the exact same methods but that doesn't fail. That and this seeder is almost identical.

Sorry for packing tons of images but this last image is just the Seeder.

SkillsSeeder.phpenter image description here

I'm really confused as to why the 3rd seed fails. Just the 3rd.

Shu Pesmerga
  • 155
  • 1
  • 1
  • 15
  • I tried hardcoding the 8 different image paths for all entries. 2 out of 8 causes errors. compared properties of error causing images are have significant size (66kB and 80kB vs 44kB[no errors]) at this point. It's definitely the size. I could increase the column from BLOB to MEDIUMBLOB or reduce the file size below 65kB – Shu Pesmerga Apr 04 '20 at 00:07

1 Answers1

0

BLOB size limit is 65kB only MEDIUMBLOB should be used. Now, Laravel Schema builder does not support MEDIUMBLOB. You check this how to add MEDIUMBLOB

https://www.256kilobytes.com/content/show/500/laravel-how-to-create-a-database-field-of-the-types-mediumblob-longblob-and-other-data-types-not-explicitly-supported-by-the-schema-facade

Shu Pesmerga
  • 155
  • 1
  • 1
  • 15