Is there somewhere a newer version of the geo database? It looks like it lacks many cities in my country. Is there some tool that allow convenient adding new entries to the geo database? I mean what is this pk_i_id and fk_i_region_id numbers? Where can I get them?

Those are IDs generated by database.
Which country miss cities?

Those are IDs generated by database.
Which country miss cities?

Poland.

We use these as partial source.
You can check it out and provide details about administrative codes those you miss

We use these as partial source.
You can check it out and provide details about administrative codes those you miss

So what should I do?

I've found this:
https://download.geonames.org/export/dump/

The PL (Poland) database holds almost 60K records and all the missing cities are in the database.

Give 2-3 lines those are missing and what are administrative codes.

If I understood you well, for instance this one is missing:

774911 Budy Michałowskie Budy Michalowskie 52.05513 20.52924 P PPL PL 78 1405 140505 0 119 Europe/Warsaw 2019-01-17

But many cities are missing. For instance, the Osclass's database for Poland has only the following number of places:

# cat PL-Poland.sql | wc -l
4713
The database I link in my previous post has almost 60K, so obviously 55K entries are missing.

Details are here:
http://www.geonames.org/export/codes.html

All is good except population.
We only include places with population >= 10

That's weird, because Budy Michałowskie has more than 10 people According to wikipedia it had 248 in 2021.

Last update what I see in these data was 2011, maybe at that time it was not available.
Let me check if min-population can be complemented with some different data.

Is there a way to generate this database manually and import it into Osclass?

@morfik
No.
Anyway we've updated and redesigned code. You can now try Poland.
In general we now include all cities for smaller country (file size under 10MB) and for big countries only cities with population > 10.

As example for Poland, SQL size went from 346.6KB into 2928.7KB so it has 10x more data.

In general number of cities increased from 379,072 cities into 2,462,328 cities in total worldwide.

Are there any advanced instructions on how to import this, or can it be imported in the regular way?

@morfik
Just remove your country and import it again in your backoffice.

I have a question. I noticed that the pk_i_id is different in t_region and pk_i_id and fk_i_region_id in t_city are also different compared to the previous version of the database. Won't this cause any issues with the already published listings?