Comment to 'UNA on VPS problem, I am looking for advice and help'
Comment to UNA on VPS problem, I am looking for advice and help

  • I started manually adding the old content (videos, most from youtube), it was working fine until:

    Database error in Katolička društvena mreža

Query:
INSERT INTO `sys_transcoder_queue` SET `transcoder_object` = ?, `profile_id` = ?, `file_url_source` = ?, `file_id_source` = ?, `status` = ?, `added` = ?, changed = ?

Mysql error:
Duplicate entry 'bx_videos_video_poster_preview-2' for key 'transcoder_object'

collation_connection:
utf8mb4_unicode_ci

    I deleted the contents of the sys_transcoder_queue table, but the page is still blocked, so I deleted the last 50 videos added, and then it worked again. Now I'm afraid when I start adding 1500+ blog posts. At one point I switched php from 7.4 to 8.0 (dont ask why, I dont know 😅) maybe it was a problem during input.

    • If the number of records from the `sys_transcoder_queue` table doesn't reduce then you need to check your Cron Jobs (when it was launched last time - the moment shouldn't be far away from now) and the error log file on the server (perhaps smth breaks the fine running of periodic file).