update to 2.5 broke administrativ data

[Scifire]

It's hard to solve a problem when important details are missing, that why we added this template, to help you and us.

General informations

Operating system : Ubuntu 16.04.5 LTS

Server installation method ( Only one choice )

• Install SH

Server informations

Php version : 7.0.30
Mysql: Ubuntu) version 5.7.23-0ubuntu0.16.04.1
Apache version : Apache/2.4.18 (Ubuntu)

OCS Inventory informations

Ocsreports version : 2.5

Problem's description

After the update to 2.5 the administrativ data fields with select is broken.

I can´t see what was selected before and are unable to select something.

It is also not possible to edit any administrativ data filed it will every time link me to "new tab".

also the date field looks broken since "type" is empty like the select field.

If i create new one´s it will work.

[Scifire]

@gillesdubois is there a way that we can fix this local? Without this we can´t update

[Scifire]

@charleneauger i tried to se this fix manually but it hadn´t worked. I updated the installation, changed the two lines and started then the apache service and upgraded the DB, still the same problem.

[charleneauger]

Hi @Scifire ,

This fix #583 updates the administrative data, put this code in your and reconnect to the interface.

Regards,
Charlene Auger

[Scifire]

@charleneauger that´s what i did. Didn´t worked administrative data is still broken.

[charleneauger]

@Scifire can you send me a screenshot of your accountinfo_config table from your database please?

Regards,
Charlene

[Scifire]

@charleneauger before or after the update? As long as this is not fixed we can´t use it live.
So before update:

mysql> describe accountinfo_config;
+------------------+--------------+------+-----+---------+----------------+
| Field            | Type         | Null | Key | Default | Extra          |
+------------------+--------------+------+-----+---------+----------------+
| ID               | int(11)      | NO   | PRI | NULL    | auto_increment |
| NAME_ACCOUNTINFO | varchar(255) | YES  |     | NULL    |                |
| TYPE             | int(11)      | YES  |     | NULL    |                |
| NAME             | varchar(255) | YES  |     | NULL    |                |
| ID_TAB           | int(11)      | YES  |     | NULL    |                |
| COMMENT          | varchar(255) | YES  |     | NULL    |                |
| SHOW_ORDER       | int(11)      | NO   |     | NULL    |                |
| ACCOUNT_TYPE     | varchar(255) | YES  |     | NULL    |                |
| DEFAULT_VALUE    | varchar(255) | YES  |     | NULL    |                |
+------------------+--------------+------+-----+---------+----------------+
9 rows in set (0.00 sec)

mysql> select * from accountinfo_config;
+----+------------------+------+-----------------+--------+-----------------+------------+--------------+---------------+
| ID | NAME_ACCOUNTINFO | TYPE | NAME            | ID_TAB | COMMENT         | SHOW_ORDER | ACCOUNT_TYPE | DEFAULT_VALUE |
+----+------------------+------+-----------------+--------+-----------------+------------+--------------+---------------+
|  1 | TAG              |    0 | TAG             |      1 | TAG             |          1 | COMPUTERS    | NULL          |
|  2 | TAG              |    0 | TAG             |      1 | TAG             |          1 | SNMP         | NULL          |
|  3 | NULL             |    0 | TEAMVIEWER      |      2 | Teamviewer ID   |          2 | COMPUTERS    |               |
|  5 | NULL             |    7 | LOCATION        |      1 | Standort        |          3 | COMPUTERS    |               |
|  6 | NULL             |    6 | INSTALL         |      1 | Install Date    |          4 | COMPUTERS    |               |
|  7 | NULL             |    0 | ANSPRECHPARTNER |      1 | Ansprechpartner |          5 | COMPUTERS    |               |
| 11 | NULL             |    1 | DESCRIPTION     |      4 | Description     |          9 | COMPUTERS    |               |
+----+------------------+------+-----------------+--------+-----------------+------------+--------------+---------------+
7 rows in set (0.00 sec)

[charleneauger]

Thank's and after the update, the table is the same? @Scifire

[Scifire]

@charleneauger yes it's the same after update. i have also now test system after the update.

[Scifire]

@charleneauger wait. i´ve overseen that you posted another PR since the first fix. I´ll test this on Monday and give you feedback.

[charleneauger]

@Scifire Thank's

[Scifire]

@charleneauger i´ve inserted now the code you mentioned.
The administrativ data will now be shown correctly in the ui but i´m missing our data filled in from one of the fields.
It´s the field "Standort" which is a RADIOBUTTON.
The date filed is correctly updated.

[charleneauger]

Hi @Scifire ,

This bug has been fixed, Fix: #586

Regards,
Charlene Auger

[Scifire]

@charleneauger i made the changes from the fix but there´s still no data in the fields.
Or is this needed before the update?

[Scifire]

@charleneauger any news on this? Still not able to update until i know how to proceed here

[charleneauger]

Hi @Scifire ,

Sorry for the delay.
What is your current version of reports ?

Regards,
Charlene

[Scifire]

@charleneauger Our live system has version 2.4.1

[charleneauger]

@Scifire , I just tested from a version 2.4.1 to a version 2.5 with radio button but I have not met your problem ... My radio button have updated correctly.
I advise you to recreate this administrative data if it is possible.

Regards,
Charlene

[Scifire]

@charleneauger the problem is not the button the problem is the data we already filled in. This data is lost after the update (for example the install date or the location).
And no i´m not willing to fill out the administrative data of our over 400 inventoried hosts.