Database Schema Issue missing transport_group_transport table

Help
1

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
SNMP NET-SNMP 5.7.3

====================================

[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 (https://t.libren.ms/5gscd):
[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.

2

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);

3

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?