json data from server could not be parsed served side processing with php

sitsum

HI there i am having some issue with the server side processing with php mysql.

50% of the time the same piece of code would work perfectly. However, the other 50% of the time it will rise the "json data from server could not be parsed" error/warming.

here is an example of the data the jason data that it was trying to render:

didnt work: {"sEcho":8,"SQLQuery":"\r\n\tSELECT COUNT(enqId)\r\n\tFROM `enquiry`\r\nLEFT JOIN `client` ON `enqClientId` = `clientId`\r\nLEFT JOIN `user` ON `enqUserId` = `userId`\r\nLEFT JOIN `enqStatus` ON `enqEnqStatusId` = `enqStatusId`\r\nLEFT JOIN `owner` ON `enqOwnerId` = `ownerId`\r\nLEFT JOIN `financeproduct` ON `enqProductId` = `fpId`\r\nLEFT JOIN `financier` ON `enqFinancierId` = `financierId`\r\nLEFT JOIN `deal` ON `dealEnqId` = `enqId`\r\nLEFT JOIN `adwordstracker` ON `enqId` = `adwordsTrackerEnqId`\r\nLEFT JOIN `quoteSent` ON `quoteSentEnqId` = `enqId` \r\n","iTotalRecords":"25336","iTotalDisplayRecords":"1","aaData":[{"0":" NEW<\/span>","DT_RowId":"27153","1":"27153","2":"","3":"David","4":"Mckey","5":"Sam Sit","6":"New","7":"ALP<\/label>","8":null,"9":"","10":"24\/07\/13 02:51:21 PM","11":"25\/07\/13<\/label>","12":"27\/07\/13","13":"<\/div>","14":"<\/label><\/div>","15":"","16":""}]}

Worked: {"sEcho":11,"SQLQuery":"\r\n\tSELECT COUNT(enqId)\r\n\tFROM `enquiry`\r\nLEFT JOIN `client` ON `enqClientId` = `clientId`\r\nLEFT JOIN `user` ON `enqUserId` = `userId`\r\nLEFT JOIN `enqStatus` ON `enqEnqStatusId` = `enqStatusId`\r\nLEFT JOIN `owner` ON `enqOwnerId` = `ownerId`\r\nLEFT JOIN `financeproduct` ON `enqProductId` = `fpId`\r\nLEFT JOIN `financier` ON `enqFinancierId` = `financierId`\r\nLEFT JOIN `deal` ON `dealEnqId` = `enqId`\r\nLEFT JOIN `adwordstracker` ON `enqId` = `adwordsTrackerEnqId`\r\nLEFT JOIN `quoteSent` ON `quoteSentEnqId` = `enqId` \r\n","iTotalRecords":"25336","iTotalDisplayRecords":"1","aaData":[{"0":" NEW<\/span>","DT_RowId":"27153","1":"27153","2":"","3":"David","4":"Mckey","5":"Sam Sit","6":"New","7":"ALP<\/label>","8":null,"9":"","10":"24\/07\/13 02:51:21 PM","11":"25\/07\/13<\/label>","12":"27\/07\/13","13":"<\/div>","14":"<\/label><\/div>","15":"","16":""}]}

the only difference that i can spot between the 2 set of data above is the value of sEcho, but i cant see how that would cause the Json data error.

sitsum

help!!!!!!