Dear all,
I have upgraded our NeDi 2.0 installation on CentOS to NeDi 2.3 on SLES 15 by upgrading 2.0 -> 2.1 -> 2.3 and have problems with all PHP pages which show e.g. device details (e.g. Devices-List.php or Devices-Status.php).
Both PHP pages are not fully loading, they are both stopping at the table cell which displays device serial number.
Devices-List.php breaks in line 319
Apache error log shows:
[Fri May 03 12:23:09.872768 2024] [php:error] [pid 2947] [client 10.200.249.67:40209] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'nedi.vendorinfo' doesn't exist in /var/nedi/html/inc/libdb-mysql.php:335\nStack trace:\n#0 /var/nedi/html/inc/libdb-mysql.php(335): mysqli_query()\n#1 /var/nedi/html/inc/libdev.php(1035): DbQuery()\n#2 /var/nedi/html/Devices-List.php(319): InvCheck()\n#3 {main}\n thrown in /var/nedi/html/inc/libdb-mysql.php on line 335, referer: http://xxxx.xxxx.xxxx/Devices-List.phpDevices-Status.php breaks in line 525 + 1328
Apache error log shows:
[Fri May 03 13:21:32.987417 2024] [php:error] [pid 2959] [client 10.200.249.67:40803] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'nedi.vendorinfo' doesn't exist in /var/nedi/html/inc/libdb-mysql.php:335\nStack trace:\n#0 /var/nedi/html/inc/libdb-mysql.php(335): mysqli_query()\n#1 /var/nedi/html/inc/libdev.php(1035): DbQuery()\n#2 /var/nedi/html/Devices-Status.php(525): InvCheck()\n#3 {main}\n thrown in /var/nedi/html/inc/libdb-mysql.php on line 335, referer: http://xxxx.xxxx.xxxx/Devices-Modules.php[Fri May 03 12:23:38.586608 2024] [php:error] [pid 2950] [client 10.200.249.67:40212] PHP Fatal error: Uncaught mysqli_sql_exception: Table 'nedi.vendorinfo' doesn't exist in /var/nedi/html/inc/libdb-mysql.php:335\nStack trace:\n#0 /var/nedi/html/inc/libdb-mysql.php(335): mysqli_query()\n#1 /var/nedi/html/inc/libdev.php(1035): DbQuery()\n#2 /var/nedi/html/Devices-Status.php(1328): InvCheck()\n#3 {main}\n thrown in /var/nedi/html/inc/libdb-mysql.php on line 335, referer: http://xxxx.xxxx.xxxx/Devices-Modules.phpCommenting out all three lines allows the PHP pages to fully render, but obviously the device serial number is missing.
When looking at the "devices" table directly in the database, I cannot see any problem with the content.
Does anyone have a solution / fix for this?
Thanks, Gerhard