TMSupport wrote:
>
>
> Please provide logs so we can analyze the reason.
> 1. Login to the SSH terminal.
> 2. Execute the command below.
> [code]cat /var/log/media.log[/code]
> [code]cat /var/log/mediadb/mediadb.log [/code]
Thanks! For the first command here is the log
[2022/06/30 00:44:20] minidlna.c:414: error: check_pg_db:new_db=0
[2022/06/30 00:44:20] minidlna.c:468: warn: New media_dir detected; rebuilding...
[2022/06/30 00:44:20] minidlna.c:481: warn: DROP the tables............
[2022/06/30 00:45:06] scanner.c:881: warn: Unsuccessful getting details for /home/Marco/Android/Tab S2/Backup/Pictures/Telegram/IMG_20190528_225201_877.jpg
[2022/06/30 00:45:49] sql.c:46: error: PGSQL ERROR 7 [ERROR: syntax error at or near "s"
LINE 1: ...', 4277, 'container.storageFolder', 'Valori e Ism's') ON CON...
^
]
[2022/06/30 00:45:49] sql.c:47: error: sql=INSERT into OBJECTS (OBJECT_ID, PARENT_ID, REF_ID, DETAIL_ID, CLASS, NAME) VALUES ('3$16$0$10$0$C$6$15', '3$16$0$10$0$C$6', '64$0$10$0$C$6$15', 4277, 'container.storageFolder', 'Valori e Ism's') ON CONFLICT DO NOTHING
[2022/06/30 11:55:28] minidlna.c:414: error: check_pg_db:new_db=0
[2022/06/30 11:55:28] minidlna.c:468: warn: New media_dir detected; rebuilding...
[2022/06/30 11:55:28] minidlna.c:481: warn: DROP the tables............
[2022/06/30 11:56:29] sql.c:141: error: pg_sql_get_int64_field: ERROR 7 [FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
]
[2022/06/30 11:56:29] sql.c:142: error: sql=INSERT into DETAILS (NAME, PATH, SIZE, TIMESTAMP, DURATION, DATE, CHANNELS, BITRATE, SAMPLERATE, RESOLUTION, TITLE, CREATOR, ARTIST, GENRE, COMMENT, DLNA_PN, MIME, ALBUM_ART, DISC, TRACK, ALBUM) VALUES ('20210321_120451.mp4', '/Volume1/Foto/Camera/20210321_120451.mp4', 54531191, 1620853537, '0:00:30.206', '2021-05-12T23:05:37', 2, 1805309, 48000, '1920x1080', '20210321_120451.mp4', '(null)', '(null)', '(null)', '(null)', 'AVC_MP4_HP_HD_AAC', 'video/mp4', 0, 0, 0, '-map 0:0 -map 0:1') ON CONFLICT DO NOTHING RETURNING ID;
[2022/06/30 11:56:29] metadata.c:2281: error: Error inserting details for '/Volume1/Foto/Camera/20210321_120451.mp4'!
[2022/06/30 11:56:29] scanner.c:881: warn: Unsuccessful getting details for /Volume1/Foto/Camera/20210321_120451.mp4
[2022/06/30 11:56:35] minidlna.c:414: error: check_pg_db:new_db=0
[2022/06/30 11:56:35] minidlna.c:468: warn: New media_dir detected; rebuilding...
[2022/06/30 11:56:35] minidlna.c:481: warn: DROP the tables............
[2022/06/30 11:56:36] scanner.c:1296: warn: Scanning /Volume1/Multimedia
[2022/06/30 11:56:37] sql.c:46: error: PGSQL ERROR 7 [ERROR: syntax error at or near "Uomo"
LINE 1: ...', 45, 'container.storageFolder', 'Hanno Ucciso L'Uomo Ragno...
^
]
[2022/06/30 11:56:37] sql.c:47: error: sql=INSERT into OBJECTS (OBJECT_ID, PARENT_ID, REF_ID, DETAIL_ID, CLASS, NAME) VALUES ('3$16$7$0$3', '3$16$7$0', '64$7$0$3', 45, 'container.storageFolder', 'Hanno Ucciso L'Uomo Ragno') ON CONFLICT DO NOTHING
[2022/06/30 11:57:38] sql.c:104: error: pg_sql_get_int_field: ERROR 7 [ERROR: syntax error at or near "'(select null from DETAILS where MIME like '"
LINE 1: SELECT count(*) from '(select null from DETAILS where MIME l...
^
]
[2022/06/30 11:57:38] sql.c:105: error: sql=SELECT count(*) from '(select null from DETAILS where MIME like 'a%' and timestamp > (extract(epoch from now()) - 7776000) limit 50) as audio'
For the second command i receive this
-bash: o@TNAS-220: command not found