Sql errors - Please Help

[Fozzz]

can anyone help me out on the below error

librenms@librenms:~$ ./daily.sh
Fetching new release information OK
Updating to latest release OK
Updating Composer packages OK
Updating SQL-Schema OK
Updating submodules OK
Cleaning up DB OK
Fetching notifications OK
Caching PeeringDB data OK

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

Component	Version
LibreNMS	21.4.0
DB Schema	2020_12_14_091314_create_port_group_port_table (202)
PHP	7.4.5
Python	3.6.9
MySQL	10.5.9-MariaDB-1:10.5.9+maria~bionic
RRDTool	1.7.0
SNMP	NET-SNMP 5.7.3

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

[OK] Composer Version: 2.0.13
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
librenms@librenms:~$ ./lnms migrate
**

• Application In Production!     *
  

**

Do you really wish to run this command? (yes/no) [no]:
y

Migrating: 2020_12_14_091314_create_port_groups_table

In Connection.php line 678:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups
’ already exists (SQL: create table port_groups (id int unsigned not nu
ll auto_increment primary key, name varchar(255) not null, desc varchar
(255) null) default character set utf8mb4 collate ‘utf8mb4_unicode_ci’)

In Exception.php line 18:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups
’ already exists

In PDOStatement.php line 112:

SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'port_groups
’ already exists

[rhinoau]

We eventually solved that one here - see the solution linked under the question:
Error port device

Error port device

This is how I dropped the tables. mysql -u librenms -p use librenms; SET FOREIGN_KEY_CHECKS = 0; drop table port_group_port; drop table port_groups; SET FOREIGN_KEY_CHECKS = 1; quit; rerun ./lnms migrate ./validate.php Saved my bacon.(editado) [image] Thanks

Your DB version is not the issue, so dropping the tables and letting it re-run worked for others.

[Fozzz]

thank you

i have done that and can get back in the web gui

now i get the following issue

Do you really wish to run this command? (yes/no) [no]:

y

Migrating: 2021_04_08_151101_add_foreign_keys_to_port_group_port_table

In Connection.php line 678:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_gr
oup_port’ doesn’t exist (SQL: alter table port_group_port add constraint
port_group_port_port_group_id_foreign foreign key (port_group_id) refer
ences port_groups (id) on delete CASCADE)

In Exception.php line 18:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_gr
oup_port’ doesn’t exist

In PDOStatement.php line 112:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘librenms.port_gr
oup_port’ doesn’t exist

[rhinoau]

Check post 29 from the same thread for the manual table creation perhaps, though it’s strange that the migrate seems to have continued on - some people hit that issue, but I didn’t:

Error port device

For me, ./lnms migrate was unable to recreate the two tables after dropping them. For anyone running into the same, here are the table schemas to quickly recreate them. port_groups: CREATE TABLE `port_groups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `desc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `port_groups_name_unique` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLAT…

What’s the output of the lnms migrate after it progressed past 2020_12_14_091314_create_port_group_port_table?

[Fozzz]

thank you

you have managed to help to resolve this issue