ER_BAD_FIELD_ERROR on ghost using latest tag #339
Description
error log
ghostblog | [2022-11-03 15:26:39] ERROR "POST /ghost/api/admin/posts/?formats=mobiledoc%2Clexical" 400 210ms
ghostblog |
ghostblog | Could not understand request.
ghostblog |
ghostblog | Error ID:
ghostblog | e9c55980-5b8b-11ed-bfd4-bfb3f919763b
ghostblog |
ghostblog | Error Code:
ghostblog | ER_BAD_FIELD_ERROR
ghostblog |
ghostblog | ----------------------------------------
ghostblog |
ghostblog | Error: select `posts`.*, (with `k` as (select `member_id` from `members_subscription_created_events` where posts.id = members_subscription_created_events.attribution_id union select `member_id` from `members_created_events` where posts.id = members_created_events.attribution_id) select count(*) from `k`) as `count__conversions`, `posts`.*, (select count(distinct `members_click_events`.`member_id`) from `members_click_events` inner join `redirects` on `members_click_events`.`redirect_id` = `redirects`.`id` where posts.id = redirects.post_id) as `count__clicks`, `posts`.*, (select COALESCE(ROUND(AVG(score) * 100), 0) from `members_feedback` where posts.id = members_feedback.post_id) as `count__sentiment`, `posts`.*, (select count(*) from `members_feedback` where posts.id = members_feedback.post_id AND members_feedback.score = 0) as `count__negative_feedback`, `posts`.*, (select sum(`score`) from `members_feedback` where posts.id = members_feedback.post_id) as `count__positive_feedback` from `posts` where `posts`.`id` = '6363ddafb005a00001de843f' limit 1 - Unknown column 'posts.id' in 'where clause'
Installed on a VPS with ubuntu 22.04 and docker + docker-compose updated to the latest
and using MariaDB latest as DBMS
but after switching to SQL 8.0 the error disappears