Wed Jan 28 11:56:26 2009,519 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,519 [30647] INFO VT - Message ->getActionName 2 Wed Jan 28 11:56:26 2009,520 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,520 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,521 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,522 [30647] INFO VT - Message ->in getUserId 108 Wed Jan 28 11:56:26 2009,522 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 108 Wed Jan 28 11:56:26 2009,523 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,523 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='status' Wed Jan 28 11:56:26 2009,524 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,524 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='status' Wed Jan 28 11:56:26 2009,525 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,526 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,526 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,526 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,527 [30647] INFO VT - Message ->getActionName 1 Wed Jan 28 11:56:26 2009,527 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,527 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,528 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,529 [30647] INFO VT - Message ->in getUserId 150 Wed Jan 28 11:56:26 2009,529 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 150 Wed Jan 28 11:56:26 2009,529 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,530 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,530 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,531 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,531 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,532 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='activitytype' Wed Jan 28 11:56:26 2009,532 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,533 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,534 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,534 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,535 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,535 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='subject' Wed Jan 28 11:56:26 2009,536 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,537 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,537 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,538 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,538 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,539 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,539 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,540 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,540 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,541 [30647] DEBUG VT - Message ->query being executed : select seactivityrel.crmid,crmentity.setype from seactivityrel, crmentity where seactivityrel.activityid='150' and seactivityrel.crmid = crmentity.crmid Wed Jan 28 11:56:26 2009,541 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,542 [30647] DEBUG VT - Message ->query being executed : SELECT firstname,lastname FROM leaddetails WHERE leadid=3 Wed Jan 28 11:56:26 2009,542 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,543 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,543 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,544 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,544 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,545 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='date_start' Wed Jan 28 11:56:26 2009,545 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,546 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,547 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,547 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,548 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,548 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='due_date' Wed Jan 28 11:56:26 2009,549 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,550 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,550 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,551 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,551 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,552 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='recurringtype' Wed Jan 28 11:56:26 2009,552 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,553 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,553 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,554 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,554 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,555 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,555 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,556 [30647] INFO VT - Message ->in getUserName 3 Wed Jan 28 11:56:26 2009,556 [30647] DEBUG VT - Message ->query being executed : select user_name from users where id=3 Wed Jan 28 11:56:26 2009,557 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,557 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,558 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,558 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,558 [30647] INFO VT - Message ->getActionName 1 Wed Jan 28 11:56:26 2009,559 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,559 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,560 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,561 [30647] INFO VT - Message ->in getUserId 150 Wed Jan 28 11:56:26 2009,561 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 150 Wed Jan 28 11:56:26 2009,561 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,562 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,562 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,562 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,563 [30647] INFO VT - Message ->getActionName 2 Wed Jan 28 11:56:26 2009,563 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,564 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,564 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,565 [30647] INFO VT - Message ->in getUserId 150 Wed Jan 28 11:56:26 2009,566 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 150 Wed Jan 28 11:56:26 2009,566 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,567 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='status' Wed Jan 28 11:56:26 2009,567 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,568 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='status' Wed Jan 28 11:56:26 2009,568 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,569 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,569 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,570 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,570 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,571 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='activitytype' Wed Jan 28 11:56:26 2009,571 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,572 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,572 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,573 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,573 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,574 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='subject' Wed Jan 28 11:56:26 2009,574 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,575 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,576 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,576 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,577 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,578 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,578 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,578 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,579 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,580 [30647] DEBUG VT - Message ->query being executed : select seactivityrel.crmid,crmentity.setype from seactivityrel, crmentity where seactivityrel.activityid='208' and seactivityrel.crmid = crmentity.crmid Wed Jan 28 11:56:26 2009,580 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,581 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,581 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,582 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,582 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,583 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='date_start' Wed Jan 28 11:56:26 2009,583 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,584 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,584 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,585 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,585 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,586 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='due_date' Wed Jan 28 11:56:26 2009,586 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,587 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,588 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,588 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,589 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,589 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='recurringtype' Wed Jan 28 11:56:26 2009,590 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,590 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,591 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,591 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,592 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,592 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,593 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,594 [30647] INFO VT - Message ->in getUserName 15 Wed Jan 28 11:56:26 2009,594 [30647] DEBUG VT - Message ->query being executed : select user_name from users where id=15 Wed Jan 28 11:56:26 2009,594 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,595 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,595 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,596 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,596 [30647] INFO VT - Message ->getActionName 1 Wed Jan 28 11:56:26 2009,596 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,597 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,597 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,598 [30647] INFO VT - Message ->in getUserId 208 Wed Jan 28 11:56:26 2009,599 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 208 Wed Jan 28 11:56:26 2009,599 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,600 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,600 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,600 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,601 [30647] INFO VT - Message ->getActionName 2 Wed Jan 28 11:56:26 2009,601 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,601 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,602 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,603 [30647] INFO VT - Message ->in getUserId 208 Wed Jan 28 11:56:26 2009,604 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 208 Wed Jan 28 11:56:26 2009,604 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,605 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='status' Wed Jan 28 11:56:26 2009,605 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,606 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='status' Wed Jan 28 11:56:26 2009,606 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,607 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,607 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,608 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activitytype' Wed Jan 28 11:56:26 2009,608 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,609 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='activitytype' Wed Jan 28 11:56:26 2009,609 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,610 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,610 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,611 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='subject' Wed Jan 28 11:56:26 2009,611 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,612 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='subject' Wed Jan 28 11:56:26 2009,612 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,613 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,614 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,614 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='lastname' Wed Jan 28 11:56:26 2009,615 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,615 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,616 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,616 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='activityid' Wed Jan 28 11:56:26 2009,617 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,618 [30647] DEBUG VT - Message ->query being executed : select seactivityrel.crmid,crmentity.setype from seactivityrel, crmentity where seactivityrel.activityid='215' and seactivityrel.crmid = crmentity.crmid Wed Jan 28 11:56:26 2009,618 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,619 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,619 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,620 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='date_start' Wed Jan 28 11:56:26 2009,620 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,621 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='date_start' Wed Jan 28 11:56:26 2009,621 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,622 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,622 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,623 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='due_date' Wed Jan 28 11:56:26 2009,623 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,624 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='due_date' Wed Jan 28 11:56:26 2009,624 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,625 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,625 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,626 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='recurringtype' Wed Jan 28 11:56:26 2009,626 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,627 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='recurringtype' Wed Jan 28 11:56:26 2009,627 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,628 [30647] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=9 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,629 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,629 [30647] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=9 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,630 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,630 [30647] DEBUG VT - Message ->query being executed : select * from field where tabid=9 and fieldname='assigned_user_id' Wed Jan 28 11:56:26 2009,631 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,632 [30647] INFO VT - Message ->in getUserName 15 Wed Jan 28 11:56:26 2009,632 [30647] DEBUG VT - Message ->query being executed : select user_name from users where id=15 Wed Jan 28 11:56:26 2009,632 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,633 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,633 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,634 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,634 [30647] INFO VT - Message ->getActionName 1 Wed Jan 28 11:56:26 2009,635 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,635 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,635 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,636 [30647] INFO VT - Message ->in getUserId 215 Wed Jan 28 11:56:26 2009,637 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 215 Wed Jan 28 11:56:26 2009,637 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,638 [30647] INFO VT - Message ->module is Activities Wed Jan 28 11:56:26 2009,638 [30647] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:26 2009,638 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,639 [30647] INFO VT - Message ->getActionName 2 Wed Jan 28 11:56:26 2009,639 [30647] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:26 2009,639 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:26 2009,640 [30647] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:26 2009,641 [30647] INFO VT - Message ->in getUserId 215 Wed Jan 28 11:56:26 2009,641 [30647] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 215 Wed Jan 28 11:56:26 2009,642 [30647] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,299 [19339] DEBUG index - ****Starting for session 6sq58e98lh9n1n15c76ae5j0j0 Wed Jan 28 11:56:51 2009,301 [19339] DEBUG index - We have an authenticated user id: 17 Wed Jan 28 11:56:51 2009,301 [19339] DEBUG index - array ( 'module' => 'Home', 'action' => 'index', 'ck_login_id' => '17', 'ck_login_theme' => 'blue', 'ck_login_language' => 'en_us', 'timezone' => '0', 'PHPSESSID' => '6sq58e98lh9n1n15c76ae5j0j0', ) Wed Jan 28 11:56:51 2009,302 [19339] INFO index - About to take action index Wed Jan 28 11:56:51 2009,302 [19339] DEBUG index - in index Wed Jan 28 11:56:51 2009,303 [19339] INFO index - current page is modules/Home/index.php Wed Jan 28 11:56:51 2009,303 [19339] INFO index - current module is Home Wed Jan 28 11:56:51 2009,314 [19339] DEBUG VT - Message ->query being executed : SELECT name from tab where tabid in ('1','2','3','4','6','7','8','9','10','13','14','15','16','17','18','19','20','21','22','23','24','25') and presence = 0 order by tabsequence Wed Jan 28 11:56:51 2009,315 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,316 [19339] DEBUG VT - Message ->getRowCount rows= 17 Wed Jan 28 11:56:51 2009,318 [19339] DEBUG user - Retrieve User: SELECT * FROM users WHERE id = '17' Wed Jan 28 11:56:51 2009,319 [19339] DEBUG VT - Message ->query being executed : SELECT * FROM users WHERE id = '17' Wed Jan 28 11:56:51 2009,319 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed Jan 28 11:56:51 2009,322 [19339] DEBUG VT - Message ->getRowCount rows= 1 Wed Jan 28 11:56:51 2009,325 [19339] DEBUG VT - Message ->query being executed : SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '17' and u1.deleted=0 Wed Jan 28 11:56:51 2009,326 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,327 [19339] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null Wed Jan 28 11:56:51 2009,328 [19339] DEBUG user - additional detail query results: Wed Jan 28 11:56:51 2009,329 [19339] DEBUG index - Current user is: kcarico Wed Jan 28 11:56:51 2009,329 [19339] DEBUG index - Current theme is: blue Wed Jan 28 11:56:51 2009,330 [19339] DEBUG index - current_language is: en_us Wed Jan 28 11:56:51 2009,336 [19339] DEBUG index - setting cookie ck_login_id to 17 Wed Jan 28 11:56:51 2009,336 [19339] DEBUG index - setting cookie ck_login_theme to blue Wed Jan 28 11:56:51 2009,337 [19339] DEBUG index - setting cookie ck_login_language to en_us Wed Jan 28 11:56:51 2009,337 [19339] DEBUG index - including headers Wed Jan 28 11:56:51 2009,344 [19339] INFO VT - Message ->module is Contacts Wed Jan 28 11:56:51 2009,345 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Contacts' Wed Jan 28 11:56:51 2009,346 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,347 [19339] INFO VT - Message ->module is Leads Wed Jan 28 11:56:51 2009,348 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 11:56:51 2009,349 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,350 [19339] INFO VT - Message ->module is Accounts Wed Jan 28 11:56:51 2009,351 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Accounts' Wed Jan 28 11:56:51 2009,351 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,352 [19339] INFO VT - Message ->module is Potentials Wed Jan 28 11:56:51 2009,353 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Potentials' Wed Jan 28 11:56:51 2009,354 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,355 [19339] INFO VT - Message ->module is HelpDesk Wed Jan 28 11:56:51 2009,356 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='HelpDesk' Wed Jan 28 11:56:51 2009,356 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,357 [19339] INFO VT - Message ->module is Faq Wed Jan 28 11:56:51 2009,358 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Faq' Wed Jan 28 11:56:51 2009,359 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,360 [19339] INFO VT - Message ->module is Products Wed Jan 28 11:56:51 2009,361 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Products' Wed Jan 28 11:56:51 2009,361 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,363 [19339] INFO VT - Message ->module is Notes Wed Jan 28 11:56:51 2009,363 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Notes' Wed Jan 28 11:56:51 2009,364 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,365 [19339] INFO VT - Message ->module is Emails Wed Jan 28 11:56:51 2009,366 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Emails' Wed Jan 28 11:56:51 2009,366 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,368 [19339] INFO VT - Message ->module is Events Wed Jan 28 11:56:51 2009,368 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Events' Wed Jan 28 11:56:51 2009,369 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,370 [19339] INFO VT - Message ->module is Activities Wed Jan 28 11:56:51 2009,371 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 11:56:51 2009,371 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,373 [19339] INFO VT - Message ->module is Vendor Wed Jan 28 11:56:51 2009,373 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Vendor' Wed Jan 28 11:56:51 2009,374 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,375 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,376 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,377 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,380 [19339] INFO VT - Message ->module is PriceBook Wed Jan 28 11:56:51 2009,380 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='PriceBook' Wed Jan 28 11:56:51 2009,381 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,382 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,383 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,384 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,387 [19339] INFO VT - Message ->module is Quotes Wed Jan 28 11:56:51 2009,387 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 11:56:51 2009,388 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,389 [19339] INFO VT - Message ->module is Orders Wed Jan 28 11:56:51 2009,390 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Orders' Wed Jan 28 11:56:51 2009,391 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,392 [19339] INFO VT - Message ->module is SalesOrder Wed Jan 28 11:56:51 2009,393 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 11:56:51 2009,393 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,394 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,395 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,396 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,399 [19339] INFO VT - Message ->module is Invoice Wed Jan 28 11:56:51 2009,400 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 11:56:51 2009,400 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,421 [19339] DEBUG Tracker - About to retrieve list: SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='17' and crmentity.deleted=0 ORDER BY id DESC Wed Jan 28 11:56:51 2009,421 [19339] DEBUG VT - Message ->query being executed : SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='17' and crmentity.deleted=0 ORDER BY id DESC Wed Jan 28 11:56:51 2009,422 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,425 [19339] INFO VT - Message ->module is Leads Wed Jan 28 11:56:51 2009,426 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 11:56:51 2009,427 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,428 [19339] INFO VT - Message ->getActionName 4 Wed Jan 28 11:56:51 2009,429 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,429 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,431 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,433 [19339] INFO VT - Message ->in getUserId 7 Wed Jan 28 11:56:51 2009,434 [19339] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 7 Wed Jan 28 11:56:51 2009,435 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,436 [19339] INFO VT - Message ->module is Leads Wed Jan 28 11:56:51 2009,437 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 11:56:51 2009,438 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,439 [19339] INFO VT - Message ->getActionName 4 Wed Jan 28 11:56:51 2009,440 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,440 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,442 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,445 [19339] INFO VT - Message ->in getUserId 125 Wed Jan 28 11:56:51 2009,445 [19339] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 125 Wed Jan 28 11:56:51 2009,446 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,447 [19339] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null Wed Jan 28 11:56:51 2009,449 [19339] INFO VT - Message ->module is Home Wed Jan 28 11:56:51 2009,450 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Home' Wed Jan 28 11:56:51 2009,451 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,452 [19339] INFO VT - Message ->get Actionid index Wed Jan 28 11:56:51 2009,453 [19339] INFO VT - Message ->action id selected is 3 Wed Jan 28 11:56:51 2009,453 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,454 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,455 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,805 [19339] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 11:56:51 2009,806 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,808 [19339] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 11:56:51 2009,814 [19339] DEBUG VT - Message -> limitQuery sql = select crmentity.crmid,crmentity.smownerid,crmentity.setype, activity.*, contactdetails.lastname, contactdetails.firstname, contactdetails.contactid, account.accountid, account.accountname, recurringevents.recurringtype,recurringevents.recurringdate from activity inner join crmentity on crmentity.crmid=activity.activityid left join cntactivityrel on cntactivityrel.activityid= activity.activityid left join contactdetails on contactdetails.contactid= cntactivityrel.contactid left join seactivityrel on seactivityrel.activityid = activity.activityid left outer join account on account.accountid = contactdetails.accountid left outer join recurringevents on recurringevents.activityid=activity.activityid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE crmentity.deleted=0 and (activity.activitytype = 'Meeting' or activity.activitytype='Call' or activity.activitytype='Task') AND ( activity.status is NULL || activity.status != 'Completed' ) and ( activity.eventstatus is NULL || activity.eventstatus != 'Held') AND (((date_start >= '2009-01-28' AND date_start < '2009-02-04') OR (date_start < '2009-01-28')) OR (recurringevents.recurringdate between '2009-01-28' and '2009-02-04') ) AND salesmanactivityrel.smid ='17' st = 0 co = 5 Wed Jan 28 11:56:51 2009,815 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,817 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:51 2009,857 [19339] DEBUG VT - Message -> limitQuery sql = select crmentity.crmid, crmentity.smownerid,account.accountname, potential.accountid,potential.potentialname,potential.sales_stage,potential.amount,potential.currency,potential.closingdate,potential.typeofrevenue, potentialscf.* from potential inner join crmentity on crmentity.crmid=potential.potentialid inner join account on potential.accountid = account.accountid inner join potentialscf on potentialscf.potentialid = potential.potentialid where crmentity.deleted=0 AND potential.sales_stage <> 'Closed Won' AND potential.sales_stage <> 'Closed Lost' AND crmentity.smownerid='17' ORDER BY amount DESC st = 0 co = 5 Wed Jan 28 11:56:51 2009,858 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,860 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:51 2009,865 [19339] DEBUG VT - Message ->query being executed : select * from currency_info Wed Jan 28 11:56:51 2009,865 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,867 [19339] DEBUG VT - Message ->query being executed : select groupname from users2group where userid='17' Wed Jan 28 11:56:51 2009,868 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,869 [19339] DEBUG VT - Message ->getRowCount rows= 1 Wed Jan 28 11:56:51 2009,870 [19339] INFO top opportunity_list - Here is the where clause for the list view: select leaddetails.leadid as id,leaddetails.lastname as name,leadgrouprelation.groupname as groupname, 'Leads ' as Type from leaddetails inner join leadgrouprelation on leaddetails.leadid=leadgrouprelation.leadid inner join crmentity on crmentity.crmid = leaddetails.leadid where crmentity.deleted=0 and leadgrouprelation.groupname is not null and leadgrouprelation.groupname='ACTS' union all select activity.activityid,activity.subject,activitygrouprelation.groupname,'Activities' as Type from activity inner join activitygrouprelation on activitygrouprelation.activityid=activity.activityid inner join crmentity on crmentity.crmid = activity.activityid where crmentity.deleted=0 and activitygrouprelation.groupname is not null and groupname ='ACTS' union all select troubletickets.ticketid,troubletickets.title,ticketgrouprelation.groupname,'Tickets ' as Type from troubletickets inner join ticketgrouprelation on ticketgrouprelation.ticketid=troubletickets.ticketid inner join crmentity on crmentity.crmid = troubletickets.ticketid and crmentity.deleted=0 and ticketgrouprelation.groupname is not null and ticketgrouprelation.groupname='ACTS' Wed Jan 28 11:56:51 2009,871 [19339] DEBUG VT - Message -> limitQuery sql = select leaddetails.leadid as id,leaddetails.lastname as name,leadgrouprelation.groupname as groupname, 'Leads ' as Type from leaddetails inner join leadgrouprelation on leaddetails.leadid=leadgrouprelation.leadid inner join crmentity on crmentity.crmid = leaddetails.leadid where crmentity.deleted=0 and leadgrouprelation.groupname is not null and leadgrouprelation.groupname='ACTS' union all select activity.activityid,activity.subject,activitygrouprelation.groupname,'Activities' as Type from activity inner join activitygrouprelation on activitygrouprelation.activityid=activity.activityid inner join crmentity on crmentity.crmid = activity.activityid where crmentity.deleted=0 and activitygrouprelation.groupname is not null and groupname ='ACTS' union all select troubletickets.ticketid,troubletickets.title,ticketgrouprelation.groupname,'Tickets ' as Type from troubletickets inner join ticketgrouprelation on ticketgrouprelation.ticketid=troubletickets.ticketid inner join crmentity on crmentity.crmid = troubletickets.ticketid and crmentity.deleted=0 and ticketgrouprelation.groupname is not null and ticketgrouprelation.groupname='ACTS' st = 0 co = 5 Wed Jan 28 11:56:51 2009,871 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,876 [19339] DEBUG VT - Message ->query being executed : select troubletickets.ticketid,parent_id,priority,troubletickets.status,category,troubletickets.title,troubletickets.description,update_log,version_id,crmentity.createdtime,crmentity.modifiedtime, contactdetails.firstname,contactdetails.lastname, account.accountid, account.accountname, users.user_name from troubletickets inner join crmentity on crmentity.crmid= troubletickets.ticketid inner join users on users.id=crmentity.smownerid left join contactdetails on troubletickets.parent_id=contactdetails.contactid left join account on account.accountid=troubletickets.parent_id left join seticketsrel on seticketsrel.ticketid=troubletickets.ticketid where crmentity.smownerid=17 and crmentity.deleted=0 and troubletickets.status <> 'Closed' ORDER BY createdtime DESC Wed Jan 28 11:56:51 2009,877 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,879 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:51 2009,880 [19339] DEBUG VT - Message -> limitQuery sql = select troubletickets.ticketid,parent_id,priority,troubletickets.status,category,troubletickets.title,troubletickets.description,update_log,version_id,crmentity.createdtime,crmentity.modifiedtime, contactdetails.firstname,contactdetails.lastname, account.accountid, account.accountname, users.user_name from troubletickets inner join crmentity on crmentity.crmid= troubletickets.ticketid inner join users on users.id=crmentity.smownerid left join contactdetails on troubletickets.parent_id=contactdetails.contactid left join account on account.accountid=troubletickets.parent_id left join seticketsrel on seticketsrel.ticketid=troubletickets.ticketid where crmentity.smownerid=17 and crmentity.deleted=0 and troubletickets.status <> 'Closed' ORDER BY createdtime DESC st = 0 co = 5 Wed Jan 28 11:56:51 2009,881 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,883 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:51 2009,897 [19339] DEBUG VT - Message ->query being executed : select customview.* from customview inner join tab on tab.name = customview.entitytype where customview.setmetrics = 1 order by customview.entitytype Wed Jan 28 11:56:51 2009,898 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,900 [19339] INFO VT - Message ->Metrics :: Successfully got MetricList to be displayed Wed Jan 28 11:56:51 2009,901 [19339] DEBUG VT - Message ->query being executed : select cvstdfilter.* from cvstdfilter inner join customview on customview.cvid = cvstdfilter.cvid where cvstdfilter.cvid=3 Wed Jan 28 11:56:51 2009,902 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,910 [19339] DEBUG VT - Message ->query being executed : select cvadvfilter.* from cvadvfilter inner join customview on cvadvfilter.cvid = customview.cvid where cvadvfilter.cvid=3 Wed Jan 28 11:56:51 2009,910 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,912 [19339] DEBUG VT - Message ->query being executed : select count(*) count from account inner join crmentity on crmentity.crmid=account.accountid inner join accountbillads on account.accountid=accountbillads.accountaddressid inner join accountshipads on account.accountid=accountshipads.accountaddressid inner join accountscf on account.accountid = accountscf.accountid where crmentity.deleted=0 and account.account_type = 'Prospect' Wed Jan 28 11:56:51 2009,913 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,915 [19339] DEBUG VT - Message ->query being executed : select cvstdfilter.* from cvstdfilter inner join customview on customview.cvid = cvstdfilter.cvid where cvstdfilter.cvid=9 Wed Jan 28 11:56:51 2009,915 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,923 [19339] DEBUG VT - Message ->query being executed : select cvadvfilter.* from cvadvfilter inner join customview on cvadvfilter.cvid = customview.cvid where cvadvfilter.cvid=9 Wed Jan 28 11:56:51 2009,924 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,926 [19339] DEBUG VT - Message ->query being executed : select count(*) count from troubletickets inner join ticketcf on ticketcf.ticketid = troubletickets.ticketid inner join crmentity on crmentity.crmid=troubletickets.ticketid left join contactdetails on troubletickets.parent_id=contactdetails.contactid left join account on account.accountid=troubletickets.parent_id left join users on crmentity.smownerid=users.id and troubletickets.ticketid = ticketcf.ticketid where crmentity.deleted=0 and troubletickets.status <> 'Closed' Wed Jan 28 11:56:51 2009,927 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,928 [19339] DEBUG VT - Message ->query being executed : select cvstdfilter.* from cvstdfilter inner join customview on customview.cvid = cvstdfilter.cvid where cvstdfilter.cvid=1 Wed Jan 28 11:56:51 2009,929 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,937 [19339] DEBUG VT - Message ->query being executed : select cvadvfilter.* from cvadvfilter inner join customview on cvadvfilter.cvid = customview.cvid where cvadvfilter.cvid=1 Wed Jan 28 11:56:51 2009,938 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,939 [19339] DEBUG VT - Message ->query being executed : select count(*) count from leaddetails inner join crmentity on crmentity.crmid=leaddetails.leadid inner join leadsubdetails on leadsubdetails.leadsubscriptionid=leaddetails.leadid inner join leadaddress on leadaddress.leadaddressid=leadsubdetails.leadsubscriptionid inner join leadscf on leaddetails.leadid = leadscf.leadid where crmentity.deleted=0 and leaddetails.converted=0 and leaddetails.leadstatus = 'Hot' Wed Jan 28 11:56:51 2009,940 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,947 [19339] DEBUG VT - Message ->query being executed : select cvstdfilter.* from cvstdfilter inner join customview on customview.cvid = cvstdfilter.cvid where cvstdfilter.cvid=7 Wed Jan 28 11:56:51 2009,947 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,956 [19339] DEBUG VT - Message ->query being executed : select cvadvfilter.* from cvadvfilter inner join customview on cvadvfilter.cvid = customview.cvid where cvadvfilter.cvid=7 Wed Jan 28 11:56:51 2009,956 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,958 [19339] DEBUG VT - Message ->query being executed : select count(*) count from potential inner join crmentity on crmentity.crmid=potential.potentialid inner join account on potential.accountid = account.accountid inner join potentialscf on potentialscf.potentialid = potential.potentialid where crmentity.deleted=0 and potential.sales_stage = 'Closed Won' Wed Jan 28 11:56:51 2009,959 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,961 [19339] DEBUG VT - Message ->query being executed : select cvstdfilter.* from cvstdfilter inner join customview on customview.cvid = cvstdfilter.cvid where cvstdfilter.cvid=11 Wed Jan 28 11:56:51 2009,961 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,969 [19339] DEBUG VT - Message ->query being executed : select cvadvfilter.* from cvadvfilter inner join customview on cvadvfilter.cvid = customview.cvid where cvadvfilter.cvid=11 Wed Jan 28 11:56:51 2009,970 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,972 [19339] DEBUG VT - Message ->query being executed : select count(*) count from quotes inner join crmentity on crmentity.crmid=quotes.quoteid inner join quotesbillads on quotes.quoteid=quotesbillads.quotebilladdressid inner join quotesshipads on quotes.quoteid=quotesshipads.quoteshipaddressid left outer join account on account.accountid=quotes.accountid left outer join potential on potential.potentialid=quotes.potentialid where crmentity.deleted=0 and quotes.quotestage <> 'Accepted' and quotes.quotestage <> 'Rejected' Wed Jan 28 11:56:51 2009,973 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,974 [19339] INFO VT - Message ->Metrics :: Successfully build the Metrics Wed Jan 28 11:56:51 2009,984 [19339] DEBUG VT - Message ->query being executed : select * from quotestage where presence=1 order by sortorderid Wed Jan 28 11:56:51 2009,985 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,987 [19339] INFO VT - Message ->module is Quotes Wed Jan 28 11:56:51 2009,988 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 11:56:51 2009,988 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,990 [19339] DEBUG VT - Message ->query being executed : select customview.* from customview inner join tab on tab.name = customview.entitytype where tab.tabid=20 Wed Jan 28 11:56:51 2009,990 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,992 [19339] INFO VT - Message ->in getColumnFields Quotes Wed Jan 28 11:56:51 2009,993 [19339] INFO VT - Message ->module is Quotes Wed Jan 28 11:56:51 2009,994 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 11:56:51 2009,994 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,995 [19339] DEBUG VT - Message ->query being executed : select * from field where tabid=20 Wed Jan 28 11:56:51 2009,996 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:51 2009,998 [19339] DEBUG VT - Message ->getRowCount rows= 29 Wed Jan 28 11:56:52 2009,004 [19339] DEBUG VT - Message -> limitQuery sql = select crmentity.*, quotes.*, quotesbillads.*, quotesshipads.*,potential.potentialname,account.accountname from quotes inner join crmentity on crmentity.crmid=quotes.quoteid inner join quotesbillads on quotes.quoteid=quotesbillads.quotebilladdressid inner join quotesshipads on quotes.quoteid=quotesshipads.quoteshipaddressid left outer join account on account.accountid=quotes.accountid left outer join potential on potential.potentialid=quotes.potentialid where crmentity.deleted=0 and crmentity.smownerid=17 and quotes.validtill >= '2009-01-28' ORDER BY total DESC st = 0 co = 5 Wed Jan 28 11:56:52 2009,005 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,007 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,008 [19339] INFO VT - Message ->module is Quotes Wed Jan 28 11:56:52 2009,009 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 11:56:52 2009,010 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,011 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='' Wed Jan 28 11:56:52 2009,012 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,013 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='' Wed Jan 28 11:56:52 2009,014 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,016 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,017 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,018 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,019 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,021 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='quotestage' Wed Jan 28 11:56:52 2009,022 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,023 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='quotestage' Wed Jan 28 11:56:52 2009,024 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,026 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='potential_id' Wed Jan 28 11:56:52 2009,026 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,028 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='potential_id' Wed Jan 28 11:56:52 2009,029 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,030 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='account_id' Wed Jan 28 11:56:52 2009,031 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,033 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='account_id' Wed Jan 28 11:56:52 2009,034 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,035 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,036 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,038 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,038 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,040 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=20 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,041 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,042 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=20 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,043 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,045 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,046 [19339] INFO VT - Message ->module is Quotes Wed Jan 28 11:56:52 2009,046 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 11:56:52 2009,047 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,054 [19339] INFO VT - Message ->module is SalesOrder Wed Jan 28 11:56:52 2009,055 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 11:56:52 2009,055 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,057 [19339] DEBUG VT - Message ->query being executed : select customview.* from customview inner join tab on tab.name = customview.entitytype where tab.tabid=22 Wed Jan 28 11:56:52 2009,057 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,059 [19339] INFO VT - Message ->in getColumnFields SalesOrder Wed Jan 28 11:56:52 2009,060 [19339] INFO VT - Message ->module is SalesOrder Wed Jan 28 11:56:52 2009,061 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 11:56:52 2009,061 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,063 [19339] DEBUG VT - Message ->query being executed : select * from field where tabid=22 Wed Jan 28 11:56:52 2009,063 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,065 [19339] DEBUG VT - Message ->getRowCount rows= 32 Wed Jan 28 11:56:52 2009,071 [19339] DEBUG VT - Message -> limitQuery sql = select crmentity.*, salesorder.*, sobillads.*, soshipads.*,quotes.subject as quotename, account.accountname from salesorder inner join crmentity on crmentity.crmid=salesorder.salesorderid inner join sobillads on salesorder.salesorderid=sobillads.sobilladdressid inner join soshipads on salesorder.salesorderid=soshipads.soshipaddressid left outer join quotes on quotes.quoteid=salesorder.quoteid left outer join account on account.accountid=salesorder.accountid where crmentity.deleted=0 and crmentity.smownerid=17 and salesorder.duedate >= '2009-01-28' ORDER BY total DESC st = 0 co = 5 Wed Jan 28 11:56:52 2009,072 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,074 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,076 [19339] INFO VT - Message ->module is SalesOrder Wed Jan 28 11:56:52 2009,076 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 11:56:52 2009,077 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,079 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='' Wed Jan 28 11:56:52 2009,079 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,081 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='' Wed Jan 28 11:56:52 2009,082 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,083 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,084 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,086 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,087 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,088 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='account_id' Wed Jan 28 11:56:52 2009,089 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,091 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='account_id' Wed Jan 28 11:56:52 2009,091 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,093 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='quote_id' Wed Jan 28 11:56:52 2009,094 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,096 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='quote_id' Wed Jan 28 11:56:52 2009,096 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,098 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,099 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,100 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,101 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,103 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=22 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,103 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,105 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=22 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,106 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,108 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,108 [19339] INFO VT - Message ->module is SalesOrder Wed Jan 28 11:56:52 2009,109 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 11:56:52 2009,110 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,116 [19339] INFO VT - Message ->module is Invoice Wed Jan 28 11:56:52 2009,117 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 11:56:52 2009,117 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,119 [19339] DEBUG VT - Message ->query being executed : select customview.* from customview inner join tab on tab.name = customview.entitytype where tab.tabid=23 Wed Jan 28 11:56:52 2009,120 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,121 [19339] INFO VT - Message ->in getColumnFields Invoice Wed Jan 28 11:56:52 2009,122 [19339] INFO VT - Message ->module is Invoice Wed Jan 28 11:56:52 2009,123 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 11:56:52 2009,123 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,125 [19339] DEBUG VT - Message ->query being executed : select * from field where tabid=23 Wed Jan 28 11:56:52 2009,125 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,127 [19339] DEBUG VT - Message ->getRowCount rows= 29 Wed Jan 28 11:56:52 2009,133 [19339] DEBUG VT - Message -> limitQuery sql = select crmentity.*, invoice.*, invoicebillads.*, invoiceshipads.*,salesorder.subject as salessubject from invoice inner join crmentity on crmentity.crmid=invoice.invoiceid inner join invoicebillads on invoice.invoiceid=invoicebillads.invoicebilladdressid inner join invoiceshipads on invoice.invoiceid=invoiceshipads.invoiceshipaddressid left outer join salesorder on salesorder.salesorderid=invoice.salesorderid where crmentity.deleted=0 and crmentity.smownerid=17 and invoice.duedate >= '2009-01-28' ORDER BY total DESC st = 0 co = 5 Wed Jan 28 11:56:52 2009,134 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,136 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,138 [19339] INFO VT - Message ->module is Invoice Wed Jan 28 11:56:52 2009,138 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 11:56:52 2009,139 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,140 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=23 and profile2field.profileid=2 and field.fieldname='' Wed Jan 28 11:56:52 2009,141 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,143 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=23 and field.fieldname='' Wed Jan 28 11:56:52 2009,144 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,145 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=23 and profile2field.profileid=2 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,146 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,148 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=23 and field.fieldname='subject' Wed Jan 28 11:56:52 2009,149 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,150 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=23 and profile2field.profileid=2 and field.fieldname='salesorder_id' Wed Jan 28 11:56:52 2009,151 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,153 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=23 and field.fieldname='salesorder_id' Wed Jan 28 11:56:52 2009,154 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,155 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=23 and profile2field.profileid=2 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,156 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,158 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=23 and field.fieldname='hdnGrandTotal' Wed Jan 28 11:56:52 2009,159 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,160 [19339] DEBUG VT - Message ->query being executed : select profile2field.* from field inner join profile2field on field.fieldid=profile2field.fieldid where profile2field.tabid=23 and profile2field.profileid=2 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,161 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,163 [19339] DEBUG VT - Message ->query being executed : select def_org_field.* from field inner join def_org_field on field.fieldid=def_org_field.fieldid where def_org_field.tabid=23 and field.fieldname='assigned_user_id' Wed Jan 28 11:56:52 2009,163 [19339] INFO VT - Message ->checkconnect using old connection Wed Jan 28 11:56:52 2009,165 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed Jan 28 11:56:52 2009,166 [19339] INFO VT - Message ->module is Invoice Wed Jan 28 11:56:52 2009,167 [19339] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 11:56:52 2009,167 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,280 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-02' AND activity.date_start >= '2009-01-01') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,281 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,285 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,286 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-02' AND recurringdate >= '2009-01-01') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,287 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,290 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,303 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-03' AND activity.date_start >= '2009-01-02') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,304 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,308 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,309 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-03' AND recurringdate >= '2009-01-02') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,310 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,314 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,327 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-04' AND activity.date_start >= '2009-01-03') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,328 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,332 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,333 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-04' AND recurringdate >= '2009-01-03') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,334 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,338 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,350 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-05' AND activity.date_start >= '2009-01-04') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,351 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,355 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,357 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-05' AND recurringdate >= '2009-01-04') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,357 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,361 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,374 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-06' AND activity.date_start >= '2009-01-05') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,375 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,379 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,380 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-06' AND recurringdate >= '2009-01-05') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,381 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,384 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,397 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-07' AND activity.date_start >= '2009-01-06') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,398 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,402 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,403 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-07' AND recurringdate >= '2009-01-06') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,404 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,407 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,420 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-08' AND activity.date_start >= '2009-01-07') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,421 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,425 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,427 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-08' AND recurringdate >= '2009-01-07') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,428 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,431 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,443 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-09' AND activity.date_start >= '2009-01-08') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,444 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,448 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,450 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-09' AND recurringdate >= '2009-01-08') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,451 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,453 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,459 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-10' AND activity.date_start >= '2009-01-09') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,459 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,461 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,461 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-10' AND recurringdate >= '2009-01-09') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,462 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,464 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,469 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-11' AND activity.date_start >= '2009-01-10') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,469 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,471 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,472 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-11' AND recurringdate >= '2009-01-10') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,472 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,474 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,479 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-12' AND activity.date_start >= '2009-01-11') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,480 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,481 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,482 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-12' AND recurringdate >= '2009-01-11') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,483 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,484 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,490 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-13' AND activity.date_start >= '2009-01-12') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,490 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,492 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,493 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-13' AND recurringdate >= '2009-01-12') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,493 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,495 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,501 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-14' AND activity.date_start >= '2009-01-13') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,501 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,503 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,503 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-14' AND recurringdate >= '2009-01-13') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,504 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,505 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,511 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-15' AND activity.date_start >= '2009-01-14') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,511 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,513 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,514 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-15' AND recurringdate >= '2009-01-14') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,514 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,515 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,521 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-16' AND activity.date_start >= '2009-01-15') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,521 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,523 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,524 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-16' AND recurringdate >= '2009-01-15') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,524 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,526 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,531 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-17' AND activity.date_start >= '2009-01-16') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,532 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,534 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,534 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-17' AND recurringdate >= '2009-01-16') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,535 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,536 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,542 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-18' AND activity.date_start >= '2009-01-17') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,542 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,544 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,545 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-18' AND recurringdate >= '2009-01-17') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,545 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,547 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,552 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-19' AND activity.date_start >= '2009-01-18') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,552 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,554 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,555 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-19' AND recurringdate >= '2009-01-18') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,555 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,557 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,563 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-20' AND activity.date_start >= '2009-01-19') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,563 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,565 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,565 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-20' AND recurringdate >= '2009-01-19') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,566 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,567 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,573 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-21' AND activity.date_start >= '2009-01-20') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,573 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,575 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,576 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-21' AND recurringdate >= '2009-01-20') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,576 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,577 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,583 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-22' AND activity.date_start >= '2009-01-21') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,584 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,585 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,586 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-22' AND recurringdate >= '2009-01-21') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,586 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,588 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,594 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-23' AND activity.date_start >= '2009-01-22') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,594 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,596 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,597 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-23' AND recurringdate >= '2009-01-22') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,597 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,598 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,604 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-24' AND activity.date_start >= '2009-01-23') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,604 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,606 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,607 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-24' AND recurringdate >= '2009-01-23') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,607 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,609 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,614 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-25' AND activity.date_start >= '2009-01-24') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,615 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,617 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,617 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-25' AND recurringdate >= '2009-01-24') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,618 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,619 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,625 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-26' AND activity.date_start >= '2009-01-25') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,625 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,627 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,627 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-26' AND recurringdate >= '2009-01-25') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,628 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,629 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,635 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-27' AND activity.date_start >= '2009-01-26') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,636 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,637 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,638 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-27' AND recurringdate >= '2009-01-26') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,638 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,640 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,645 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-28' AND activity.date_start >= '2009-01-27') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,646 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,648 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,648 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-28' AND recurringdate >= '2009-01-27') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,648 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,650 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,656 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-29' AND activity.date_start >= '2009-01-28') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,656 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,658 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,659 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-29' AND recurringdate >= '2009-01-28') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,659 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,661 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,666 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-30' AND activity.date_start >= '2009-01-29') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,666 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,668 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,669 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-30' AND recurringdate >= '2009-01-29') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,669 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,671 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,676 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-01-31' AND activity.date_start >= '2009-01-30') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,677 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,679 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,679 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-01-31' AND recurringdate >= '2009-01-30') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,680 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,681 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,687 [19339] DEBUG VT - Message ->query being executed : Select activity.*,crmentity.*,account.accountname,account.accountid FROM activity inner join crmentity on activity.activityid = crmentity.crmid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid WHERE activity.activitytype in ('Call','Meeting') AND ( ((activity.date_start < '2009-02-01' AND activity.date_start >= '2009-01-31') and (activity.date_start like (activity.due_date) or (activity.date_start != '0000-00-00' )) ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17') AND crmentity.deleted = 0) ORDER by activity.date_start,activity.time_start Wed 28 Jan 2009 11:56:52 AM EST,687 [19339] FATAL VT - PearDatabase ->TRANS creating new connection Wed 28 Jan 2009 11:56:52 AM EST,689 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,689 [19339] DEBUG VT - Message ->query being executed : SELECT activity.activityid, activity.subject, activity.activitytype, activity.description, activity.time_start, activity.duration_hours, activity.duration_minutes, activity.priority, activity.location,activity.eventstatus, crmentity.*, recurringevents.recurringid, recurringevents.recurringdate as date_start ,recurringevents.recurringtype,account.accountname,account.accountid from activity inner join crmentity on activity.activityid = crmentity.crmid inner join recurringevents on activity.activityid=recurringevents.activityid left join cntactivityrel on activity.activityid = cntactivityrel.activityid left join contactdetails on cntactivityrel.contactid = contactdetails.contactid left join account on contactdetails.accountid = account.accountid inner join salesmanactivityrel on salesmanactivityrel.activityid=activity.activityid where ( activity.activitytype in ('Call','Meeting') AND ( (recurringdate < '2009-02-01' AND recurringdate >= '2009-01-31') ) AND (crmentity.smownerid ='17' and salesmanactivityrel.smid = '17' ) AND crmentity.deleted = 0 ) ORDER by recurringid Wed 28 Jan 2009 11:56:52 AM EST,690 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,691 [19339] DEBUG VT - Message ->getRowCount rows= 0 Wed 28 Jan 2009 11:56:52 AM EST,737 [19339] DEBUG VT - Message ->query being executed : select * from sales_stage where presence=1 order by sortorderid Wed 28 Jan 2009 11:56:52 AM EST,737 [19339] INFO VT - Message ->checkconnect using old connection Wed 28 Jan 2009 11:56:52 AM EST,738 [19339] DEBUG my_pipeline_by_sales_stage - datax is: Wed 28 Jan 2009 11:56:52 AM EST,739 [19339] DEBUG my_pipeline_by_sales_stage - array ( 'Prospecting' => 'Prospecting', 'Qualification' => 'Qualification', 'Needs Analysis' => 'Needs Analysis', 'Value Proposition' => 'Value Proposition', 'Id. Decision Makers' => 'Id. Decision Makers', 'Perception Analysis' => 'Perception Analysis', 'Proposal/Price Quote' => 'Proposal/Price Quote', 'Negotiation/Review' => 'Negotiation/Review', 'Closed Won' => 'Closed Won', 'Closed Lost' => 'Closed Lost', ) Wed 28 Jan 2009 11:56:52 AM EST,739 [19339] DEBUG my_pipeline_by_sales_stage - ids is: Wed 28 Jan 2009 11:56:52 AM EST,739 [19339] DEBUG my_pipeline_by_sales_stage - array ( 0 => '17', ) Wed 28 Jan 2009 11:56:52 AM EST,740 [19339] DEBUG my_pipeline_by_sales_stage - cache file name is: 1060745282_pipeline_en_us_1762355022009-01-282100-01-01.png Wed Jan 28 12:00:38 2009,387 [30648] DEBUG index - ****Starting for session 6sq58e98lh9n1n15c76ae5j0j0 Wed Jan 28 12:00:38 2009,388 [30648] DEBUG index - We have an authenticated user id: 17 Wed Jan 28 12:00:38 2009,388 [30648] DEBUG index - array ( 'module' => 'Users', 'action' => 'DetailView', 'record' => '17', 'ck_login_id' => '17', 'ck_login_theme' => 'blue', 'ck_login_language' => 'en_us', 'timezone' => '0', 'PHPSESSID' => '6sq58e98lh9n1n15c76ae5j0j0', ) Wed Jan 28 12:00:38 2009,389 [30648] INFO index - About to take action DetailView Wed Jan 28 12:00:38 2009,389 [30648] DEBUG index - in DetailView Wed Jan 28 12:00:38 2009,390 [30648] INFO index - current page is modules/Users/DetailView.php Wed Jan 28 12:00:38 2009,391 [30648] INFO index - current module is Users Wed Jan 28 12:00:38 2009,401 [30648] DEBUG VT - Message ->query being executed : SELECT name from tab where tabid in ('1','2','3','4','6','7','8','9','10','13','14','15','16','17','18','19','20','21','22','23','24','25') and presence = 0 order by tabsequence Wed Jan 28 12:00:38 2009,402 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,404 [30648] DEBUG VT - Message ->getRowCount rows= 17 Wed Jan 28 12:00:38 2009,405 [30648] DEBUG user - Retrieve User: SELECT * FROM users WHERE id = '17' Wed Jan 28 12:00:38 2009,406 [30648] DEBUG VT - Message ->query being executed : SELECT * FROM users WHERE id = '17' Wed Jan 28 12:00:38 2009,407 [30648] FATAL VT - PearDatabase ->TRANS creating new connection Wed Jan 28 12:00:38 2009,409 [30648] DEBUG VT - Message ->getRowCount rows= 1 Wed Jan 28 12:00:38 2009,412 [30648] DEBUG VT - Message ->query being executed : SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '17' and u1.deleted=0 Wed Jan 28 12:00:38 2009,413 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,414 [30648] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null Wed Jan 28 12:00:38 2009,415 [30648] DEBUG user - additional detail query results: Wed Jan 28 12:00:38 2009,415 [30648] DEBUG index - Current user is: kcarico Wed Jan 28 12:00:38 2009,416 [30648] DEBUG index - Current theme is: blue Wed Jan 28 12:00:38 2009,417 [30648] DEBUG index - current_language is: en_us Wed Jan 28 12:00:38 2009,424 [30648] DEBUG user - About to call tracker (user_id, module_name, item_id)(17, Users, ) Wed Jan 28 12:00:38 2009,425 [30648] DEBUG VT - Message ->query being executed : DELETE from tracker WHERE user_id='17' and item_id='17' Wed Jan 28 12:00:38 2009,425 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,426 [30648] INFO VT - Message ->in track view method Users Wed Jan 28 12:00:38 2009,427 [30648] DEBUG VT - Message ->query being executed : select first_name,last_name from users where id=17 Wed Jan 28 12:00:38 2009,428 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,429 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,432 [30648] INFO Tracker - Track Item View: INSERT into tracker (user_id, module_name, item_id, item_summary) values ('17', 'Users', '17', 'Katie Hyatt') Wed Jan 28 12:00:38 2009,433 [30648] DEBUG VT - Message ->query being executed : INSERT into tracker (user_id, module_name, item_id, item_summary) values ('17', 'Users', '17', 'Katie Hyatt') Wed Jan 28 12:00:38 2009,434 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,434 [30648] DEBUG Tracker - About to verify history size: SELECT count(*) from tracker WHERE user_id='17' Wed Jan 28 12:00:38 2009,435 [30648] FATAL VT - PearDatabase ->ADODB getOne sql=SELECT count(*) from tracker WHERE user_id='17' Wed Jan 28 12:00:38 2009,436 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,437 [30648] DEBUG Tracker - history size: (current, max)(3, 5) Wed Jan 28 12:00:38 2009,438 [30648] DEBUG index - setting cookie ck_login_id to 17 Wed Jan 28 12:00:38 2009,438 [30648] DEBUG index - setting cookie ck_login_theme to blue Wed Jan 28 12:00:38 2009,439 [30648] DEBUG index - setting cookie ck_login_language to en_us Wed Jan 28 12:00:38 2009,439 [30648] DEBUG index - including headers Wed Jan 28 12:00:38 2009,446 [30648] INFO VT - Message ->module is Contacts Wed Jan 28 12:00:38 2009,447 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Contacts' Wed Jan 28 12:00:38 2009,448 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,449 [30648] INFO VT - Message ->module is Leads Wed Jan 28 12:00:38 2009,450 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 12:00:38 2009,451 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,452 [30648] INFO VT - Message ->module is Accounts Wed Jan 28 12:00:38 2009,453 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Accounts' Wed Jan 28 12:00:38 2009,453 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,454 [30648] INFO VT - Message ->module is Potentials Wed Jan 28 12:00:38 2009,455 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Potentials' Wed Jan 28 12:00:38 2009,456 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,457 [30648] INFO VT - Message ->module is HelpDesk Wed Jan 28 12:00:38 2009,458 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='HelpDesk' Wed Jan 28 12:00:38 2009,458 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,459 [30648] INFO VT - Message ->module is Faq Wed Jan 28 12:00:38 2009,460 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Faq' Wed Jan 28 12:00:38 2009,461 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,462 [30648] INFO VT - Message ->module is Products Wed Jan 28 12:00:38 2009,463 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Products' Wed Jan 28 12:00:38 2009,463 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,464 [30648] INFO VT - Message ->module is Notes Wed Jan 28 12:00:38 2009,465 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Notes' Wed Jan 28 12:00:38 2009,466 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,467 [30648] INFO VT - Message ->module is Emails Wed Jan 28 12:00:38 2009,468 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Emails' Wed Jan 28 12:00:38 2009,468 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,469 [30648] INFO VT - Message ->module is Events Wed Jan 28 12:00:38 2009,470 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Events' Wed Jan 28 12:00:38 2009,471 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,472 [30648] INFO VT - Message ->module is Activities Wed Jan 28 12:00:38 2009,473 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Activities' Wed Jan 28 12:00:38 2009,473 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,474 [30648] INFO VT - Message ->module is Vendor Wed Jan 28 12:00:38 2009,475 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Vendor' Wed Jan 28 12:00:38 2009,476 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,477 [30648] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 12:00:38 2009,478 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,479 [30648] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 12:00:38 2009,481 [30648] INFO VT - Message ->module is PriceBook Wed Jan 28 12:00:38 2009,482 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='PriceBook' Wed Jan 28 12:00:38 2009,483 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,484 [30648] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 12:00:38 2009,485 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,486 [30648] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 12:00:38 2009,489 [30648] INFO VT - Message ->module is Quotes Wed Jan 28 12:00:38 2009,489 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Quotes' Wed Jan 28 12:00:38 2009,490 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,491 [30648] INFO VT - Message ->module is Orders Wed Jan 28 12:00:38 2009,492 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Orders' Wed Jan 28 12:00:38 2009,492 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,494 [30648] INFO VT - Message ->module is SalesOrder Wed Jan 28 12:00:38 2009,494 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='SalesOrder' Wed Jan 28 12:00:38 2009,495 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,496 [30648] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 12:00:38 2009,497 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,498 [30648] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 12:00:38 2009,501 [30648] INFO VT - Message ->module is Invoice Wed Jan 28 12:00:38 2009,501 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Invoice' Wed Jan 28 12:00:38 2009,502 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,522 [30648] DEBUG Tracker - About to retrieve list: SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='17' and crmentity.deleted=0 ORDER BY id DESC Wed Jan 28 12:00:38 2009,523 [30648] DEBUG VT - Message ->query being executed : SELECT * from tracker inner join crmentity on crmentity.crmid=tracker.item_id WHERE user_id='17' and crmentity.deleted=0 ORDER BY id DESC Wed Jan 28 12:00:38 2009,523 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,527 [30648] INFO VT - Message ->module is Leads Wed Jan 28 12:00:38 2009,528 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 12:00:38 2009,529 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,530 [30648] INFO VT - Message ->getActionName 4 Wed Jan 28 12:00:38 2009,531 [30648] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 12:00:38 2009,531 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,533 [30648] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 12:00:38 2009,535 [30648] INFO VT - Message ->in getUserId 7 Wed Jan 28 12:00:38 2009,536 [30648] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 7 Wed Jan 28 12:00:38 2009,536 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,538 [30648] INFO VT - Message ->module is Leads Wed Jan 28 12:00:38 2009,539 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Leads' Wed Jan 28 12:00:38 2009,540 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,541 [30648] INFO VT - Message ->getActionName 4 Wed Jan 28 12:00:38 2009,542 [30648] DEBUG VT - Message ->query being executed : select * from profile2tab where profileid=2 Wed Jan 28 12:00:38 2009,542 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,543 [30648] DEBUG VT - Message ->getRowCount rows= 22 Wed Jan 28 12:00:38 2009,546 [30648] INFO VT - Message ->in getUserId 125 Wed Jan 28 12:00:38 2009,547 [30648] DEBUG VT - Message ->query being executed : select * from crmentity where crmid = 125 Wed Jan 28 12:00:38 2009,547 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,549 [30648] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null Wed Jan 28 12:00:38 2009,551 [30648] INFO VT - Message ->module is Users Wed Jan 28 12:00:38 2009,551 [30648] DEBUG VT - Message ->query being executed : select tabid from tab where name='Users' Wed Jan 28 12:00:38 2009,552 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,553 [30648] INFO VT - Message ->get Actionid DetailView Wed Jan 28 12:00:38 2009,554 [30648] INFO VT - Message ->action id selected is 4 Wed Jan 28 12:00:38 2009,901 [30648] DEBUG user - Retrieve User: SELECT * FROM users WHERE id = '17' Wed Jan 28 12:00:38 2009,902 [30648] DEBUG VT - Message ->query being executed : SELECT * FROM users WHERE id = '17' Wed Jan 28 12:00:38 2009,903 [30648] FATAL VT - PearDatabase ->TRANS creating new connection Wed Jan 28 12:00:38 2009,905 [30648] DEBUG VT - Message ->getRowCount rows= 1 Wed Jan 28 12:00:38 2009,909 [30648] DEBUG VT - Message ->query being executed : SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '17' and u1.deleted=0 Wed Jan 28 12:00:38 2009,909 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,911 [30648] FATAL VT - PearDatabase ->ADODB fetchByAssoc return null Wed Jan 28 12:00:38 2009,911 [30648] DEBUG user - additional detail query results: Wed Jan 28 12:00:38 2009,912 [30648] DEBUG VT - Message ->query being executed : select roleid from user2role where userid='17' Wed Jan 28 12:00:38 2009,913 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,914 [30648] DEBUG VT - Message ->query being executed : select * from role where roleid=2 Wed Jan 28 12:00:38 2009,915 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,916 [30648] DEBUG VT - Message ->query being executed : select groupname from users2group where userid='17' Wed Jan 28 12:00:38 2009,917 [30648] INFO VT - Message ->checkconnect using old connection Wed Jan 28 12:00:38 2009,918 [30648] DEBUG VT - Message ->getRowCount rows= 1 Wed Jan 28 12:00:38 2009,919 [30648] INFO layout_utils - User detail view