Forum GLPI-Project

ademarre

Member

Registered: 2009-02-06

Posts: 8

Licence - Lier à un matériel existant

Bonjour,

Plugin : Order Management 1.7.1
GLPI : 0.83.4

Lorsque je veux lier une licence dans le plugin "Order Management", il n'y a aucune licence dans la liste.

Informations du serveur

Operating system : Windows NT ------- 5.2 build 3790 (Windows Server 2003 R2 Standard Edition Service Pack 2) i586
PHP 5.3.5 (Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SQLite, SimpleXML, apache2handler, bcmath, bz2, calendar, com_dotnet,
    ctype, date, dom, ereg, exif, filter, ftp, gd, gettext, hash, iconv, imap, json, ldap, libxml, mbstring, mcrypt, mhash, ming,
    mysql, mysqli, mysqlnd, odbc, pcre, pdo_mysql, pdo_sqlite, session, soap, sockets, sqlite3, standard, tokenizer, wddx, xml,
    xmlreader, xmlrpc, xmlwriter, zip, zlib)
Setup: memory_limit="128M" max_execution_time="30" safe_mode="" session.save_handler="files" post_max_size="512M"
    upload_max_filesize="256M" 
Software: Apache/2.2.17 (Win32) mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 (Apache/2.2.17 (Win32)
    mod_ssl/2.2.17 OpenSSL/0.9.8o PHP/5.3.4 mod_perl/2.0.4 Perl/v5.10.1 Server at 10.1.2.200 Port 80)
    Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/20100101 Firefox/17.0
MySQL: 5.5.8 (root@localhost/glpi)

Liste des "Plugins"

    financialreports Name:Asset situation                Version :1.9.0      Status :Installed / not activated
    environment      Name:Environment                    Version :1.6.0      Status :Enabled
    datainjection    Name:File injection                 Version :2.2.1      Status :Enabled
    gestioncatalogue Name:Gestion Catalogue de Service   Version :4.0.1      Status :Installed / not activated
    order            Name:Gestion des commandes          Version :1.7.1      Status :Enabled
    uninstall        Name:Item's uninstallation          Version :2.1.1      Status :Enabled
    genericobject    Name:Objects management             Version :2.1.2      Status :Installed / not activated
    massocsimport    Name:OCS import                     Version :1.6.0      Status :Enabled
    pdf              Name:Print to pdf                   Version :0.83       Status :Enabled
    reports          Name:Reports                        Version :1.6.1      Status :Enabled
    shellcommands    Name:Shell Commands                 Version :1.5.1      Status :Installed / not activated

sql-errors.log

*** MySQL query error : 
***
SQL: SELECT `glpi_softwarelicenses`.*,
                          CONCAT(`glpi_softwares`.`name`,\' - \',`glpi_softwarelicenses`.`name`)
                              AS name
                   FROM `glpi_softwarelicenses`
                   LEFT JOIN `glpi_softwares`
                        ON (`glpi_softwarelicenses`.`softwares_id` = `glpi_softwares`.`id`)
                   WHERE 1  AND `glpi_softwarelicenses`.`id` NOT IN (\'0\')  AND 1  AND `id` NOT IN (SELECT `items_id` FROM `glpi_plugin_order_orders_items`
                           WHERE `itemtype`=\'SoftwareLicense\' AND `items_id`!=\'0\') AND ( `glpi_softwarelicenses`.`entities_id` = \'0\'  )  ORDER BY name
                 
Error: Column 'id' in IN/ALL/ANY subquery is ambiguous
Backtrace :
D:\ServerOCS-GLPI\xampp\htdocs\glpi\ajax\dropdownValue.php :462        DBmysql->query()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\inc\ajax.class.php :442        include()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\inc\dropdown.class.php :189        Ajax::dropdown()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\inc\reference.class.php :737        Dropdown::show()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\ajax\linkactions.php :56        PluginOrderReference->dropdownAllItemsByType()
D:/ServerOCS-GLPI/xampp/htdocs/glpi/plugins/order/ajax/linkactions.php

php-errors.logs

04-01-2013 21:56
Notice(8): Undefined index: id
Backtrace :
D:\ServerOCS-GLPI\xampp\htdocs\glpi\inc\toolbox.class.php:490        Toolbox::userErrorHandlerNormal()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\inc\link.class.php:637        Toolbox::userErrorHandlerDebug()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\front\link.form.php:102        PluginOrderLink->createLinkWithItem()

04-01-2013 21:56
Notice(8): Undefined index: number
Backtrace :
D:\ServerOCS-GLPI\xampp\htdocs\glpi\inc\toolbox.class.php:490        Toolbox::userErrorHandlerNormal()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\inc\link.class.php:638        Toolbox::userErrorHandlerDebug()
D:\ServerOCS-GLPI\xampp\htdocs\glpi\plugins\order\front\link.form.php:102        PluginOrderLink->createLinkWithItem()

J'ai aucun problème pour lier des ordinateurs et / ou matériels. Seulement avec les licences.

Merci d'avance pour votre aide.

Last edited by ademarre (2013-01-04 23:30:05)