no file found

For help and support with Universal Media Server
Forum rules
Please make sure you follow the Problem Reporting Guidelines before posting if you want a reply
Post Reply
meuhporg
Posts: 8
Joined: Mon Nov 24, 2025 7:34 am

no file found

Post by meuhporg »

Hello.
I changed computer and installed latest version on the new one.
But it does not seem to get any file to share ("no file" on my PS4)

can you help me ?
Attachments
ums_dbg_2025-11-23-20-27.zip
(80.24 KiB) Downloaded 1819 times
User avatar
mik_s
Moderator
Posts: 1766
Joined: Wed Aug 23, 2017 11:03 pm
Location: UK

Re: no file found

Post by mik_s »

There is a database error where it failed to update

Code: Select all

TRACE 2025-11-23 20:25:51.928 [main] net.pms.database.DatabaseHelper Execute Update with SQL "ALTER TABLE AUDIOTRACKS RENAME CONSTRAINT IF EXISTS PKAUDIO TO AUDIOTRACKS_PK"
ERROR 2025-11-23 20:25:51.931 [main] net.pms.database.MediaDatabase Error checking tables: Erreur de syntaxe dans l'instruction SQL "ALTER TABLE AUDIOTRACKS RENAME CONSTRAINT [*]IF EXISTS PKAUDIO TO AUDIOTRACKS_PK"; attendu "identifier"
Syntax error in SQL statement "ALTER TABLE AUDIOTRACKS RENAME CONSTRAINT [*]IF EXISTS PKAUDIO TO AUDIOTRACKS_PK"; expected "identifier"; SQL statement:
ALTER TABLE AUDIOTRACKS RENAME CONSTRAINT IF EXISTS PKAUDIO TO AUDIOTRACKS_PK [42001-232]
Deleting C:\ProgramData\UMS\database when UMS is not running will fix this and a new one will be created next time it is started.

I don't know why this error happened if this was on a new computer unless it had a previous version of UMS installed before.
If it had it might be better to reinstall UMS and use the "clean install" option to overwrite all parts of the old one. This option is in the advanced section in the installer.
Logs are important for us to help, Please follow This Link before asking for support. Just a forum cleaner, Will help if I can but no expert.
meuhporg
Posts: 8
Joined: Mon Nov 24, 2025 7:34 am

Re: no file found

Post by meuhporg »

seems to work.
i first installed a previous version yes, and then upgraded
Post Reply