Empty folders...

[MyRenderer]

Hello,

I installed UMS on a Macbook Air Mac OS Sonoma, (M chip),

I open VLC, it show UMS, it shows the folders i shared, but they are all empty.

I tried rebooting the mac, but folders are all empty. They show up, but all empty, and even with other folders, they are all empty, i try to scan them again, but they are still empty and here is part of the log :

[mik_s]

That part of the logs is no help as it does not in trace mode and only shows the normal startup of UMS.

Please post your full logs. See the section in red above.

[MyRenderer]

That part of the logs is no help as it does not in trace mode and only shows the normal startup of UMS.

Please post your full logs. See the section in red above.

When on the Web browser, i do have my folders (still empty) and when i try to open any of them i gave this error "Your browse data was not received from the server."

I added the logs in this post.

[mik_s]

I can see that there is an error with the database and is not updating.

Code: Select all

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]
net.pms.database.MediaDatabase 
org.h2.jdbc.JdbcSQLSyntaxErrorException: 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]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
	at org.h2.message.DbException.getSyntaxError(DbException.java:261)
	at org.h2.command.Parser.readIdentifier(Parser.java:5527)
	at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:5487)
	at org.h2.command.Parser.parseAlterTableRename(Parser.java:8323)
	at org.h2.command.Parser.parseAlterTable(Parser.java:8034)
	at org.h2.command.Parser.parseAlter(Parser.java:7078)
	at org.h2.command.Parser.parsePrepared(Parser.java:629)
	at org.h2.command.Parser.parse(Parser.java:581)
	at org.h2.command.Parser.parse(Parser.java:556)
	at org.h2.command.Parser.prepareCommand(Parser.java:484)
	at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
	at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
	at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:190)
	at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:147)
	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:119)
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
	at net.pms.database.DatabaseHelper.executeUpdate(DatabaseHelper.java:632)
	at net.pms.database.MediaTableAudiotracks.upgradeTable(MediaTableAudiotracks.java:120)
	at net.pms.database.MediaTableAudiotracks.checkTable(MediaTableAudiotracks.java:94)
	at net.pms.database.MediaDatabase.checkTables(MediaDatabase.java:114)
	at net.pms.database.MediaDatabase.onOpening(MediaDatabase.java:56)
	at net.pms.database.Database.init(Database.java:98)
	at net.pms.database.MediaDatabase.init(MediaDatabase.java:193)
	at net.pms.PMS.init(PMS.java:260)
	at net.pms.PMS.createInstance(PMS.java:1009)
	at net.pms.PMS.main(PMS.java:960)

If the database cannot be accessed then the file list will be empty.

If you close UMS and delete the database a new one will be created when it is next run and this should fix the problem.
I don't know the filesystem on the Mac but the logs say it is located in "/Users/reda/Library/Application Support/UMS/database", just delete or rename the whole folder.

Did you update from a previous version or is this a fresh install?

[MyRenderer]

I can see that there is an error with the database and is not updating.

Code: Select all

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]
net.pms.database.MediaDatabase 
org.h2.jdbc.JdbcSQLSyntaxErrorException: 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]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
	at org.h2.message.DbException.getSyntaxError(DbException.java:261)
	at org.h2.command.Parser.readIdentifier(Parser.java:5527)
	at org.h2.command.Parser.readIdentifierWithSchema(Parser.java:5487)
	at org.h2.command.Parser.parseAlterTableRename(Parser.java:8323)
	at org.h2.command.Parser.parseAlterTable(Parser.java:8034)
	at org.h2.command.Parser.parseAlter(Parser.java:7078)
	at org.h2.command.Parser.parsePrepared(Parser.java:629)
	at org.h2.command.Parser.parse(Parser.java:581)
	at org.h2.command.Parser.parse(Parser.java:556)
	at org.h2.command.Parser.prepareCommand(Parser.java:484)
	at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:645)
	at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:561)
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1164)
	at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:190)
	at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:147)
	at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:119)
	at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
	at net.pms.database.DatabaseHelper.executeUpdate(DatabaseHelper.java:632)
	at net.pms.database.MediaTableAudiotracks.upgradeTable(MediaTableAudiotracks.java:120)
	at net.pms.database.MediaTableAudiotracks.checkTable(MediaTableAudiotracks.java:94)
	at net.pms.database.MediaDatabase.checkTables(MediaDatabase.java:114)
	at net.pms.database.MediaDatabase.onOpening(MediaDatabase.java:56)
	at net.pms.database.Database.init(Database.java:98)
	at net.pms.database.MediaDatabase.init(MediaDatabase.java:193)
	at net.pms.PMS.init(PMS.java:260)
	at net.pms.PMS.createInstance(PMS.java:1009)
	at net.pms.PMS.main(PMS.java:960)

If the database cannot be accessed then the file list will be empty.

If you close UMS and delete the database a new one will be created when it is next run and this should fix the problem.
I don't know the filesystem on the Mac but the logs say it is located in "/Users/reda/Library/Application Support/UMS/database", just delete or rename the whole folder.

Did you update from a previous version or is this a fresh install?

I can't even find the "UMS" folder in "application support" ...

Not a fresh install, i had previous versions a long time ago, and it used to work fine by the way

[MyRenderer]

I tried creating the folder, but it didn't fix the issue.

EDIT : I copied the path to the folder, and it brought me to it, i deleted the database folder as you suggested, launched the UMS app, and it worked !! It scanned the folders, and now they aren't empty anymore.

It's working 100%. Thank you !

Please can you delete the attachment file from the first post ? Thank you.

[mik_s]

OK I have removed the logs.

I think the reason it happened was the database structure changed so much between the versions you used, assuming the previous one was many versions behind, so the database upgrade failed to work properly.

There are supposed to be checks in place now to prevent this but looking at that error message it seems like this one failed to work.

What was the previous version you were using?