Topic: Upgrade database to 9.1.3 from .84.5
We have an existing GLPI installation and I was tasked with updating to a new one.
I ran into 2 snags after importing/updating the database:
1) Our "Staff" profile lost all permissions set for asset view/management. The existing installation has "write" selected for every drop down, while the new installation had an empty table with nothing allowed.
2) The associated elements table wasn't properly populated. Ticket management had empty results under "Associated Elements" for every ticket. The glpi_items_tickets table was empty.
My fix was to run the following SQL command, to pull the associated element out of each row in tickets, and insert it into the glpi_items_tickets table:
INSERT INTO glpi_items_tickets (itemtype, items_id, tickets_id)
SELECT itemtype, items_id, id as tickets_id
WHERE NOT items_id=0;