Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[ solved ] issue for mail converter
#5
yes, DB and table set UTF-8

there another Error in log

2020-05-04T15:35:23-03:00 DEBUG index > pquery insert into vtiger_troubletickets(ticketid,ticket_no,parent_id,priority,severity,status,category,update_log,hours,days,from_portal,title,solution,from_mailscanner,commentadded) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
2020-05-04T15:35:23-03:00 DEBUG index > pquery parameters [149339,TT84855,0,,,Open,,,0,0,0,[Fail2Ban] SSH-issabel: banned 188.87.199.55 from localhost,,1,0]
2020-05-04T15:35:23-03:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_troubletickets(ticketid,ticket_no,parent_id,priority,severity,status,category,update_log,hours,days,from_portal,title,solution,from_mailscanner,commentadded) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1452]Cannot add or update a child row: a foreign key constraint fails (`NossoCRM`.`vtiger_troubletickets`, CONSTRAINT `fk_1_vtiger_troubletickets` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_crmentity` (`crmid`) ON DELETE CASCADE)
2020-05-04T15:35:23-03:00 DEBUG index > insertIntoEntityTable HelpDesk vtiger_ticketcf
2020-05-04T15:35:23-03:00 DEBUG index > getTabid HelpDesk
2020-05-04T15:35:23-03:00 DEBUG index < getTabid

020-05-04T15:35:23-03:00 DEBUG index > pquery insert into vtiger_ticketcf(ticketid,cf_748,cf_752,cf_785,cf_787,cf_788,cf_1075) values(?,?,?,?,?,?,?)
2020-05-04T15:35:23-03:00 DEBUG index > pquery parameters [149339,0,,0,,,0]
2020-05-04T15:35:23-03:00 INFO DB DB >ADODB error Query Failed:insert into vtiger_ticketcf(ticketid,cf_748,cf_752,cf_785,cf_787,cf_788,cf_1075) values(?,?,?,?,?,?,?)::->[1452]Cannot add or update a child row: a foreign key constraint fails (`NossoCRM`.`vtiger_ticketcf`, CONSTRAINT `fk_1_vtiger_ticketcf` FOREIGN KEY (`ticketid`) REFERENCES `vtiger_troubletickets` (`ticketid`) ON DELETE CASCADE)
2020-05-04T15:35:23-03:00 DEBUG index > insertIntoTicketCommentTable
2020-05-04T15:35:23-03:00 DEBUG index < insertIntoTicketCommentTable
2020-05-04T15:35:23-03:00 INFO DB DB >TRANS Rolled Back
2020-05-04T15:35:23-03:00 INFO DB DB >TRANS Completed
Ranieri
eCRM Web
Reply


Messages In This Thread
RE: issue for mail converter - joebordes - 05-03-2020, 05:35 PM
RE: issue for mail converter - rslemer - 05-04-2020, 07:03 PM
RE: issue for mail converter - joebordes - 05-04-2020, 09:07 PM
RE: issue for mail converter - rslemer - 05-04-2020, 10:35 PM
RE: issue for mail converter - joebordes - 05-04-2020, 11:11 PM
RE: issue for mail converter - rslemer - 05-05-2020, 04:38 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)