Issue

2011-12-23 12:13:31,292[Thread-16]ERROR SubscriptionXmlService -Failed to query account : com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'source' in 'field list'
java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'source' in 'field list'
     at com.infuze.service.subscription.workflow.SubscriptionAddonWorkflow.executeProcess
     at com.infuze.service.workflow.WorkflowExecutor.execute(WorkflowExecutor.java:24)
     at com.infuze.service.subscription.xml.SubscriptionXmlService.addon(SubscriptionXmlService.java:262)
     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at com.livrona.xhttpi.XHttpInvoker.execute(Unknown Source)
     at com.infuze.server.service.XmlServiceActionHandler.execute(XmlServiceActionHandler.java:28)
     at com.livrona.haxe.server.RequestHandler.executeRequest(RequestHandler.java:149)
     at com.livrona.haxe.server.RequestHandler.run(RequestHandler.java:77)<!>

Answer

This exception is caused when the field name specified in the select sql clause does not exists in the database. To resolve this simply fix your SQL select query to use the correct field name that exits in the table or add the missing field as referred in the SQL select query to the database table if it is required.