After adding the Rainlab.Blog plugin (from the command line), database tables seem to have been created successfully and the Blog section shows up in the backend menu. However, when I visit the /backend/rainlab/blog/posts page, I get a SQL syntax error:

SQLSTATE[HY000]: General error: 1 near "separator": syntax error (SQL: select "rainlab_blog_posts".*, (select group_concat(name separator ', ') from "rainlab_blog_categories" inner join "rainlab_blog_posts_categories" on "rainlab_blog_categories"."id" = "rainlab_blog_posts_categories"."category_id" where "rainlab_blog_posts_categories"."post_id" = "rainlab_blog_posts"."id") as "categories" from "rainlab_blog_posts" order by "published_at" desc limit 25 offset 0)

While troubleshooting, I noticed I'm getting a similar syntax error at /backend/backend/users.

This is on a local development machine running with PHP -S and sqlite. However, I can replicate the syntax error on Heroku using postegres (although it's slightly different since it is thrown by the postgres adapter, it's still complaining about "separator".

If I had to guess, I'd say it's coming from line 375 of /modules/backend/widgets/Lists.php:

$joinSql = $this->isColumnRelated($column, true) ? DbDongle::raw("group_concat(" . $sqlSelect . " separator ', ')") : DbDongle::raw($sqlSelect);

But I'm not yet comfortable enough in PHP (and SQL) to know for sure.

Any insight is appreciated.

Last updated 9 years ago