Page 1 of 1

no file found

Posted: Mon Nov 24, 2025 8:01 am
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 ?

Re: no file found

Posted: Mon Nov 24, 2025 9:36 am
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.

Re: no file found

Posted: Mon Nov 24, 2025 11:44 am
by meuhporg
seems to work.
i first installed a previous version yes, and then upgraded