--------------------- Testing Class:: TMailJonesTrigger import_id = 6940 dealer_id = 9 name = HD Automotive customer_id = 2878 dealer_id = 10 name = Landers Toyota customer_id = 2599 ----- OrderNames ------ ----- CheckForCompleteLists ------ Have detail_list Tracking number= 87F9296441743A74BBA3F1F03400AC47 error: PropelException Object ( [cause:protected] => SQLException Object ( [userInfo:protected] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' [nativeError:protected] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACK' at line 1 [message:protected] => Could not execute query [Native Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACK' at line 1] [User Info: SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47'] [string:private] => [code:protected] => 0 [file:protected] => E:\php\PEAR\symfony\vendor\creole\drivers\mysql\MySQLConnection.php [line:protected] => 202 [trace:private] => Array ( [0] => Array ( [file] => E:\php\PEAR\symfony\addon\creole\drivers\sfDebugConnection.php [line] => 167 [function] => executeQuery [class] => MySQLConnection [type] => -> [args] => Array ( [0] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' [1] => 2 ) ) [1] => Array ( [file] => E:\php\PEAR\symfony\vendor\creole\common\PreparedStatementCommon.php [line] => 333 [function] => executeQuery [class] => sfDebugConnection [type] => -> [args] => Array ( [0] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' [1] => 2 ) ) [2] => Array ( [file] => E:\php\PEAR\symfony\vendor\propel\util\BasePeer.php [line] => 452 [function] => executeQuery [class] => PreparedStatementCommon [type] => -> [args] => Array ( [0] => 2 ) ) [3] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\lib\model\om\BaseWebserviceOrderPeer.php [line] => 237 [function] => doSelect [class] => BasePeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( [0] => webservice_order.WEBSERVICE_ORDER_ID [1] => webservice_order.WEBSERVICE_USER_ID [2] => webservice_order.CUSTOMER_ID [3] => webservice_order.PRODUCT_ID [4] => webservice_order.WEBSERVICE_TRACKING_ID [5] => webservice_order.WEBSERVICE_ORDER_TYPE_ID [6] => webservice_order.WEBSERVICE_ORDER_CRITERIA_ID [7] => webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID [8] => webservice_order.ORDER_DATE [9] => webservice_order.AGGREGATION_ID [10] => webservice_order.VALID_YN [11] => webservice_order.PROCESSING_YN [12] => webservice_order.PROCESSED_YN [13] => webservice_order.PROCESSED_DATE [14] => webservice_order.FILE_NAME [15] => webservice_order.ORDER_NAMES_COUNT [16] => webservice_order.PULL_ID ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) [1] => sfDebugConnection Object ( [childConnection:private] => MySQLConnection Object ( [database:private] => datawarehouse [transactionOpcount:protected] => 0 [dblink:protected] => Resource id #116 [dsn:protected] => Array ( [database] => datawarehouse [encoding] => utf8 [hostspec] => betty [password] => leash4all [persistent] => 1 [phptype] => mysql [port] => 3306 [protocol] => [username] => totouser ) [flags:protected] => 1 [lastQuery] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' ) [numQueriesExecuted:private] => 9 [lastExecutedQuery:private] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' ) ) ) [4] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\lib\model\om\BaseWebserviceOrderPeer.php [line] => 221 [function] => doSelectRS [class] => BaseWebserviceOrderPeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) [1] => ) ) [5] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\trig\TMail\TMailJonesTrigger_v1_00.class.php [line] => 338 [function] => doSelect [class] => BaseWebserviceOrderPeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) ) ) [6] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\trig\TMail\TMailJonesTrigger_v1_00.class.php [line] => 57 [function] => CheckForCompleteLists [class] => TMailJonesTrigger [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\test_tmail.php [line] => 63 [function] => Execute [class] => TMailJonesTrigger [type] => -> [args] => Array ( [0] => Array ( [trig_rule_id] => 11 ) ) ) ) ) [message:protected] => [wrapped: Could not execute query [Native Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACK' at line 1] [User Info: SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47']] [string:private] => [code:protected] => 0 [file:protected] => E:\php\PEAR\symfony\vendor\propel\util\BasePeer.php [line:protected] => 458 [trace:private] => Array ( [0] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\lib\model\om\BaseWebserviceOrderPeer.php [line] => 237 [function] => doSelect [class] => BasePeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( [0] => webservice_order.WEBSERVICE_ORDER_ID [1] => webservice_order.WEBSERVICE_USER_ID [2] => webservice_order.CUSTOMER_ID [3] => webservice_order.PRODUCT_ID [4] => webservice_order.WEBSERVICE_TRACKING_ID [5] => webservice_order.WEBSERVICE_ORDER_TYPE_ID [6] => webservice_order.WEBSERVICE_ORDER_CRITERIA_ID [7] => webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID [8] => webservice_order.ORDER_DATE [9] => webservice_order.AGGREGATION_ID [10] => webservice_order.VALID_YN [11] => webservice_order.PROCESSING_YN [12] => webservice_order.PROCESSED_YN [13] => webservice_order.PROCESSED_DATE [14] => webservice_order.FILE_NAME [15] => webservice_order.ORDER_NAMES_COUNT [16] => webservice_order.PULL_ID ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) [1] => sfDebugConnection Object ( [childConnection:private] => MySQLConnection Object ( [database:private] => datawarehouse [transactionOpcount:protected] => 0 [dblink:protected] => Resource id #116 [dsn:protected] => Array ( [database] => datawarehouse [encoding] => utf8 [hostspec] => betty [password] => leash4all [persistent] => 1 [phptype] => mysql [port] => 3306 [protocol] => [username] => totouser ) [flags:protected] => 1 [lastQuery] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' ) [numQueriesExecuted:private] => 9 [lastExecutedQuery:private] => SELECT webservice_order.WEBSERVICE_ORDER_ID, webservice_order.WEBSERVICE_USER_ID, webservice_order.CUSTOMER_ID, webservice_order.PRODUCT_ID, webservice_order.WEBSERVICE_TRACKING_ID, webservice_order.WEBSERVICE_ORDER_TYPE_ID, webservice_order.WEBSERVICE_ORDER_CRITERIA_ID, webservice_order.WEBSERVICE_ADDR_VERIFICATION_ID, webservice_order.ORDER_DATE, webservice_order.AGGREGATION_ID, webservice_order.VALID_YN, webservice_order.PROCESSING_YN, webservice_order.PROCESSED_YN, webservice_order.PROCESSED_DATE, webservice_order.FILE_NAME, webservice_order.ORDER_NAMES_COUNT, webservice_order.PULL_ID FROM webservice_order = webservice_tracking ON (webservice_order.WEBSERVICE_TRACKING_ID=webservice_tracking.WEBSERVICE_TRACKING_ID) WHERE webservice_tracking.TRACKING_NUMBER='87F9296441743A74BBA3F1F03400AC47' ) ) ) [1] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\lib\model\om\BaseWebserviceOrderPeer.php [line] => 221 [function] => doSelectRS [class] => BaseWebserviceOrderPeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) [1] => ) ) [2] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\trig\TMail\TMailJonesTrigger_v1_00.class.php [line] => 338 [function] => doSelect [class] => BaseWebserviceOrderPeer [type] => :: [args] => Array ( [0] => Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) ) ) [3] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\trig\TMail\TMailJonesTrigger_v1_00.class.php [line] => 57 [function] => CheckForCompleteLists [class] => TMailJonesTrigger [type] => -> [args] => Array ( ) ) [4] => Array ( [file] => E:\Program Files\Apache Software Foundation\Apache2.2\htdocs\us2_inm\inmproject\batch\test_tmail.php [line] => 63 [function] => Execute [class] => TMailJonesTrigger [type] => -> [args] => Array ( [0] => Array ( [trig_rule_id] => 11 ) ) ) ) ) C = Criteria Object ( [ignoreCase:private] => [singleRecord:private] => [selectModifiers:private] => Array ( ) [selectColumns:private] => Array ( ) [orderByColumns:private] => Array ( ) [groupByColumns:private] => Array ( ) [having:private] => [asColumns:private] => Array ( ) [joins:private] => Array ( [0] => Join Object ( [leftColumn:private] => webservice_order.WEBSERVICE_TRACKING_ID [rightColumn:private] => webservice_tracking.WEBSERVICE_TRACKING_ID [joinType:private] => = ) ) [dbName:private] => propel [originalDbName:private] => [limit:private] => 0 [offset:private] => 0 [blobFlag:private] => [aliases:private] => Array ( ) [useTransaction:private] => [map:private] => Array ( [webservice_tracking.TRACKING_NUMBER] => Criterion Object ( [value:private] => 87F9296441743A74BBA3F1F03400AC47 [comparison:private] => = [table:private] => webservice_tracking [realtable:private] => webservice_tracking [column:private] => TRACKING_NUMBER [ignoreStringCase:private] => [db:private] => DBMySQL Object ( ) [clauses:private] => Array ( ) [conjunctions:private] => Array ( ) [parent:private] => ) ) ) Bad query