I am using itop from last 3 months, and I am facing one issue regarding profile management.
ISSUE:- I create one user account and assign him problem manager profile and also assign one organization.
after that i log in as new user and create new problem, itop shows fatal error and if i search any problem same error occure.
Error is :- Fatal error, iTop cannot continue. Error: Failed to issue SQL query: query = SELECT DISTINCT `lnkTicketToDoc_lnktickettodoc`.`id` AS `lnkTicketToDocid`, `lnkTicketToDoc_lnktickettodoc`.`ticket_id` AS `lnkTicketToDocticket_id`, `Ticket_ticket`.`ref` AS `lnkTicketToDocticket_ref`, `lnkTicketToDoc_lnktickettodoc`.`document_id` AS `lnkTicketToDocdocument_id`, `Document_document_id_document`.`name` AS `lnkTicketToDocdocument_name`, CAST(CONCAT(COALESCE(`lnkTicketToDoc_lnktickettodoc`.`ticket_id`, '')) AS CHAR) AS `lnkTicketToDocfriendlyname`, CAST(CONCAT(COALESCE(`Ticket_ticket`.`ref`, '')) AS CHAR) AS `lnkTicketToDocticket_id_friendlyname`, `Ticket_ticket`.`finalclass` AS `lnkTicketToDocticket_id_finalclass_recall`, CAST(CONCAT(COALESCE(`Document_document_id_document`.`name`, '')) AS CHAR) AS `lnkTicketToDocdocument_id_friendlyname`, `Document_document_id_document`.`finalclass` AS `lnkTicketToDocdocument_id_finalclass_recall` FROM `lnktickettodoc` AS `lnkTicketToDoc_lnktickettodoc` INNER JOIN (`ticket` AS `Ticket_ticket` ) ON `lnkTicketToDoc_lnktickettodoc`.`ticket_id` = `Ticket_ticket`.`id` INNER JOIN (`document` AS `Document_document_id_document` ) ON `lnkTicketToDoc_lnktickettodoc`.`document_id` = `Document_document_id_document`.`id` WHERE ((`Ticket_ticket`.`id` = '5') AND (`lnkTicketToDoc`.`org_id` IN (1))) ORDER BY `lnkTicketToDocfriendlyname` ASC , mysql_error = Unknown column 'lnkTicketToDoc.org_id' in 'where clause', mysql_errno = 1054.
Please help me.
Regards
Arvind
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The easiest work-around is to edit the user account and to remove the limitation of the user to one organization.
But if you need to have this limitation, then the bug is already fixed in the latest branch of the code (it was committed as revision last week.) and will be fixed for iTop 1.2.
If you cannot wait for iTop 1.2 (planned for end of August), you can easily patch your own installation of iTop by modifying the files: 'userrights/userrightsprofile.class.inc.php', 'application/displayblock.class.inc.php' and 'pages/audit.php', as shown by the diff:
Dear All,
I am using itop from last 3 months, and I am facing one issue regarding profile management.
ISSUE:- I create one user account and assign him problem manager profile and also assign one organization.
after that i log in as new user and create new problem, itop shows fatal error and if i search any problem same error occure.
Error is :- Fatal error, iTop cannot continue. Error: Failed to issue SQL query: query = SELECT DISTINCT `lnkTicketToDoc_lnktickettodoc`.`id` AS `lnkTicketToDocid`, `lnkTicketToDoc_lnktickettodoc`.`ticket_id` AS `lnkTicketToDocticket_id`, `Ticket_ticket`.`ref` AS `lnkTicketToDocticket_ref`, `lnkTicketToDoc_lnktickettodoc`.`document_id` AS `lnkTicketToDocdocument_id`, `Document_document_id_document`.`name` AS `lnkTicketToDocdocument_name`, CAST(CONCAT(COALESCE(`lnkTicketToDoc_lnktickettodoc`.`ticket_id`, '')) AS CHAR) AS `lnkTicketToDocfriendlyname`, CAST(CONCAT(COALESCE(`Ticket_ticket`.`ref`, '')) AS CHAR) AS `lnkTicketToDocticket_id_friendlyname`, `Ticket_ticket`.`finalclass` AS `lnkTicketToDocticket_id_finalclass_recall`, CAST(CONCAT(COALESCE(`Document_document_id_document`.`name`, '')) AS CHAR) AS `lnkTicketToDocdocument_id_friendlyname`, `Document_document_id_document`.`finalclass` AS `lnkTicketToDocdocument_id_finalclass_recall` FROM `lnktickettodoc` AS `lnkTicketToDoc_lnktickettodoc` INNER JOIN (`ticket` AS `Ticket_ticket` ) ON `lnkTicketToDoc_lnktickettodoc`.`ticket_id` = `Ticket_ticket`.`id` INNER JOIN (`document` AS `Document_document_id_document` ) ON `lnkTicketToDoc_lnktickettodoc`.`document_id` = `Document_document_id_document`.`id` WHERE ((`Ticket_ticket`.`id` = '5') AND (`lnkTicketToDoc`.`org_id` IN (1))) ORDER BY `lnkTicketToDocfriendlyname` ASC , mysql_error = Unknown column 'lnkTicketToDoc.org_id' in 'where clause', mysql_errno = 1054.
Please help me.
Regards
Arvind
Hi Arvind,
I'm afraid, you're facing a bug of iTop 1.1 (cf Trac #415 : https://sourceforge.net/apps/trac/itop/ticket/415).
The easiest work-around is to edit the user account and to remove the limitation of the user to one organization.
But if you need to have this limitation, then the bug is already fixed in the latest branch of the code (it was committed as revision last week.) and will be fixed for iTop 1.2.
If you cannot wait for iTop 1.2 (planned for end of August), you can easily patch your own installation of iTop by modifying the files: 'userrights/userrightsprofile.class.inc.php', 'application/displayblock.class.inc.php' and 'pages/audit.php', as shown by the diff:
https://sourceforge.net/apps/trac/itop/changeset/1319
Hope this helps,
- Denis
Thanks for reply……………
I solved the issue. It works fine….
I have one more query regarding Workshift / calender feature.
I need calender for SLA management. but in itop there is no feature like calender.
I need to define the customer workshft like working hours, holidays.
Please help me on this query.
Thanks & Regards
Arvind