Broken I Logo in v1.1.2 ...solutions?

[shanavas]

Slider and Logo is working fine for me. artisan storage link will work for sliders and app_url in config/app.php set correct url for logo.

Illuminate \ Database \ QueryException (HY000)
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' (SQL: update categories set _lft = case when _lft >= 284 then _lft+2 else _lft end, _rgt = case when _rgt >= 284 then _rgt+2 else _rgt end where (_lft >= 284 or _rgt >= 284)) - issue comes When I add new category . How to fix this , issue ? Quick reply is appreciated

[mikeyapina]

This post is deleted!

[mikeyapina]

This post is deleted!

[Vaishali Agarwal]

@shanavas
you can go through with this solution for this query exception https://github.com/bagisto/bagisto/issues/3448

[mikeyapina]

@Vaishali-Agarwal on yes i cannot see my sliders .. it goes to default. even they upladed.

[Vaishali Agarwal]

@mikeyapina
Create a new slider and then check if the new one is also having the same issue?

[shanavas]

@shanavas

issue solved by

1. ALTER TABLE categories CONVERT TO CHARACTER SET utf8;
2. ALTER TABLE category_translations CONVERT TO CHARACTER SET utf8;

Thanks

[mikeyapina]

@Vaishali-Agarwal ok adding a new slider worked after I altered the tables .. also I noticed that the parameter en is added for locale on all sliders that work

Locale	
en

[Vaishali Agarwal]

@mikeyapina
Yes, that's why I cross checked with you to create a new slider. also anywhere if you got an broken image issue, just try by adding a same image.

Thanks!

[josevillasmil]

it seems that the logo on bagisto admin it's pointing to a https://localhost:8000, indeed a secure https server. In local development the php artisan serve working on http://
Example of my case:

[josevillasmil]

https://localhost:8000/storage/configuration/0Fi6KvcGB03MOD0l1atcyD0cdCxH8cEIZuo7d7rY.png
Pointing to https:// can't find the image