Database Schema Issue missing transport_group_transport table

My database schema seems to be out of date and having an issue. Here is the output of my validate.php


Component Version
LibreNMS 1.42
DB Schema 257
PHP 7.0.30-0ubuntu0.16.04.1
MySQL 10.0.34-MariaDB-0ubuntu0.16.04.1
RRDTool 1.5.5


[OK] Composer Version: 1.6.5
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Database: missing table (transport_group_transport)
[FAIL] We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (
[FIX] Run the following SQL statements to fix.
SQL Statements:
CREATE TABLE transport_group_transport ();

When I try to run the command suggested, it fails stating that the syntax is incorrect.

I’ve not looked into why it doesn’t give you the correct create table query but run this:

CREATE TABLE IF NOT EXISTS transport_group_transport (transport_group_id INT(11) NOT NULL, transport_id INT(11) NOT NULL);

Thank you. That corrected the error. I am having a lot of issues with alerts. For example, alerts don’t always go out and my templates don’t add line breaks. Any ideas?