transcode_id INT NOT NULL PRIMARY KEY AUTO_INCREMENT in the file TimedMediaHandler.sql is not standard SQL. I use postgres and had to change it to transcode_id SERIAL PRIMARY KEY.
Further, transcode_error longtext NOT NULL must be changed to transcode_error TEXT NOT NULL for postgres.
It would be nice if this extension could be made to also support postgres, as this only needs the above changes. Thanks.