Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.
what does this mean in this instance, and how do i resolve it ASAP?
Array (  => INSERT INTO dwtphovu_8347379386_test.6_serviceleads TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttributes, TSL.timestamp_ExpectedBy, TSL.text_LeadMessage, TSL.bigint_ServiceID, TSL.bigint_SupplierID, TSL.bigint_RegionID, TSL.tinyint_LeadSent, TSL.timestamp_LeadCreated, TSL.text_Duplicates ) SELECT bigint_LeadID, text_Consumer, text_LeadAttributes, timestamp_ExpectedBy, text_LeadMessage, bigint_ServiceID, bigint_SupplierID, ( SELECT TR.bigint_RegionID FROM dwtphovu_8347379386_test.1_regions TR, dwtphovu_8347379386_prod.1_regions PR WHERE CONCAT("%",UPPER(PR.text_RegionDescription),"%") LIKE CONCAT("%",UPPER(TR.text_RegionDescription),"%") AND PR.bigint_RegionID = PSL.bigint_RegionID ) AS bigint_RegionID, tinyint_LeadSent, timestamp_LeadCreated, text_LeadSubject FROM dwtphovu_8347379386_prod.6_serviceleads PSL;  => ERROR #1064: 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 'TSL ( TSL.bigint_LeadID, TSL.text_Consumer, TSL.text_LeadAttribu' at line 2 in /home/dwtphovu/public_html/intellisource.co.za/test_8347379386/db_synchronizer.php on Line 57 )
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
13 Experts available now in Live!