An exception has been thrown during the rendering of a template ("SQLSTATE[HY000]: General error: 1 no such function: FIELD (SQL: select * from "rainlab_blog_posts" where "published" is not null and "published" = 1 and "published_at" is not null and "published_at" < 2019-12-24 13:40:04 and "id" in (1) order by FIELD(id,1))") in "D:\XAMPP\htdocs\clear-theme.ru/themes/ketikidis-clear/pages/blog/blog.htm" at line 29.

It is a fresh local install (2019-12-23, SQLite variant) OctoberCMS and Clear theme and all needed plugins... Yesterday everything worked well and I saw "First blog post". Today I did nothing and wanted to check that everything is ok before backup fresh installed app with fresh installed Clear theme and plugins but I see the error now...

Dymskiy said:

An exception has been thrown during the rendering of a template ("SQLSTATE[HY000]: General error: 1 no such function: FIELD (SQL: select * from "rainlab_blog_posts" where "published" is not null and "published" = 1 and "published_at" is not null and "published_at" < 2019-12-24 13:40:04 and "id" in (1) order by FIELD(id,1))") in "D:\XAMPP\htdocs\clear-theme.ru/themes/ketikidis-clear/pages/blog/blog.htm" at line 29.

It is a fresh local install (2019-12-23, SQLite variant) OctoberCMS and Clear theme and all needed plugins... Yesterday everything worked well and I saw "First blog post". Today I did nothing and wanted to check that everything is ok before backup fresh installed app with fresh installed Clear theme and plugins but I see the error now...

Hello!
I'm sure that error has to do with your local environment (XAMPP). Have you try it on a live server?
Just to help you investigate your local environment issue, try to Change "host" in the /app/config/database.php file from ”localhost" to ”127.0.0.1” to see if that solve your problem.

Charis said:

Dymskiy said:

An exception has been thrown during the rendering of a template ("SQLSTATE[HY000]: General error: 1 no such function: FIELD (SQL: select * from "rainlab_blog_posts" where "published" is not null and "published" = 1 and "published_at" is not null and "published_at" < 2019-12-24 13:40:04 and "id" in (1) order by FIELD(id,1))") in "D:\XAMPP\htdocs\clear-theme.ru/themes/ketikidis-clear/pages/blog/blog.htm" at line 29.

It is a fresh local install (2019-12-23, SQLite variant) OctoberCMS and Clear theme and all needed plugins... Yesterday everything worked well and I saw "First blog post". Today I did nothing and wanted to check that everything is ok before backup fresh installed app with fresh installed Clear theme and plugins but I see the error now...

Hello!
I'm sure that error has to do with your local environment (XAMPP). Have you try it on a live server?
Just to help you investigate your local environment issue, try to Change "host" in the /app/config/database.php file from ”localhost" to ”127.0.0.1” to see if that solve your problem.

Really sure?! Look..

1. I told that it worked well a day before. So it works on XAMPP and I know this.
2. I told that I used SQLite - it works without any 'host'
3. I see same problem on live server http://mikrocafe.ru/blog - October CMS with Clear theme (Gooogle map switched off) and plugins.

Dymskiy said:

Charis said:

Dymskiy said:

An exception has been thrown during the rendering of a template ("SQLSTATE[HY000]: General error: 1 no such function: FIELD (SQL: select * from "rainlab_blog_posts" where "published" is not null and "published" = 1 and "published_at" is not null and "published_at" < 2019-12-24 13:40:04 and "id" in (1) order by FIELD(id,1))") in "D:\XAMPP\htdocs\clear-theme.ru/themes/ketikidis-clear/pages/blog/blog.htm" at line 29.

It is a fresh local install (2019-12-23, SQLite variant) OctoberCMS and Clear theme and all needed plugins... Yesterday everything worked well and I saw "First blog post". Today I did nothing and wanted to check that everything is ok before backup fresh installed app with fresh installed Clear theme and plugins but I see the error now...

Hello!
I'm sure that error has to do with your local environment (XAMPP). Have you try it on a live server?
Just to help you investigate your local environment issue, try to Change "host" in the /app/config/database.php file from ”localhost" to ”127.0.0.1” to see if that solve your problem.

Really sure?! Look..

1. I told that it worked well a day before. So it works on XAMPP and I know this.
2. I told that I used SQLite - it works without any 'host'
3. I see same problem on live server http://mikrocafe.ru/blog - October CMS with Clear theme (Gooogle map switched off) and plugins.

Have you try to see if blog component give you the same error on the octobercms demo theme?

It seems, problem somewhere in "Most Visited Posts" plugin.. Blog page has this in code:

{% if this.theme.blog_sidebar_popular %}{% partial "blog/popular" %}{% endif %}

After this line removing Blog works....

Not tried demo theme yet because there is no Blog page and it is not easy for me this time because I am novice.. I can send admin login.. This site just for practice and you can do enything you need there..

Last updated 4 years ago