-- MySQL dump 9.11 -- -- Host: localhost Database: demo_pd -- ------------------------------------------------------ -- Server version 4.0.27-standard -- -- Table structure for table `perlDesk_accesslog` -- CREATE TABLE perlDesk_accesslog ( id int(11) unsigned NOT NULL auto_increment, user varchar(255) default NULL, ip varchar(255) default NULL, time varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_accesslog` -- INSERT INTO perlDesk_accesslog VALUES (1,'demo','81.157.47.160','1163760695'); INSERT INTO perlDesk_accesslog VALUES (2,'test','61.17.200.73','1197977206'); INSERT INTO perlDesk_accesslog VALUES (3,'gggggg','38.104.28.6','1197990846'); INSERT INTO perlDesk_accesslog VALUES (4,'demo','65.222.95.3','1197997643'); INSERT INTO perlDesk_accesslog VALUES (5,'demo','24.119.60.94','1198000846'); INSERT INTO perlDesk_accesslog VALUES (6,'demo','72.54.148.246','1198003006'); INSERT INTO perlDesk_accesslog VALUES (7,'demo','74.4.20.42','1198006399'); INSERT INTO perlDesk_accesslog VALUES (8,'demo','138.89.101.132','1198009349'); INSERT INTO perlDesk_accesslog VALUES (9,'demo','222.127.250.150','1198016956'); INSERT INTO perlDesk_accesslog VALUES (10,'demo','62.68.201.78','1198017924'); INSERT INTO perlDesk_accesslog VALUES (11,'demo','75.72.229.212','1198040272'); INSERT INTO perlDesk_accesslog VALUES (12,'demo','217.20.18.2','1198061100'); INSERT INTO perlDesk_accesslog VALUES (13,'demo','79.212.200.83','1198061435'); INSERT INTO perlDesk_accesslog VALUES (14,'demo','217.155.45.209','1198063326'); INSERT INTO perlDesk_accesslog VALUES (15,'demo','195.3.110.90','1198077931'); INSERT INTO perlDesk_accesslog VALUES (16,'demo','205.161.244.62','1198082914'); -- -- Table structure for table `perlDesk_activitylog` -- CREATE TABLE perlDesk_activitylog ( id int(11) unsigned NOT NULL auto_increment, cid varchar(255) NOT NULL default '', date varchar(255) NOT NULL default '', user varchar(255) NOT NULL default '', action varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_activitylog` -- INSERT INTO perlDesk_activitylog VALUES (1,'1','17-11-2006-04:46','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (2,'2','17-11-2006-04:52','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (3,'3','17-11-2006-04:53','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (4,'4','17-11-2006-04:56','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (5,'4','17-11-2006-04:59','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (6,'5','17-11-2006-05:08','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (7,'6','17-11-2006-05:13','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (8,'7','18-9-2007-12:30','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (9,'8','30-11-2007-10:26','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (10,'9','30-11-2007-10:27','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (11,'10','30-11-2007-10:29','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (12,'11','30-11-2007-10:32','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (13,'1','30-11-2007-11:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (14,'6','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (15,'3','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (16,'2','7-12-2007-00:04','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (17,'12','7-12-2007-00:06','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (18,'13','7-12-2007-00:06','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (19,'14','7-12-2007-00:08','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (20,'15','7-12-2007-00:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (21,'16','18-12-2007-05:54','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (22,'17','18-12-2007-07:47','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (23,'18','18-12-2007-09:13','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (24,'19','18-12-2007-09:14','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (25,'19','18-12-2007-09:15','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (26,'20','18-12-2007-09:42','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (27,'13','18-12-2007-11:14','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (28,'21','18-12-2007-11:59','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (29,'21','18-12-2007-12:04','Staff staff','Request Assigned Internal (Supportstaff)'); INSERT INTO perlDesk_activitylog VALUES (30,'17','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (31,'17','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (32,'18','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (33,'18','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (34,'20','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (35,'20','18-12-2007-12:05','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (36,'21','18-12-2007-12:07','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (37,'21','18-12-2007-12:07','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (38,'19','18-12-2007-12:12','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (39,'12','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (40,'13','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (41,'14','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (42,'15','18-12-2007-12:13','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (43,'16','18-12-2007-12:13','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (44,'22','18-12-2007-13:00','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (45,'23','18-12-2007-13:31','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (46,'22','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (47,'22','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (48,'23','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (49,'23','18-12-2007-14:29','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (50,'24','18-12-2007-16:45','User','Request Logged'); INSERT INTO perlDesk_activitylog VALUES (51,'24','18-12-2007-22:05','Staff staff','Request Assigned Internal (Supporthelpme)'); INSERT INTO perlDesk_activitylog VALUES (52,'25','19-12-2007-02:29','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (53,'26','19-12-2007-04:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (54,'27','19-12-2007-04:22','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (55,'28','19-12-2007-05:33','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (56,'25','19-12-2007-06:12','Staff: staff','Status Changed: CLOSED'); INSERT INTO perlDesk_activitylog VALUES (57,'29','19-12-2007-08:45','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (58,'29','19-12-2007-08:46','Staff: staff','Status Changed: HOLD'); INSERT INTO perlDesk_activitylog VALUES (59,'29','19-12-2007-08:54','Staff: staff','staff Claimed Ownership'); INSERT INTO perlDesk_activitylog VALUES (60,'29','19-12-2007-08:57','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (61,'29','19-12-2007-08:57','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (62,'30','19-12-2007-09:14','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (63,'15','19-12-2007-11:01','Staff staff','Request Assigned Internal (Supportstaff)'); INSERT INTO perlDesk_activitylog VALUES (64,'31','19-12-2007-12:18','User','Request(by email) Logged'); INSERT INTO perlDesk_activitylog VALUES (65,'26','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (66,'27','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (67,'27','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (68,'28','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (69,'28','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (70,'30','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (71,'30','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (72,'31','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (73,'31','19-12-2007-12:50','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (74,'25','19-12-2007-12:51','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (75,'25','19-12-2007-12:51','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (76,'17','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (77,'18','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (78,'20','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (79,'22','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (80,'25','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (81,'27','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (82,'28','19-12-2007-12:52','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (83,'30','19-12-2007-12:53','Staff: staff','Status Changed: DELETED'); INSERT INTO perlDesk_activitylog VALUES (84,'31','19-12-2007-12:53','Staff: staff','Status Changed: DELETED'); -- -- Table structure for table `perlDesk_announce` -- CREATE TABLE perlDesk_announce ( id int(11) unsigned NOT NULL auto_increment, author varchar(255) default NULL, subject varchar(255) default NULL, message text, staff char(1) default NULL, users char(1) default NULL, time varchar(16) default NULL, display_until varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_announce` -- INSERT INTO perlDesk_announce VALUES (1,'admin','Example news posting','This is great!!!!\r
','0','1','17-11-2006-04:58',NULL); INSERT INTO perlDesk_announce VALUES (2,'admin','Example Announcement','This is an example announcement posted by the administrator!','1','','30-11-2007-11:14',NULL); -- -- Table structure for table `perlDesk_blocked_email` -- CREATE TABLE perlDesk_blocked_email ( id int(11) unsigned NOT NULL auto_increment, address varchar(255) NOT NULL default '', type varchar(255) NOT NULL default '', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_blocked_email` -- -- -- Table structure for table `perlDesk_call_fields` -- CREATE TABLE perlDesk_call_fields ( id int(11) unsigned NOT NULL auto_increment, cid varchar(255) default NULL, fid varchar(255) default NULL, value text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_call_fields` -- INSERT INTO perlDesk_call_fields VALUES (1,'2','1','demo'); INSERT INTO perlDesk_call_fields VALUES (2,'3','1','demo'); INSERT INTO perlDesk_call_fields VALUES (3,'4','1','demo'); INSERT INTO perlDesk_call_fields VALUES (4,'5','1','wqeq'); INSERT INTO perlDesk_call_fields VALUES (5,'8','1',''); INSERT INTO perlDesk_call_fields VALUES (6,'9','1',''); INSERT INTO perlDesk_call_fields VALUES (7,'19','1','g'); INSERT INTO perlDesk_call_fields VALUES (8,'24','1','bedford'); -- -- Table structure for table `perlDesk_callrules` -- CREATE TABLE perlDesk_callrules ( id int(11) unsigned NOT NULL auto_increment, rule int(11) NOT NULL default '0', type text, value text, param text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_callrules` -- INSERT INTO perlDesk_callrules VALUES (1,1170894417,'match','department','Support'); INSERT INTO perlDesk_callrules VALUES (2,1170894417,'match','unanswered','24'); INSERT INTO perlDesk_callrules VALUES (3,1170894417,'action','notifyowner','on'); -- -- Table structure for table `perlDesk_calls` -- CREATE TABLE perlDesk_calls ( id int(11) unsigned NOT NULL auto_increment, status enum('OPEN','CLOSED','HOLD','DELETED') NOT NULL default 'OPEN', username varchar(30) default NULL, email varchar(255) default NULL, priority char(1) default NULL, category varchar(255) default NULL, subject varchar(255) default NULL, description text, time varchar(20) default NULL, ownership varchar(255) default NULL, closedby varchar(255) default NULL, method char(2) default NULL, track varchar(50) NOT NULL default '', active varchar(50) NOT NULL default '', aw char(1) default NULL, an char(1) NOT NULL default '', time_spent varchar(255) NOT NULL default '', sub_status text, is_locked int(11) NOT NULL default '0', ikey varchar(255) NOT NULL default '', close_timer int(11) default NULL, lock_time int(11) default NULL, due_date datetime default NULL, color varchar(255) default NULL, PRIMARY KEY (id), KEY status (status) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_calls` -- INSERT INTO perlDesk_calls VALUES (1,'CLOSED','Unregistered','j.bennett@logicnow.com','3','1','Example Emailed Ticket','This is an example ticket sent to perldesk@logicdemo.com which is setup \nto go into the Support department.\n\nperldesk2@logicdemo.com is setup to go to the Billing Department..\n\ngive it a try!\n\n\n','17-11-2006-04:46','Unowned','staff','em','1163760404','1163760404','1','1','0',NULL,0,'A5SOprAX3y',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (2,'CLOSED','demo','demo@perldesk.com','3','1','Printer Problems','Hi\r\n\r\nI am having trouble with my printer, it keeps getting stuck and jamming.\r\n\r\nAny help?','17-11-2006-04:52','Unowned','staff','hd','1163760730','1163761384','1','1','0',NULL,0,'mCM9kohDaM',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (3,'CLOSED','demo','demo@perldesk.com','3','2','Billing Problem','Hi\r\n\r\nI have been double billed for September, please check this!\r\n\r\nThanks','17-11-2006-04:53','Unowned','staff','hd','1163760808','1163761420','1','1','0',NULL,2,'ygFaf2Cqse',NULL,1163761447,NULL,NULL); INSERT INTO perlDesk_calls VALUES (4,'DELETED','demo','demo@perldesk.com','3','2','Billing Problem','Hi\r\n\r\nI have been double billed for September, please check this!\r\n\r\nThanks','17-11-2006-04:56','Unowned',NULL,'hd','1163761005','1163761005','1','0','0',NULL,0,'stD377gn20',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (6,'CLOSED','Unregistered','j.bennett@logicnow.com','3','2','test','test\n\n','17-11-2006-05:13','Unowned','staff','em','1163761985','1163762060','0','1','0',NULL,0,'jsbleXt3Id',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (12,'CLOSED','Unregistered','j.bennett@logicnow.com','1','1','Example Emailed Ticket\n','This is an example of a ticket created from an email, try it yourself! \nSend an email to perldesk@logicdemo.com and it will be picked up by this \ninstallation. You can then test the response and management of your own \nticket via the PerlDesk interface.\n\nEmail integration works by POP3 (like a normal mail client) or via email \npiping if you are using a Linux based OS.\n\n\n\n','7-12-2007-00:06','','staff','em','1197007579','1197007834','0','1','0','CREATED',0,'hmIgVEnt1d',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (13,'CLOSED','Unregistered','j.bennett@logicnow.com','2','1','Printer is not working\n','I am having trouble with my printer...\n\n','7-12-2007-00:06','staff','staff','em','1197007610','1197992258','0','1','0','CREATED',2,'WbLuJoJRsJ',1198597058,1197992290,'2007-12-18 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (14,'CLOSED','Unregistered','j.bennett@logicnow.com','3','1','Domain not resolving\n','Another example ticket.\n\nUsing the ticket management interface you can assign a ticket to other \nstaff by clicking the 'Assign' button, alternatively you can respond and \nmanage it yourself. Once resolved, you can mark the ticket as CLOSED and \nit will be removed from the Unresolved listing, and archived in the \nResolved responses.\n\n\n\n\n\n','7-12-2007-00:08','','staff','em','1197007700','1197007700','1','1','0','CREATED',2,'05nSGJ8sXd',NULL,1197992250,NULL,NULL); INSERT INTO perlDesk_calls VALUES (15,'HOLD','Unregistered','j.bennett@logicnow.com','3','1','THIS DEMO IS RESET EVERY HOUR\n','Please note during testing that this demonstration install is reset \nhourly and test data is removed.\n\n\n\n','7-12-2007-00:14','staff',NULL,'em','1197008092','1197008092','1','0','0','CREATED',2,'gRWewXCQhe',NULL,1198070197,NULL,NULL); INSERT INTO perlDesk_calls VALUES (16,'CLOSED','Unregistered','logicnow@gmail.com','3','1','test\n','test\n\n-- \n-- \nJohn Bennett\nManaging Director\nLogicNow Limited\n','18-12-2007-05:54','','staff','em','1197978860','1197978860','1','1','0','CREATED',2,'vP7ZHUpYnn',NULL,1197987865,NULL,NULL); INSERT INTO perlDesk_calls VALUES (19,'DELETED','gggggg','g@mail.com','3','2','New Ticket','what can I see as a customer','18-12-2007-09:14','staff',NULL,'hd','1197990875','1198001815','1','0','0','CREATED',0,'NOPATR',1198606270,0,'2007-12-18 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (21,'CLOSED','Unregistered','ChrisC@palacecasinoresort.com','3','1','printer\n','The printer on pc043 isn\'t working again.\r\n\r\n \r\n\r\nChristopher M. Carus\r\n\r\nDirector of MIS\r\n\r\nPalace Casino Resort\r\n\r\n228-386-2148\r\n\r\n\r\n\r\n**********************************************************************\r\nThis email and any files transmitted with it are confidential and \r\nintended solely for the use of the individual or entity to whom they \r\nare addressed. If you have received this email in error please \r\nreply to the sender of the message and or remove it from any and\r\nall systems it may have been received on. This footnote also confirms that this email message has been \r\nscanned for the presence of computer viruses.\r\n**********************************************************************\r\n\n\n[ Call last edited by staff: 18-12-2007-12:08 ]','18-12-2007-11:59','staff','staff','em','1198000770','1198001208','0','1','0','CREATED',0,'4x4bMk3c1c',NULL,NULL,NULL,NULL); INSERT INTO perlDesk_calls VALUES (29,'DELETED','Unregistered','jimkos@gmail.com','4','1','Hello\n','Hello again---\n\nthis is a TEST\n\n','19-12-2007-08:45','staff',NULL,'em','1198075526','1198075654','0','0','0','CREATED',2,'MQ8HXh4w7I',1198680454,1198075781,'2007-12-19 23:59:59',NULL); INSERT INTO perlDesk_calls VALUES (24,'OPEN','demo','demo@perldesk.com','3','1','test','test','18-12-2007-16:45','helpme',NULL,'hd','1198017950','1198017950','1','0','0','CREATED',0,'XLWHTD',NULL,NULL,NULL,NULL); -- -- Table structure for table `perlDesk_chat` -- CREATE TABLE perlDesk_chat ( id int(11) unsigned NOT NULL auto_increment, session_id int(11) unsigned default NULL, time timestamp(14) NOT NULL, username varchar(30) default NULL, staffname varchar(20) default NULL, department varchar(255) default NULL, direction int(11) NOT NULL default '0', type int(11) NOT NULL default '0', status int(11) NOT NULL default '0', message text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_chat` -- INSERT INTO perlDesk_chat VALUES (1,1,20061117051015,'demo',NULL,'Billing',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (2,1,20061117051022,'demo','staff','Billing',1,1,0,'chat request accepted'); INSERT INTO perlDesk_chat VALUES (3,1,20061117051024,'demo','staff','Billing',1,0,0,'hi demo\n'); INSERT INTO perlDesk_chat VALUES (4,1,20061117051032,'demo','staff','Billing',0,0,0,'hi\n'); INSERT INTO perlDesk_chat VALUES (5,1,20061117051039,'demo','staff','Billing',1,0,0,'how are you?\n'); INSERT INTO perlDesk_chat VALUES (6,1,20061117051047,'demo','staff','Billing',0,0,0,'good, you?\n'); INSERT INTO perlDesk_chat VALUES (7,1,20061117051054,'demo','staff','Billing',0,0,0,'good\n'); INSERT INTO perlDesk_chat VALUES (8,1,20061117051059,'demo','staff','Billing',0,0,0,'.\n'); INSERT INTO perlDesk_chat VALUES (9,1,20061117051105,'demo','staff','Billing',0,0,0,'.\n'); INSERT INTO perlDesk_chat VALUES (10,1,20061117051114,'demo','staff','Billing',1,0,0,'go away\n'); INSERT INTO perlDesk_chat VALUES (11,1,20061117051120,'demo','staff','Billing',0,0,0,'ok\n'); INSERT INTO perlDesk_chat VALUES (12,1,20061117051125,'demo','staff','Billing',1,1,0,'Session closed by staff'); INSERT INTO perlDesk_chat VALUES (13,2,20071218071136,'guest58701',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (14,2,20071218071158,'guest58701',NULL,'Support',0,0,0,'HELLO\r\n'); INSERT INTO perlDesk_chat VALUES (15,2,20071218071234,'guest58701',NULL,'Support',0,0,0,'ARE YOU STILL THERE\r\n'); INSERT INTO perlDesk_chat VALUES (16,2,20071218071236,'guest58701',NULL,'Support',0,1,0,'chat request canceled by timeout'); INSERT INTO perlDesk_chat VALUES (17,3,20071218115208,'guest15477',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (18,3,20071218115214,'guest15477',NULL,'Support',0,0,0,'hi ..\n'); INSERT INTO perlDesk_chat VALUES (19,3,20071218115222,'guest15477',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (20,4,20071218124123,'guest34626',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (21,4,20071218125627,'guest34626',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (22,5,20071218132350,'guest74145',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (23,5,20071218133856,'guest74145',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (24,6,20071218153450,'guest97142',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (25,6,20071218153454,'guest97142',NULL,'Support',0,0,0,'hi\r\n'); INSERT INTO perlDesk_chat VALUES (26,7,20071218160959,'guest82347',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (27,7,20071218161008,'guest82347',NULL,'Support',0,0,0,'test\n'); INSERT INTO perlDesk_chat VALUES (28,7,20071218161011,'guest82347',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (29,6,20071218161100,'guest97142',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (30,8,20071218203632,'guest92486',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (31,8,20071218210541,'guest92486',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); INSERT INTO perlDesk_chat VALUES (32,9,20071219000634,'guest42789',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (33,9,20071219000641,'guest42789',NULL,'Support',0,1,0,'chat request canceled by user'); INSERT INTO perlDesk_chat VALUES (34,10,20071219111006,'guest95926',NULL,'Support',0,1,0,'requesting chat'); INSERT INTO perlDesk_chat VALUES (35,10,20071219114131,'guest95926',NULL,'Support',1,1,0,'Session closed by inactivity timeout'); -- -- Table structure for table `perlDesk_chatsession` -- CREATE TABLE perlDesk_chatsession ( id int(11) unsigned NOT NULL auto_increment, time timestamp(14) NOT NULL, activity timestamp(14) NOT NULL default '00000000000000', username varchar(30) default NULL, staffname varchar(20) default NULL, department varchar(255) default NULL, state text, message text, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_chatsession` -- INSERT INTO perlDesk_chatsession VALUES (1,20061117051015,20061117051131,'demo','staff','Billing','close','session closed by staff'); INSERT INTO perlDesk_chatsession VALUES (2,20071218071136,20071218071236,'guest58701',NULL,'Support','cancel','chat request canceled by timeout'); INSERT INTO perlDesk_chatsession VALUES (3,20071218115208,20071218115222,'guest15477',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (4,20071218124123,20071218124123,'guest34626',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (5,20071218132350,20071218132350,'guest74145',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (6,20071218153450,20071218153454,'guest97142',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (7,20071218160959,20071218161011,'guest82347',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (8,20071218203632,20071218203632,'guest92486',NULL,'Support','closing','session closed (inactivity timeout)'); INSERT INTO perlDesk_chatsession VALUES (9,20071219000634,20071219000641,'guest42789',NULL,'Support','cancel','chat request canceled by user'); INSERT INTO perlDesk_chatsession VALUES (10,20071219111006,20071219111006,'guest95926',NULL,'Support','closing','session closed (inactivity timeout)'); -- -- Table structure for table `perlDesk_contacts` -- CREATE TABLE perlDesk_contacts ( id int(11) unsigned NOT NULL auto_increment, staff int(11) NOT NULL default '0', name varchar(50) NOT NULL default '', company varchar(50) NOT NULL default '', address varchar(255) NOT NULL default '', email varchar(90) NOT NULL default '', phone varchar(19) default NULL, url varchar(90) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_contacts` -- -- -- Table structure for table `perlDesk_cronrules` -- CREATE TABLE perlDesk_cronrules ( id int(11) unsigned NOT NULL auto_increment, period int(11) NOT NULL default '0', action text, lastrun int(11) NOT NULL default '0', lastcheck int(11) NOT NULL default '0', PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_cronrules` -- INSERT INTO perlDesk_cronrules VALUES (1,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (2,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (3,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (4,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (5,1800,'check_calls',0,0); INSERT INTO perlDesk_cronrules VALUES (6,1800,'check_calls',0,0); -- -- Table structure for table `perlDesk_debug` -- CREATE TABLE perlDesk_debug ( id int(11) unsigned NOT NULL auto_increment, time timestamp(14) NOT NULL, priority varchar(10) default NULL, category varchar(25) default NULL, file varchar(50) default NULL, function varchar(50) default NULL, message varchar(255) default NULL, PRIMARY KEY (id) ) TYPE=MyISAM; -- -- Dumping data for table `perlDesk_debug` -- INSERT INTO perlDesk_debug VALUES (1,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_db_level missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (2,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_stderr_level missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (3,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_directory missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (4,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_debug_file missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (5,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mail_file missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (6,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mailin missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (7,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_mailout missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (8,20071212154332,'WARN','PerlDesk.App','lib/PerlDesk/App.pm:385','PerlDesk::App::config_update_setting','setting log_fatal_mail missed in table settings_extra'); INSERT INTO perlDesk_debug VALUES (9,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (10,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Test ticket'); INSERT INTO perlDesk_debug VALUES (11,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (12,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: zmeizz@gmail.com'); INSERT INTO perlDesk_debug VALUES (13,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"perldesk@logicdemo.com\" '); INSERT INTO perlDesk_debug VALUES (14,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (15,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: zmeizz@gmail.com with subject \'{100-16} Test ticket\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (16,20071212155201,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (17,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (18,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Test 2 ticket'); INSERT INTO perlDesk_debug VALUES (19,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (20,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: zmeizz@gmail.com'); INSERT INTO perlDesk_debug VALUES (21,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (22,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (23,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: zmeizz@gmail.com with subject \'{100-17} Test 2 ticket\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (24,20071212155234,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (25,20071212155802,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: zmeizz@gmail.com with subject \'{100-16} RE: Test ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (26,20071212155802,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (27,20071212161332,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (28,20071212161333,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (29,20071212161333,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa12012c)\', \'P'); INSERT INTO perlDesk_debug VALUES (30,20071212161333,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'register2\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (31,20071212161449,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'{100-16} Cos tam cos tam\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (32,20071212161449,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (33,20071212161449,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa67998c)\', \'P'); INSERT INTO perlDesk_debug VALUES (34,20071212161449,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (35,20071212161639,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: alhena@alhena.poznan.pl with subject \'{100-16} RE: Cos tam cos tam\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (36,20071212161639,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (37,20071212161639,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x95da480)\', \'P'); INSERT INTO perlDesk_debug VALUES (38,20071212161639,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'addnote\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at ajax.cgi line 19\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::Aja'); INSERT INTO perlDesk_debug VALUES (39,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (40,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test 5'); INSERT INTO perlDesk_debug VALUES (41,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (42,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: mbhatt@capitalc.ca'); INSERT INTO perlDesk_debug VALUES (43,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (44,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (45,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: mbhatt@capitalc.ca with subject \'{100-17} test 5\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (46,20071212163019,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (47,20071212163809,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: syt2212@mobyportal.com with subject \'{100-18} red wing slipper socks\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (48,20071212163809,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (49,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (50,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: HW: DILBERT - Printer is making knocking sounds'); INSERT INTO perlDesk_debug VALUES (51,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (52,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jodonnell@mhalaw.com'); INSERT INTO perlDesk_debug VALUES (53,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (54,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 19'); INSERT INTO perlDesk_debug VALUES (55,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: jodonnell@mhalaw.com with subject \'{100-19} HW: DILBERT - Printer is making knocking sounds\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (56,20071212164448,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (57,20071212164632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #19 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (58,20071212164632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (59,20071212164730,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: jodonnell@mhalaw.com with subject \'{100-19} RE: HW: DILBERT - Printer is making knocking sounds\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (60,20071212164730,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (61,20071212170551,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #1 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (62,20071212170551,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (63,20071212170551,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8f3acb8)\', \'P'); INSERT INTO perlDesk_debug VALUES (64,20071212170551,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'movedep\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at staff.cgi line 31\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App::St'); INSERT INTO perlDesk_debug VALUES (65,20071212172914,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: fartoviy12345@mail.ru with subject \'{100-16} New super Sites\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (66,20071212172914,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (67,20071212172914,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa28b99c)\', \'P'); INSERT INTO perlDesk_debug VALUES (68,20071212172914,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (69,20071212172938,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dasinonus@dasinonus.com with subject \'{100-17} Casino Bonus\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (70,20071212172938,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (71,20071212172938,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9be769c)\', \'P'); INSERT INTO perlDesk_debug VALUES (72,20071212172938,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (73,20071212180429,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: meryacure@mymail-in.net with subject \'{100-16} A bukkake gallery on this one \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (74,20071212180429,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (75,20071212180429,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa1d349c)\', \'P'); INSERT INTO perlDesk_debug VALUES (76,20071212180429,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (77,20071212180444,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: erafiterric@mymail-in.net with subject \'{100-17} A redhead in school uniforms \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (78,20071212180444,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (79,20071212180444,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa877bbc)\', \'P'); INSERT INTO perlDesk_debug VALUES (80,20071212180444,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (81,20071212180452,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: noissuslybymn@mymail-in.net with subject \'{100-18} A pregnant girl blowing two friends \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (82,20071212180452,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (83,20071212180452,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9e55a64)\', \'P'); INSERT INTO perlDesk_debug VALUES (84,20071212180452,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (85,20071212180504,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: honsgogyhok@mymail-in.net with subject \'{100-19} Girls toying and fingering \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (86,20071212180504,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (87,20071212180504,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8b49c3c)\', \'P'); INSERT INTO perlDesk_debug VALUES (88,20071212180504,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (89,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (90,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Where have you been?'); INSERT INTO perlDesk_debug VALUES (91,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <01c83d63$87d50380$6ab58dd3@a-alcher>'); INSERT INTO perlDesk_debug VALUES (92,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: a-alcher@abinanti.com'); INSERT INTO perlDesk_debug VALUES (93,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (94,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 20'); INSERT INTO perlDesk_debug VALUES (95,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: a-alcher@abinanti.com with subject \'{100-20} {Spam?} Where have you been?\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (96,20071212181044,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (97,20071212183839,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dogswregade@mymail-in.net with subject \'{100-21} A busty girl in the bathroom \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (98,20071212183839,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (99,20071212184526,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: 848ut@was.com with subject \'{100-22} buy cialis online viagra\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (100,20071212184526,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (101,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (102,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: (no subject)'); INSERT INTO perlDesk_debug VALUES (103,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (104,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: Khalif926@aol.com'); INSERT INTO perlDesk_debug VALUES (105,20071212204142,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (106,20071212204142,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 87.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n '); INSERT INTO perlDesk_debug VALUES (107,20071212205923,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: dest142@mobyportal.com with subject \'{100-17} sony ericsson mobile accessory, accessory cell dash mobile phone t\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (108,20071212205923,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (109,20071212210953,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: b3@twiins.cn with subject \'{100-16} hairy amateur teens super hairy girls \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (110,20071212210953,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (111,20071212210953,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa7efb7c)\', \'P'); INSERT INTO perlDesk_debug VALUES (112,20071212210953,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (113,20071212212943,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (114,20071212212943,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (115,20071212223851,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: b1@twiins.cn with subject \'{100-16} nylon fetish groups on yahoo a lady in nylon stocking \' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (116,20071212223851,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (117,20071212223851,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8ff2580)\', \'P'); INSERT INTO perlDesk_debug VALUES (118,20071212223851,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (119,20071212223956,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: adsad@ww.de with subject \'{100-17} sdaad\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (120,20071212223956,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (121,20071212235353,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: francesca@onlymail.ru with subject \'{100-16} Girls with onion booties\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (122,20071212235353,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (123,20071213000830,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'lpass〈=en\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0xa1a9dc0)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (124,20071213001205,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: montreal@epage.ru with subject \'{100-16} Charlie Laine 481 pics\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (125,20071213001205,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (126,20071213001205,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa52544c)\', \'P'); INSERT INTO perlDesk_debug VALUES (127,20071213001205,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (128,20071213002657,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: demo@perldesk.com with subject \'{100-17} BUG\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (129,20071213002657,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (130,20071213002657,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x9b909a8)\', \'P'); INSERT INTO perlDesk_debug VALUES (131,20071213002657,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (132,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (133,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} {Disarmed} [IstanbulGeziKulubu] Kurban Bayramý Ozel : 20-23 Aralýk Marmaris Dalyan Datca 4 Gun 3 Gece Full Eglence ve Doga Gezisi'); INSERT INTO perlDesk_debug VALUES (134,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <159551.67915.qm@web50302.mail.re2.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (135,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: caglayang@yahoo.com'); INSERT INTO perlDesk_debug VALUES (136,20071213022856,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: izmirgezikulubu@yahoogroups.com'); INSERT INTO perlDesk_debug VALUES (137,20071213022856,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 482.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (138,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (139,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Disarmed} [IstanbulGeziKulubu] Izmir Gezi Kulubu Marmariste Istanbul Gezi Kulubu uyeleriyle beraber 3 Gece 4 Gun Muhtesem Gezide'); INSERT INTO perlDesk_debug VALUES (140,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <454795.98340.qm@web50301.mail.re2.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (141,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: caglayang@yahoo.com'); INSERT INTO perlDesk_debug VALUES (142,20071213031901,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: izmirgezikulubu@yahoogroups.com,\n Istanbulgezikulubu Kulubu '); INSERT INTO perlDesk_debug VALUES (143,20071213031901,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 438.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (144,20071213040255,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-16} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (145,20071213040257,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (146,20071213040257,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x8a21954)\', \'P'); INSERT INTO perlDesk_debug VALUES (147,20071213040257,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (148,20071213040317,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-17} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (149,20071213040317,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (150,20071213040317,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa63c9bc)\', \'P'); INSERT INTO perlDesk_debug VALUES (151,20071213040317,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (152,20071213040344,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: test@ermite.com with subject \'{100-18} Big problem\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (153,20071213040347,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (154,20071213040347,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x93b09bc)\', \'P'); INSERT INTO perlDesk_debug VALUES (155,20071213040347,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (156,20071213045503,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x98c5c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (157,20071213045710,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9abbda4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (158,20071213051745,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8d06da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (159,20071213051919,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9914da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (160,20071213052120,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x9766da4)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (161,20071213054538,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8dd0c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (162,20071213055223,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: nataliaor@fromru.com with subject \'{100-16} 001 Tramadol New TraMADOL Pillrun Number One Nextday Best Tramadol Pharmacy Go Cheaps Tramadol Casino Fioricet Search Engine Carisoprodol'); INSERT INTO perlDesk_debug VALUES (163,20071213055224,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (164,20071213061143,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: grapp@axigenmail.com with subject \'{100-16} Successo\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (165,20071213061144,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (166,20071213061144,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0x93985d4)\', \'P'); INSERT INTO perlDesk_debug VALUES (167,20071213061144,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (168,20071213061719,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x8d55c98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (169,20071213062621,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'http://www.heatherlynn.net/n.c?\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0x955cc98)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (170,20071213083048,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: bbntbbbn@mail.ru with subject \'{100-16} New and very cool\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (171,20071213083048,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (172,20071213083048,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at extlib/Class/PObject/Driver/mysql.pm line 112\n Class::PObject::Driver::mysql::save(\'Class::PObject::Driver::mysql=HASH(0xa2959e4)\', \'P'); INSERT INTO perlDesk_debug VALUES (173,20071213083048,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'submit_req\': DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at extlib/Class/PObject/Driver/mysql.pm line 112.\n at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (174,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (175,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Trackstick GPS device now available at Earth Products and Accessories'); INSERT INTO perlDesk_debug VALUES (176,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <20071213063910.2086414062@gearthstore.com>'); INSERT INTO perlDesk_debug VALUES (177,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: sales@gearthstore.com'); INSERT INTO perlDesk_debug VALUES (178,20071213084137,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (179,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (180,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: sales@gearthstore.com with subject \'{100-17} {Spam?} Trackstick GPS device now available at Earth Products and Accessories\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (181,20071213084138,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (182,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (183,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: dsfsdf'); INSERT INTO perlDesk_debug VALUES (184,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47614DEE.3020307@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (185,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (186,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (187,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (188,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} dsfsdf\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (189,20071213092343,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (190,20071213092503,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: wikes@toysrus.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (191,20071213092503,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (192,20071213093733,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (193,20071213093733,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (194,20071213093743,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (195,20071213093743,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (196,20071213094337,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #12 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (197,20071213094337,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (198,20071213094747,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} Request closed: Example Emailed Ticket\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (199,20071213094747,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (200,20071213095609,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (201,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} {Disarmed} [IstanbulGeziKulubu] Gezi : SULEYMANIYE - VEFA Tarih Kultur Gezisi 16 Aralýk Pazar ( Sevdiklerinizle ve Kulup uyeleriyle gunu anýya cevirin )'); INSERT INTO perlDesk_debug VALUES (202,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <899476.2639.qm@web38202.mail.mud.yahoo.com>'); INSERT INTO perlDesk_debug VALUES (203,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: travel.terminal@yahoo.com'); INSERT INTO perlDesk_debug VALUES (204,20071213095610,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: istanbulgezikulubu@yahoogroups.com, gezikulubu@yahoogroups.com'); INSERT INTO perlDesk_debug VALUES (205,20071213095610,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 501.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::'); INSERT INTO perlDesk_debug VALUES (206,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (207,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (208,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-14} Request closed: Domain not resolving\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (209,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (210,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-15} Request closed: THIS DEMO IS RESET EVERY HOUR\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (211,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (212,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-16} Request closed: dsfsdf\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (213,20071213095632,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (214,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (215,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} CIAL1S - From a pharmacy that believes in providing excellent services and the cheapest pr1ces'); INSERT INTO perlDesk_debug VALUES (216,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <000a01c83da1$043c88fa$03d9319f@ugghx>'); INSERT INTO perlDesk_debug VALUES (217,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: maryann73@nokia.com'); INSERT INTO perlDesk_debug VALUES (218,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (219,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (220,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: maryann73@nokia.com with subject \'{100-16} {Spam?} CIAL1S - From a pharmacy that believes in providing excellent services and the cheapest pr1ces\n\' using template \'user_newcall.email'); INSERT INTO perlDesk_debug VALUES (221,20071213100306,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (222,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (223,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Beat all the records with our new size'); INSERT INTO perlDesk_debug VALUES (224,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <430231021.16547119320493@ldneqt.eq.gs.com>'); INSERT INTO perlDesk_debug VALUES (225,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: tello@ldneqt.eq.gs.com'); INSERT INTO perlDesk_debug VALUES (226,20071213102337,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: staff@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (227,20071213102337,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 56.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (228,20071213102752,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (229,20071213102752,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (230,20071213102808,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (231,20071213102808,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (232,20071213110112,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','No such run mode \'submit_ticket〈\' at pdesk.cgi line 30\n at extlib/CGI/Application.pm line 142\n CGI::Application::run(\'PerlDesk::App::PDesk=HASH(0xa2b8cd8)\') called at pdesk.cgi line 30\n eval {...} called at pdesk.cgi line 24'); INSERT INTO perlDesk_debug VALUES (233,20071213110533,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (234,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Testing 3333'); INSERT INTO perlDesk_debug VALUES (235,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <98B56B44090B3247A97660D27D069C9C0553ECBC@hqexch1.hq.escription.com>'); INSERT INTO perlDesk_debug VALUES (236,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: george.peguero@escription.com'); INSERT INTO perlDesk_debug VALUES (237,20071213110534,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (238,20071213110534,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 179.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n'); INSERT INTO perlDesk_debug VALUES (239,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (240,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Paradise is here!'); INSERT INTO perlDesk_debug VALUES (241,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <59833.eung@tzuwang>'); INSERT INTO perlDesk_debug VALUES (242,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: jorgen@sfr.net'); INSERT INTO perlDesk_debug VALUES (243,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Gift of $2400\" '); INSERT INTO perlDesk_debug VALUES (244,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (245,20071213112045,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: jorgen@sfr.net with subject \'{100-17} {Spam?} Paradise is here!\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (246,20071213112046,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (247,20071213113035,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Quantifier follows nothing in regex; marked by <-- HERE in m/* <-- HERE / at lib/PerlDesk/App/Staff.pm line 2320.\n at lib/PerlDesk/App/Staff.pm line 2320\n PerlDesk::App::Staff::lookupresults(\'PerlDesk::App::Staff=HASH(0x886ef04)\') called at extlib/CGI/App'); INSERT INTO perlDesk_debug VALUES (248,20071213113035,'FATAL','','lib/PerlDesk/App.pm:150','PerlDesk::App::__ANON__','Error executing run mode \'lookupresults\': Quantifier follows nothing in regex; marked by <-- HERE in m/* <-- HERE / at lib/PerlDesk/App/Staff.pm line 2320.\n at staff.cgi line 31\n at extlib/CGI/Application.pm line 160\n CGI::Application::run(\'PerlDesk::App:'); INSERT INTO perlDesk_debug VALUES (249,20071213113107,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: demo@perldesk.com with subject \'{100-18} 235\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (250,20071213113107,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (251,20071213113157,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} RE: Example Emailed Ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (252,20071213113158,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (253,20071213114012,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (254,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (255,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <711D9C6F9602BC4F81121C4A0788AAA27A0B9C@exchgb1.dsa.reldom.tamu.edu>'); INSERT INTO perlDesk_debug VALUES (256,20071213114013,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: michaelh@housing.tamu.edu'); INSERT INTO perlDesk_debug VALUES (257,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (258,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 19'); INSERT INTO perlDesk_debug VALUES (259,20071213114014,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: michaelh@housing.tamu.edu with subject \'{100-19} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (260,20071213114015,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (261,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (262,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (263,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47616EDB.7060506@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (264,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (265,20071213114412,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (266,20071213114412,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 145.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n'); INSERT INTO perlDesk_debug VALUES (267,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (268,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: testing'); INSERT INTO perlDesk_debug VALUES (269,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <102D560E-1CCC-4AE0-8930-44DB484CFB65@airshift.tv>'); INSERT INTO perlDesk_debug VALUES (270,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: timo@airshift.tv'); INSERT INTO perlDesk_debug VALUES (271,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (272,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (273,20071213114515,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: timo@airshift.tv with subject \'{100-17} testing\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (274,20071213114516,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (275,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (276,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (277,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47617138.4010603@logicnow.com>'); INSERT INTO perlDesk_debug VALUES (278,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: j.bennett@logicnow.com'); INSERT INTO perlDesk_debug VALUES (279,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: Support '); INSERT INTO perlDesk_debug VALUES (280,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (281,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-18} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (282,20071213115418,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (283,20071213115614,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: demo@perldesk.com with subject \'{100-3} RE: Billing Problem\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (284,20071213115614,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (285,20071213115758,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #14 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (286,20071213115758,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (287,20071213115825,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (288,20071213115825,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (289,20071213115949,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: doldenkamp@baptist.edu with subject \'{100-19} test\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (290,20071213115949,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (291,20071213121943,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} RE: Example Emailed Ticket\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (292,20071213121943,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (293,20071213123425,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (294,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Êîäèðîâêà'); INSERT INTO perlDesk_debug VALUES (295,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <47617B1B.6060503@mail.ru>'); INSERT INTO perlDesk_debug VALUES (296,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: hard59@mail.ru'); INSERT INTO perlDesk_debug VALUES (297,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (298,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (299,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: hard59@mail.ru with subject \'{100-16} {Spam?} Êîäèðîâêà\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (300,20071213123426,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (301,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (302,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Trying'); INSERT INTO perlDesk_debug VALUES (303,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <02f001c83db7$62f2d4d0$1a00a8c0@hosted.intercity.cl>'); INSERT INTO perlDesk_debug VALUES (304,20071213123909,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: claudio@intercity.net'); INSERT INTO perlDesk_debug VALUES (305,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (306,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 17'); INSERT INTO perlDesk_debug VALUES (307,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: claudio@intercity.net with subject \'{100-17} Trying\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (308,20071213123910,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (309,20071213124535,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (310,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} aa'); INSERT INTO perlDesk_debug VALUES (311,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <021201c83db8$4884f910$d98eeb30$@net>'); INSERT INTO perlDesk_debug VALUES (312,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dave@totalpayroll.net'); INSERT INTO perlDesk_debug VALUES (313,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (314,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (315,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: dave@totalpayroll.net with subject \'{100-18} {Spam?} aa\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (316,20071213124536,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (317,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (318,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: (no subject)'); INSERT INTO perlDesk_debug VALUES (319,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (320,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: Khalif926@aol.com'); INSERT INTO perlDesk_debug VALUES (321,20071213125951,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (322,20071213125951,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','DBD::mysql::st execute failed: Unknown column \'to\' in \'field list\' at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112, line 72.\n at /home/demo/www/perldesk/include/../extlib/Class/PObject/Driver/mysql.pm line 112\n '); INSERT INTO perlDesk_debug VALUES (323,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (324,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?}'); INSERT INTO perlDesk_debug VALUES (325,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2E3A0BC3D750174DA91754F87FC77A64090B15@psserver1.pstech.local>'); INSERT INTO perlDesk_debug VALUES (326,20071213130116,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: peretz@pstechsolutions.com'); INSERT INTO perlDesk_debug VALUES (327,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (328,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (329,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: peretz@pstechsolutions.com with subject \'{100-16} {Spam?} \n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (330,20071213130117,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (331,20071218052634,'INFO','Mail','lib/PerlDesk/App.pm:1984','PerlDesk::App::send_email','Sending message From: \"Support\" To: a@a.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (332,20071218052635,'INFO','Mail','lib/PerlDesk/App.pm:2084','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (333,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (334,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (335,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <609362709.88637266281959@invivocom.com>'); INSERT INTO perlDesk_debug VALUES (336,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dorinvivocomsig@invivocom.com'); INSERT INTO perlDesk_debug VALUES (337,20071218054819,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (338,20071218054819,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 54.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (339,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (340,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Have a great night with your girlfriend!'); INSERT INTO perlDesk_debug VALUES (341,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <609362709.88637266281959@invivocom.com>'); INSERT INTO perlDesk_debug VALUES (342,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: dorinvivocomsig@invivocom.com'); INSERT INTO perlDesk_debug VALUES (343,20071218054820,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: nperldesk2@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (344,20071218054820,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 54.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (345,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (346,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: test'); INSERT INTO perlDesk_debug VALUES (347,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <9e7fbea90712180354o7489a7f3nd124b3669a09fc47@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (348,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: logicnow@gmail.com'); INSERT INTO perlDesk_debug VALUES (349,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (350,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 16'); INSERT INTO perlDesk_debug VALUES (351,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: logicnow@gmail.com with subject \'{100-16} test\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (352,20071218055420,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (353,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (354,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.'); INSERT INTO perlDesk_debug VALUES (355,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: SydneyoratoryCotton@rimmkaufman.com'); INSERT INTO perlDesk_debug VALUES (356,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: ,\n To: SydneyoratoryCotton@rimmkaufman.com with subject \'{100-17} {Spam?} Huge progressive jackpots, slots, multi-hand, and single-hand blackjack.\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (359,20071218074739,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (360,20071218084915,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (361,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} Get approved in 48 hours'); INSERT INTO perlDesk_debug VALUES (362,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (363,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: FrancesfeatherbrainValencia@maggienash.com'); INSERT INTO perlDesk_debug VALUES (364,20071218084916,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (365,20071218084916,'FATAL','','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::__ANON__','Can\'t locate object method \"warning\" via package \"Log::Log4perl::Logger\" at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824, line 96.\n at /home/demo/www/perldesk/include/../lib/PerlDesk/App/Email.pm line 824\n PerlDesk::App::E'); INSERT INTO perlDesk_debug VALUES (366,20071218091300,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (367,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} An example can be seen below.'); INSERT INTO perlDesk_debug VALUES (368,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <4767E367.5040608@evergreen.edu>'); INSERT INTO perlDesk_debug VALUES (369,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: hcwk@evergreen.edu'); INSERT INTO perlDesk_debug VALUES (370,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (371,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 18'); INSERT INTO perlDesk_debug VALUES (372,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: hcwk@evergreen.edu with subject \'{100-18} {Spam?} An example can be seen below.\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (373,20071218091301,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (374,20071218091403,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: g@mail.com with subject \'Help Desk Registration\' using template \'user_welcome.email\''); INSERT INTO perlDesk_debug VALUES (375,20071218091403,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (376,20071218091435,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} New Ticket\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (377,20071218091435,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (378,20071218091541,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (379,20071218091541,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (380,20071218091642,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (381,20071218091642,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (382,20071218093738,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} RE: Printer is not working\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (383,20071218093738,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (384,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (385,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: {Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"'); INSERT INTO perlDesk_debug VALUES (386,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <442044-2200712218151716656@totin>'); INSERT INTO perlDesk_debug VALUES (387,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: infoahex@ahex.cl'); INSERT INTO perlDesk_debug VALUES (388,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: perldesk@logicdemo.com'); INSERT INTO perlDesk_debug VALUES (389,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 20'); INSERT INTO perlDesk_debug VALUES (390,20071218094244,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: infoahex@ahex.cl with subject \'{100-20} {Spam?} "Sorprende a tu Pareja habitaciones desde $25.000/US$50.00 Hotel AHEX"\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (391,20071218094245,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (392,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (393,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Re: {100-19} New Ticket'); INSERT INTO perlDesk_debug VALUES (394,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2d7294850712180919o70c1e922g7e4b53ad8c5d600@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (395,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: g@mail.com'); INSERT INTO perlDesk_debug VALUES (396,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Billing Department\" '); INSERT INTO perlDesk_debug VALUES (397,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as note for call ID# 19'); INSERT INTO perlDesk_debug VALUES (398,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_newnote.email\''); INSERT INTO perlDesk_debug VALUES (399,20071218112004,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (400,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (401,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: printer'); INSERT INTO perlDesk_debug VALUES (402,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: '); INSERT INTO perlDesk_debug VALUES (403,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: ChrisC@palacecasinoresort.com'); INSERT INTO perlDesk_debug VALUES (404,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: '); INSERT INTO perlDesk_debug VALUES (405,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as call ID# 21'); INSERT INTO perlDesk_debug VALUES (406,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} printer\n\' using template \'user_newcall.email\''); INSERT INTO perlDesk_debug VALUES (407,20071218115930,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (408,20071218120453,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: john@logicdemo.com with subject \'Ticket #21 assigned to you\' using template \'staff_assign.email\''); INSERT INTO perlDesk_debug VALUES (409,20071218120453,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (410,20071218120648,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} RE: printer\n\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (411,20071218120648,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (412,20071218120751,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: ChrisC@palacecasinoresort.com with subject \'{100-21} Request closed: printer\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (413,20071218120751,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (414,20071218121110,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_response.email\''); INSERT INTO perlDesk_debug VALUES (415,20071218121110,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (416,20071218121302,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-12} Request closed: Example Emailed Ticket\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (417,20071218121302,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (418,20071218121311,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-13} Request closed: Printer is not working\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (419,20071218121312,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (420,20071218121330,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: j.bennett@logicnow.com with subject \'{100-14} Request closed: Domain not resolving\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (421,20071218121330,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (422,20071218121342,'INFO','Mail','lib/PerlDesk/App.pm:1994','PerlDesk::App::send_email','Sending message From: \"Support\" To: logicnow@gmail.com with subject \'{100-16} Request closed: test\n\' using template \'user_close.email\''); INSERT INTO perlDesk_debug VALUES (423,20071218121342,'INFO','Mail','lib/PerlDesk/App.pm:2094','PerlDesk::App::send_email','Message sent successfully'); INSERT INTO perlDesk_debug VALUES (424,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','start parsing message'); INSERT INTO perlDesk_debug VALUES (425,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Subject: Re: {100-19} RE: New Ticket'); INSERT INTO perlDesk_debug VALUES (426,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','Message-ID: <2d7294850712181016v4ae1aa10l14edfdf04a636999@mail.gmail.com>'); INSERT INTO perlDesk_debug VALUES (427,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','From: g@mail.com'); INSERT INTO perlDesk_debug VALUES (428,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','To: \"Billing Department\" '); INSERT INTO perlDesk_debug VALUES (429,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::Email::newrun','OK. Stored as note for call ID# 19'); INSERT INTO perlDesk_debug VALUES (430,20071218121655,'INFO','Mail','/home/demo/www/perldesk/include/../lib/PerlDesk/Ap','PerlDesk::App::send_email','Sending message From: \"Billing Department\" To: g@mail.com with subject \'{100-19} RE: New Ticket\' using template \'user_newnote.email\''); INSERT INTO perlDesk_debug VALUES (431,20071218121655,'INFO','Mail','/ho