GLPI 0.85.2 Item - Document Connection

SameAsYou · 2015-03-03 12:46:37

Hello

We have updated GPLI 85.2 on linux
Problem in connection in Document to Item
I searched at forum but no results

How to check (admin rights):

1 Go Home > Assets > Computer - Make Computer
2 Go to Components - Add Component, Controller for example (you need have some components here)
3 Click Update (on component)
4 Go Documents - Add document, "Test" for example (you need have some documents here)

At this point - all seems to be good, but

5 Go Home > Management > Documents - Find and open "Test"
6 Go Associated items

..and... nothing
I try to add Item manually

7 Add > Item - Controller

...and... no results found

Add some pic from glpi site (View from IE 11 x32, Win 7 x64):

Item
Item

SameAsYou · 2015-03-03 12:46:58

Item - Controller

SameAsYou · 2015-03-03 12:47:22

Document

SameAsYou · 2015-03-03 12:49:21

Document - Controller

SameAsYou · 2015-03-03 13:36:54

I found another place where Links does not work:

After you update Component by entering Financial and administrative information - Link to Budget and Value
Go Home > Management > Budgets > "Budget" > Items
You will not see connected items, but "Total spent on the budget" will be right

yllen · 2015-03-04 20:11:34

Which Linux OS do you used? centOS? debian? ubuntu?...

SameAsYou · 2015-03-05 04:05:01

Server configuration:
CentOS 6.5 x86 - Linux 2.6.32-504.8.1.el6.i686
MySQL Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1
PHP 5.3.3 (built: Oct 30 2014 19:56:14)
GLPI 0.85.2

yllen · 2015-03-05 09:48:34

There is a problem with rpm of centOS.
You must apply this patch to solve: https://forge.indepnet.net/projects/glp … ions/23370
Problem was also corrected by the rpm maker: http://rpms.famillecollet.com/enterpris … /glpi.html

SameAsYou · 2015-03-06 09:56:22

After we change fileupload.php and html.class.php from https://forge.indepnet.net/projects/glp … ions/23370
We can't login to website (blank screen after login)

What problems your patch resolve?
Please describe how we must change GLPI for resolve our problem

SameAsYou · 2015-03-06 16:00:26

By the way, on second picture was component name "Item - Controller link - N/A - ID 26"
What should be in place "N/A"? (Item was linked to computer and document)

Last edited by SameAsYou (2015-03-06 16:01:39)

SameAsYou · 2015-03-10 08:02:15

After clean installation on Windows 2008r2 + XAMPP 5.6.3 + GLPI 85.2 = same result, as I wrote earlier

Last edited by SameAsYou (2015-03-10 08:05:04)

SameAsYou · 2015-03-11 06:23:25

Can someone help me?
At least, write bug submission or feature submission in tracker

yllen · 2015-03-13 15:59:31

I can't write a bug report because i have no problem.
I make exactly your example without any issue.
Do you have error in debug mode? in log files?

SameAsYou · 2015-03-13 18:50:24

As I wrote earlier (11 post), I made clean install without any plugins or configurations, all by default with empty database
After that I got same result (1 post)
1 I don't see link to "computer component" item at links page of document
2 I don't see link to "computer component" item at budget Items page
3 I can't add "computer component" Item as link to document

I don't enable debug mode, my opinion, this feature had to work out of box

Last edited by SameAsYou (2015-03-13 18:57:24)

SameAsYou · 2015-03-18 08:41:10

Turn on Debug Mode in production db

Open - Home > Management > Documents - open "Test" > Associated items

Document (Debug Mode)

Document (Debug)

Test on clean glpi installation show same result

Last edited by SameAsYou (2015-03-18 10:11:07)

SameAsYou · 2015-03-24 06:03:59

Can someone say about this error, its a bug? that need for resolve?

Querie:
SELECT `glpi_items_devicecontrols`.*, `glpi_documents_items`.`id` AS IDD, `glpi_entities`.`id` AS entity 
FROM `glpi_documents_items`, `glpi_items_devicecontrols` 
LEFT JOIN `glpi_entities` ON (`glpi_entities`.`id` = `glpi_items_devicecontrols`.`entities_id`) 
WHERE `glpi_items_devicecontrols`.`id` = `glpi_documents_items`.`items_id` AND `glpi_documents_items`.`itemtype` = 'Item_DeviceControl' AND `glpi_documents_items`.`documents_id` = '497' 
ORDER BY `glpi_entities`.`completename`, `glpi_items_devicecontrols`.`name` 0.000

Error:
Unknown column 'glpi_items_devicecontrols.name' in 'order clause'

yllen · 2015-03-27 18:44:41

Your problem is only with Item- Link xxx (i had'nt test it).
Ticket open on the roadmap: https://forge.indepnet.net/issues/5261

yllen · 2015-04-03 18:05:17

Fix with commit https://forge.indepnet.net/projects/glp … ions/23411 and https://forge.indepnet.net/projects/glp … ions/23414

SameAsYou · 2015-04-09 05:48:53

Thanks, Item-Document works as it should (tested on windows)

But,

1 Component name not display correctly "Item - Controller link - N/A - ID 26"

Here and in component change history
Item - Controller

2 Home > Management > Budgets > "Budget" > Items - Budget-Components link is not visible

Last edited by SameAsYou (2015-04-09 13:19:05)

yllen · 2015-04-09 18:03:46

1. You don't have a name for the link. But you have the name of the component in green on the left
2. Fix purposed: https://forge.indepnet.net/projects/glp … ions/23440

SameAsYou · 2015-04-10 06:34:17

Thank you very much

Changed to fix budget.class.php and it's working (tested on windows)

But in Budget - Item - Associated item (Name column) also N/A there is no green component name

In Document historical information - (Update column) "Add a link with item": N/A (#)
In Computer historical information - (Update column) "Add component:" (name of model) (#)

yllen · 2015-04-10 11:10:08

Corrected: https://forge.indepnet.net/projects/glp … ions/23441

SameAsYou · 2015-04-10 12:41:12

Thank you, again
Budget - Item - Associated item (Name column) Now looks fine

Similar problem in Document - Item - Associated item (Name column) wrong name of linked component name

I noticed that in Historical of Computer/Document have information about Item/Document/Budget change
And Historical of Item do not have information about Add/Delete link to Computer/Document
It's a bug or feature?

yllen · 2015-04-10 14:19:29

Fix for document: https://forge.indepnet.net/projects/glp … ions/23445

SameAsYou · 2015-04-13 04:56:29

Thank you
Document - Item - Associated item (Name column) Now ok

In Document historical information not chaged

Last edited by SameAsYou (2015-04-13 05:53:48)

Forum GLPI-Project

Announcement

#1 2015-03-03 12:46:37

GLPI 0.85.2 Item - Document Connection

#2 2015-03-03 12:46:58

Re: GLPI 0.85.2 Item - Document Connection

#3 2015-03-03 12:47:22

Re: GLPI 0.85.2 Item - Document Connection

#4 2015-03-03 12:49:21

Re: GLPI 0.85.2 Item - Document Connection

#5 2015-03-03 13:36:54

Re: GLPI 0.85.2 Item - Document Connection

#6 2015-03-04 20:11:34

Re: GLPI 0.85.2 Item - Document Connection

#7 2015-03-05 04:05:01

Re: GLPI 0.85.2 Item - Document Connection

#8 2015-03-05 09:48:34

Re: GLPI 0.85.2 Item - Document Connection

#9 2015-03-06 09:56:22

Re: GLPI 0.85.2 Item - Document Connection

#10 2015-03-06 16:00:26

Re: GLPI 0.85.2 Item - Document Connection

#11 2015-03-10 08:02:15

Re: GLPI 0.85.2 Item - Document Connection

#12 2015-03-11 06:23:25

Re: GLPI 0.85.2 Item - Document Connection

#13 2015-03-13 15:59:31

Re: GLPI 0.85.2 Item - Document Connection

#14 2015-03-13 18:50:24

Re: GLPI 0.85.2 Item - Document Connection

#15 2015-03-18 08:41:10

Re: GLPI 0.85.2 Item - Document Connection

#16 2015-03-24 06:03:59

Re: GLPI 0.85.2 Item - Document Connection

#17 2015-03-27 18:44:41

Re: GLPI 0.85.2 Item - Document Connection

#18 2015-04-03 18:05:17

Re: GLPI 0.85.2 Item - Document Connection

#19 2015-04-09 05:48:53

Re: GLPI 0.85.2 Item - Document Connection

#20 2015-04-09 18:03:46

Re: GLPI 0.85.2 Item - Document Connection

#21 2015-04-10 06:34:17

Re: GLPI 0.85.2 Item - Document Connection

#22 2015-04-10 11:10:08

Re: GLPI 0.85.2 Item - Document Connection

#23 2015-04-10 12:41:12

Re: GLPI 0.85.2 Item - Document Connection

#24 2015-04-10 14:19:29

Re: GLPI 0.85.2 Item - Document Connection

#25 2015-04-13 04:56:29

Re: GLPI 0.85.2 Item - Document Connection

Board footer