I am developing in the latest PhpStorm IDE, using Kirby 3.5.1, PHP 7.4, and an SQLite database.
I wish to employ some virtual pages generated out of database content, together with the usual Kirby text based pages. I am not sure how to do this right, so I tried to use the content from database example from the Kirby Guide. I believe I set up everything as in the mentioned Guide article (basic version, not the extended one). On request, I can provide the contents of every component of my setup.
But it doesn’t work. In the panel, I see the comments virtual page as an unlisted page:
Clicking on that entry yields the following error message:
The definition of my table comments is as follows:
create table comments
(
id int not null
constraint comments_pk
primary key,
text varchar(600),
user varchar(100),
slug varchar(185)
);
create unique index comments_id_uindex
on comments (id);
create unique index comments_slug_uindex
on comments (slug);
I believe this is exactly what the documentation specified. I suppose there is something else going wrong, but I have no clue what.