fabulog
fabulog copied to clipboard
ikkez
postgres
From your demo , when changing to postgres DB and then going 'home' it throws a query issue, missing group thingy. I will dl the blog and play with it, and might find a fix if you don't etc. but just thought I'd mention:
Internal Server Error PDOStatement: ERROR: subquery uses ungrouped column "fblg_posts.id" from outer query LINE 1: ...ved" = $1 ) and ( "fblg_comments__count"."post" = "fblg_post... ^ [fabulog/vendor/bcosca/fatfree-core/base.php:2261] Base->error() [fabulog/vendor/bcosca/fatfree-core/db/sql.php:235] user_error() [fabulog/vendor/bcosca/fatfree-core/db/sql/mapper.php:376] DB\SQL->exec() [fabulog/vendor/ikkez/f3-cortex/lib/db/cortex.php:892] DB\SQL\Mapper->count() [fabulog/vendor/ikkez/f3-cortex/lib/db/cortex.php:1311] DB\Cortex->filteredFind() [fabulog/vendor/bcosca/fatfree-core/db/cursor.php:150] DB\Cortex->count() [fabulog/app/controller/post.php:53] DB\Cursor->paginate() [fabulog/vendor/bcosca/fatfree-core/base.php:1873] Controller\Post->getList() [fabulog/vendor/bcosca/fatfree-core/base.php:1673] Base->call() [fabulog/index.php:71] Base->run() (1.3ms) SELECT "id","username","name","password","mail" FROM "fblg_user" WHERE "id" = 1 (16.8ms) SELECT C.COLUMN_NAME AS field,C.DATA_TYPE AS type,C.COLUMN_DEFAULT AS defval,C.IS_NULLABLE AS nullable,T.CONSTRAINT_TYPE AS pkey FROM INFORMATION_SCHEMA.COLUMNS AS C LEFT OUTER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.TABLE_NAME=K.TABLE_NAME AND C.COLUMN_NAME=K.COLUMN_NAME AND C.TABLE_SCHEMA=K.TABLE_SCHEMA AND C.TABLE_CATALOG=K.TABLE_CATALOG LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS T ON K.TABLE_NAME=T.TABLE_NAME AND K.CONSTRAINT_NAME=T.CONSTRAINT_NAME AND K.TABLE_SCHEMA=T.TABLE_SCHEMA AND K.TABLE_CATALOG=T.TABLE_CATALOG WHERE C.TABLE_NAME='fblg_tags' AND C.TABLE_CATALOG='fatfree' (1.7ms) SELECT "id","title","slug",((select count("fblg_posts__tags_mm_fblg_tags__post"."tags") from "fblg_posts__tags_mm_fblg_tags__post" LEFT JOIN "fblg_posts" ON "fblg_posts__tags_mm_fblg_tags__post"."post" = "fblg_posts"."id" where ("fblg_posts__tags_mm_fblg_tags__post"."tags" = "fblg_tags"."id") AND ("fblg_posts"."published" = true and "fblg_posts"."publish_date" <= '2022-08-19') group by "fblg_posts__tags_mm_fblg_tags__post"."tags")) AS "count_post" FROM "fblg_tags" WHERE 1=1 ORDER BY "count_post" DESC NULLS LAST (0.6ms) SELECT ((select count("fblg_comments__count"."id") from "fblg_comments" AS "fblg_comments__count" where ( "fblg_comments__count"."approved" = 1 ) and ( "fblg_comments__count"."post" = "fblg_posts"."id" ) group by "fblg_comments__count"."post")) AS "count_comments",COUNT(*) AS "_rows" FROM "fblg_posts" WHERE "publish_date" <= '2022-08-19' and "published" = true
It probably just needs some updates in the composer.json to the most recent version of f3-core.
