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.