Talk:MythVideo Auto-level Script

In getvideoautolevel the following SQL can return multiple values (resulting in an error) if you have more than one frontend:

SELECT data FROM settings WHERE value='VideoStartupDir' INTO vid_dir;

The easiest way to get around this one, is to upload and process new movies on the main frontend (probably the one running on the mythtv-backend machine). In that case you need to change the SQL to the following:

SELECT data FROM settings WHERE value='VideoStartupDir' AND hostname='YOUR_MAIN_HOSTNAME' INTO vid_dir;

This opens a lot of potential problems. I would recommend to have the mount points for your videos the same (/srv/videos or whatever) on all frontends. In that case you could be pretty sure that the code will function correctly in all cases.