Immich•4mo ago

Unable to search location after database restore

@bo0tzz recently helped me restore my database to a new CNPG instance but I cannot do a location search. I believe that I'm hitting the problem discussed in this thread: https://discord.com/channels/979116623879368755/1316043914863448147/1316043914863448147. When I list the table I see the same output as the OP.

You are now connected to database "immich" as user "postgres".
immich=# select * from geodata_places;
 id | name | longitude | latitude | countryCode | admin1Code | admin2Code | modificationDate | admin1Name | admin2Name | alternateNames 
----+------+-----------+----------+-------------+------------+------------+------------------+------------+------------+----------------
(0 rows)

You are now connected to database "immich" as user "postgres".
immich=# select * from geodata_places;
 id | name | longitude | latitude | countryCode | admin1Code | admin2Code | modificationDate | admin1Name | admin2Name | alternateNames 
----+------+-----------+----------+-------------+------------+------------+------------------+------------+------------+----------------
(0 rows)

Can someone help me with the command to delete the command to "delete the row from the table" as referenced in the thread? I'm worried about doing something wrong in the database.

9 Replies

Immich•4mo ago

:wave: Hey @Bubba, Thanks for reaching out to us. Please carefully read this message and follow the recommended actions. This will help us be more effective in our support effort and leave more time for building Immich :immich:. References - Container Logs: docker compose logs docs - Container Status: docker ps -a docs - Reverse Proxy: https://immich.app/docs/administration/reverse-proxy - Code Formatting https://support.discord.com/hc/en-us/articles/210298617-Markdown-Text-101-Chat-Formatting-Bold-Italic-Underline#h_01GY0DAKGXDEHE263BCAYEGFJA Checklist I have... 1. :ballot_box_with_check: verified I'm on the latest release(note that mobile app releases may take some time). 2. :ballot_box_with_check: read applicable release notes. 3. :ballot_box_with_check: reviewed the FAQs for known issues. 4. :ballot_box_with_check: reviewed Github for known issues. 5. :ballot_box_with_check: tried accessing Immich via local ip (without a custom reverse proxy). 6. :ballot_box_with_check: uploaded the relevant information (see below). 7. :ballot_box_with_check: tried an incognito window, disabled extensions, cleared mobile app cache, logged out and back in, different browsers, etc. as applicable (an item can be marked as "complete" by reacting with the appropriate number) Information In order to be able to effectively help you, we need you to provide clear information to show what the problem is. The exact details needed vary per case, but here is a list of things to consider: - Your docker-compose.yml and .env files. - Logs from all the containers and their status (see above). - All the troubleshooting steps you've tried so far. - Any recent changes you've made to Immich or your system. - Details about your system (both software/OS and hardware). - Details about your storage (filesystems, type of disks, output of commands like fdisk -l and df -h). - The version of the Immich server, mobile app, and other relevant pieces. - Any other information that you think might be relevant. Please paste files and logs with proper code formatting, and especially avoid blurry screenshots. Without the right information we can't work out what the problem is. Help us help you ;) If this ticket can be closed you can use the /close command, and re-open it later if needed. Successfully submitted, a tag has been added to inform contributors. :white_check_mark:

BubbaOP•4mo ago

The problem that I'm seeing is that when I try to "change location" of a photo and I enter some text into the "search places" text box, the circle spins for less than a second and then does nothing.

bo0tzz•4mo ago

delete * from system_metadata where key = 'reverse-geocoding-state'; should do it iirc

BubbaOP•4mo ago

thx

immich=# delete * from system_metadata where key = 'reverse-geocoding-state';
ERROR:  syntax error at or near "*"
LINE 1: delete * from system_metadata where key = 'reverse-geocoding...

immich=# delete * from system_metadata where key = 'reverse-geocoding-state';
ERROR:  syntax error at or near "*"
LINE 1: delete * from system_metadata where key = 'reverse-geocoding...

bo0tzz•4mo ago

ope sorry drop the *

BubbaOP•4mo ago

immich=# delete from system_metadata where key = 'reverse-geocoding-state';
DELETE 1

immich=# delete from system_metadata where key = 'reverse-geocoding-state';
DELETE 1

looks like it worked; I'll restart my pods lots of log entries like this [Nest] 2 - 01/04/2025, 11:17:39 AM LOG [Microservices:MapRepository] 170000 geodata records imported now search delivers results, but they're kind of funky - which is a secondary problem for example, searching for "manila Philippines" doesn't come up with the right thing

bo0tzz•4mo ago

Just manila works, the searched content doesn't include the country I believe

BubbaOP•4mo ago

yeah, I guess it's not formatted in a "western friendly" format. Anyway, thanks a ton @bo0tzz. I really appreciate your help - always!

Immich•4mo ago

This thread has been closed. To re-open, use the button below.

Gaming

Programming

Unable to search location after database restore

Did you find this page helpful?