[BUG] All computers page is empty

[KazimierzSyncron]

OCS Inventory version
Version : 2.8 (setup.sh installation)
Ubuntu 20.04
Apache 2.4.46
PHP 7.4
Perl 5.30
MariaDB 10.3.25

Describe the bug
After upgrading 2.7 to 2.8 the "All computers" page shows 0 entries - in "All computers", "Active computers" and "Archived computers".
On dashboard I see all 424 computers, I can find them also using "Search with various criteria" page. So there's something wrong with "All computers".
Tested on different browser, with no extensions that might interfere with any scripts. Same results.
The agent version also does not affect this case - tested versions 2.4.2, 2.6, 2.7 and 2.8

To Reproduce
Steps to reproduce the behavior:

1. Upgrade OCS server from 2.7 to 2.8, using setup.sh installation
2. Go to 'All computers'
3. Click on 'All computers' OR 'Active computers' OR 'Archived computers'
4. See empty computer list

Expected behavior
All computers page should show all computers

Screenshots
If applicable, add screenshots to help explain your problem.

Log file (optional)
The only errors I get in apache error.log are:

[perl:error] [pid 26086:tid 140683255932672] [client 192.168.12.14:55170] Not a HASH reference at /usr/local/share/perl/5.30.0/Apache/Ocsinventory/Server/Capacities/Ipdiscover.pm line 156.\
[proxy_fcgi:error] [pid 26086:tid 140683500136192] [client 192.168.12.13:51085] AH01071: Got error 'PHP message: PHP Warning:  array_key_exists() expects parameter 2 to be array, null given in /usr/share/ocsinventory-reports/ocsreports/require/search/Search.php on line 1127', referer: https://ocs.syncron.team/ocsreports/index.php?first

First error is already reported in UnixAgent project.

[Tanarri]

same here.
I do several times a year a upgdate to the current git version.
Now I am on the OCSInventory-Server Version

• commit 89a4fdc45ce730db57b7cc29c7c5c3c10b40b4d4 (HEAD -> master, origin/master, origin/HEAD)

[charleneauger]

Hi @Tanarri @KazimierzSyncron,

On your db server, can you execute this query DESCRIBE hardware; and verify if the column ARCHIVE is here ?
Can you verify if table archive exists too ?

Regards,
Charlene

[KazimierzSyncron]

Here are the results. No Archive column, only Arch.
ARCHIVE as a separate table exists, yes.

MariaDB [ocsweb]> DESCRIBE hardware;
+----------------+---------------------+------+-----+---------+----------------+
| Field          | Type                | Null | Key | Default | Extra          |
+----------------+---------------------+------+-----+---------+----------------+
| ID             | int(11)             | NO   | PRI | NULL    | auto_increment |
| DEVICEID       | varchar(255)        | NO   | MUL | NULL    |                |
| NAME           | varchar(255)        | YES  | MUL | NULL    |                |
| WORKGROUP      | varchar(255)        | YES  | MUL | NULL    |                |
| USERDOMAIN     | varchar(255)        | YES  |     | NULL    |                |
| OSNAME         | varchar(255)        | YES  | MUL | NULL    |                |
| OSVERSION      | varchar(255)        | YES  |     | NULL    |                |
| OSCOMMENTS     | varchar(255)        | YES  |     | NULL    |                |
| PROCESSORT     | varchar(255)        | YES  |     | NULL    |                |
| PROCESSORS     | int(11)             | YES  |     | 0       |                |
| PROCESSORN     | smallint(6)         | YES  |     | NULL    |                |
| MEMORY         | int(11)             | YES  | MUL | NULL    |                |
| SWAP           | int(11)             | YES  |     | NULL    |                |
| IPADDR         | varchar(255)        | YES  |     | NULL    |                |
| DNS            | varchar(255)        | YES  |     | NULL    |                |
| DEFAULTGATEWAY | varchar(255)        | YES  |     | NULL    |                |
| ETIME          | datetime            | YES  |     | NULL    |                |
| LASTDATE       | datetime            | YES  |     | NULL    |                |
| LASTCOME       | datetime            | YES  |     | NULL    |                |
| QUALITY        | decimal(7,4)        | YES  |     | NULL    |                |
| FIDELITY       | bigint(20)          | YES  |     | 1       |                |
| USERID         | varchar(255)        | YES  | MUL | NULL    |                |
| TYPE           | int(11)             | YES  |     | NULL    |                |
| DESCRIPTION    | varchar(255)        | YES  |     | NULL    |                |
| WINCOMPANY     | varchar(255)        | YES  |     | NULL    |                |
| WINOWNER       | varchar(255)        | YES  |     | NULL    |                |
| WINPRODID      | varchar(255)        | YES  |     | NULL    |                |
| WINPRODKEY     | varchar(255)        | YES  |     | NULL    |                |
| USERAGENT      | varchar(50)         | YES  |     | NULL    |                |
| CHECKSUM       | bigint(20) unsigned | YES  | MUL | 262143  |                |
| SSTATE         | int(11)             | YES  |     | 0       |                |
| IPSRC          | varchar(255)        | YES  |     | NULL    |                |
| UUID           | varchar(255)        | YES  |     | NULL    |                |
| ARCH           | varchar(10)         | YES  |     | NULL    |                |
| CATEGORY_ID    | int(11)             | YES  |     | NULL    |                |
+----------------+---------------------+------+-----+---------+----------------+
35 rows in set (0.001 sec)


MariaDB [ocsweb]> DESCRIBE archive;
+-------------+---------+------+-----+---------+----------------+
| Field       | Type    | Null | Key | Default | Extra          |
+-------------+---------+------+-----+---------+----------------+
| ID          | int(11) | NO   | PRI | NULL    | auto_increment |
| HARDWARE_ID | int(11) | NO   | UNI | NULL    |                |
+-------------+---------+------+-----+---------+----------------+
2 rows in set (0.001 sec)

Regards,
Kazimierz

[charleneauger]

@KazimierzSyncron, run ALTER TABLE hardwareADD COLUMNARCHIVE INT DEFAULT NULL; and it should be ok.

Regards,
Charlene

[KazimierzSyncron]

Unfortunately that command caused error

MariaDB [ocsweb]> ALTER TABLE hardware ADD COLUMN ARCHIVE INT DEFAULT NULL;
ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

So I used this command
ALTER TABLE hardware ROW_FORMAT=dynamic;
Before that. Then I was able to execute
ALTER TABLE hardware ADD COLUMN archive INT DEFAULT NULL;
successfully. Computers are shown again in "All computers". Thanks!

[charleneauger]

Good ! I close this issue :)

Regards,
Charlene

[Tanarri]

Hi,
following two commands did the trick also for me:

ALTER TABLE hardware ROW_FORMAT=dynamic;
ALTER TABLE hardware ADD COLUMN archive INT DEFAULT NULL;

Computers are shown again in "All computers"
Thank you

Greetings
TanarRi