Menu

#2207 Adding new field to itop object

Unassigned
not-a-bug
nobody
None
User Interface
Critical
2.6.0
defect
2023-11-08
2023-11-08
No

Hi,
I am trying to add new fields to the object 'pc':

  • "employee_number" pointing to the id of a person : this one worked well
  • but i want also to add 4 fields for printers to know which printers someone has on the pc
    When i run the upgrade of my itop 3.0.0, i'm getting this message :

Failed to issue SQL query: query = ALTER TABLE pc CHANGE id id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, CHANGE osfamily_id osfamily_id INT(11) DEFAULT 0, CHANGE osversion_id osversion_id INT(11) DEFAULT 0, CHANGE employee_number employee_number INT(11) DEFAULT 0, ADD Printer_1 INT(11) DEFAULT 0, ADD Printer_2 INT(11) DEFAULT 0, ADD Printer_3 INT(11) DEFAULT 0, ADD Printer_4 INT(11) DEFAULT 0, mysql_errno = 1068, mysql_error = Multiple primary key defined

I added up some screenshot of my configuration
Thanks for your help

3 Attachments

Discussion

  • Vincent @ Combodo

    • status: new --> not-a-bug
     
  • Vincent @ Combodo

    Please use the Discussion for such topics.
    Ticket are made for reporting iTop bugs

     
  • Merveille Mad

    Merveille Mad - 2023-11-08

    I'll do !
    Thank you !!

     

Log in to post a comment.

MongoDB Logo MongoDB