Skip to content

Commonly Encountered Errors

TV Show search results disappear

This is due to our TV Provider TVMaze not having the metadata we need to process that TV Show. We require TV Maze to supply us with a TVDBId for that show. You can easily check this by calling the TV Maze API: http://api.tvmaze.com/search/shows?q=Dexter

You can see under the externals object there should be a theTvDb property. If that is null then Ombi cannot process that show.

You can request the theTvDb id to be added here


If you search for a TV show and get this error:

sorry

This is most commonly caused by incorrect spelling. 😃

This could also be caused by there not being enough metadata available such as thetvdbid and/or episode information.

These are two checks that Ombi looks for to verify that a show exists and is available to be requested.

Most of the time, you can freely edit the listings on TVMAZE and the theTVDB to have the information needed to make an item available.

If you have edited the TVMAZE and/or theTVDB listings for a show, there is a time delay before the APIs have the new information. Give it a few hours before searching again.


Docker Issues

If you're running all your services in containers, be mindful that sometimes NAT is a fickle mistress for those who fiddle.
If you have services behind a reverse proxy, use the full external address for the service.
If you have them behind Organizr as well, then use the Docker IP and port of each container instead - to avoid any routing or authentication issues that this can cause.
If you use the host IP instead of the container IP, be sure to use the local port you mapped to the container, rather than simply the container port (these are not always the same).
For a breakdown of docker networking (and some reasoning), see Docker Networking.


Proxmox LXC Containers

set LC_ALL=en_US.UTF-8

or

sudo locale-gen "en_US.UTF-8"

or

sudo dpkg-reconfigure locales

and reboot

Taken from https://github.com/tidusjar/Ombi/issues/1783#issuecomment-351498238


i386 unsupported

N: Skipping acquire of configured file 'main/binary-i386/Packages' as repository 'https://apt.ombi.app/develop jessie InRelease' doesn't support architecture 'i386'

Replace deb http://apt.ombi.app/develop jessie main with deb [arch=amd64] http://apt.ombi.app/develop/ jessie main in /etc/apt/sources.list.d/ombi.list.


No such column: x.RequestId

If you are on the latest version and are seeing SQLite Error 1: 'No such column: x.RequestId', refer below for a solution.
Referenced in Issue 3214

Docker

Here is a one-liner to fix the issue, assuming you are running in a docker container, your container has ombi in the name, your image requires the config dir to be mounted at /config, and the host is running Debian, Ubuntu, or a related distro that uses apt. If any of these points aren't true, see the details below the command and modify to your needs.

sudo apt update
sudo apt install -y sqlite3
sqlite3 $( \
  docker inspect --format '{{ range .Mounts }}{{if eq .Destination "/config"}}{{ .Source }}{{end}}{{end}}'  \
  $(docker ps --filter name=ombi --format '{{.ID}}') \
)/app/OmbiExternal.db 'ALTER TABLE PlexServerContent ADD COLUMN RequestId INTEGER NULL'

Explanation of parts:

Update apt & install sqlite3

sudo apt update
sudo apt install -y sqlite3;

Inspect container $CONTAINER_ID, list mounts, and if the mount destination is /config, print the source

docker inspect --format \
  '{{ range .Mounts }}{{if eq .Destination "/config"}}{{ .Source }}{{end}}{{end}}'  \
  $CONTAINER_ID

List containers, filtering on ombi. Format output to only include the container id.

docker ps --filter name=ombi --format '{{.ID}}'

Concatenate the inspected directory path with the path to the .db file within the /config dir

$( ... )/app/OmbiExternal.db

Tell sqlite3 to run the actual query

 sqlite3 /opt/ombi/app/OmbiExternal.db 'ALTER TABLE PlexServerContent ADD COLUMN RequestId INTEGER NULL'

After you are done, you can remove sqlite3

sudo apt remove --purge sqlite3

Unraid

RUN:

cd ~
wget https://www.sqlite.org/2019/sqlite-tools-linux-x86-3300100.zip
unzip sqlite-tools-linux-x86-3300100.zip
cd sqlite-tools-linux-x86-3300100
chmod a+x sqlite3
./sqlite3 $(find / -name OmbiExternal.db -print0 -quit 2>/dev/null) 'ALTER TABLE PlexServerContent ADD COLUMN RequestId INTEGER NULL'

Debian/Ubuntu

If "sqlite3" is not installed:

sudo apt update
sudo apt install -y sqlite3

Fix Database:
If your Ombi databases are in a different location than "/etc/Ombi", replace that with the location of your Ombi databases.

sqlite3 /etc/Ombi/OmbiExternal.db 'ALTER TABLE PlexServerContent ADD COLUMN RequestId INTEGER NULL'

If we want to uninstall "sqlite3" to clean the system.

sudo apt remove --purge sqlite3

Last update: 2021-03-03