[Vtigercrm-developers] Related list add record error

[Stacey Johnson]

Even in new installation i can not add sales order to related list in
projects. This part is missing in QueryGenerator.
It will be advantage to add this possibility (should be as a default
actually)

Regards
Stacey

On Mon, Feb 16, 2015 at 2:09 PM, Uma S <uma.s at vtiger.com> wrote:

> Hi,
>
> Please do check with QueryGenerator.php file which will add from tables
> for query.
>
> On Mon, Feb 16, 2015 at 11:27 AM, Stacey Johnson <
> stacey.johnson110 at gmail.com> wrote:
>
>> Need to add that this is Project Task > Sales  Order (related)
>> Just wonder which script is responsible for setting relation as you can
>> see after FROM is nothing.
>>
>> Regds
>> Stacey
>>
>> On Mon, Feb 16, 2015 at 9:46 AM, Stacey Johnson <
>> stacey.johnson110 at gmail.com> wrote:
>>
>>> Cant add record to related list and log returning below error. Where the
>>> problem might be?
>>>
>>>
>>> Mon Feb 16 09:19:54 2015,352 [7574] INFO VT - PearDatabase ->ADODB error
>>>  Query Failed: SELECT DISTINCT
>>> vtiger_crmentity.crmid,vtiger_salesorder.subject,
>>> vtiger_salesorder.salesorder_no, vtiger_salesorder.contactid,
>>> vtiger_salesorder.accountid, vtiger_crmentity.smownerid,
>>> vtiger_salesorder.total FROM  LIMIT 0,100::->[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 'LIMIT 0,100' at line 1
>>>
>>>
>>> Stacey
>>>
>>
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
>
> --
> With
> Best Regards
> Uma.S
> Vtiger Team
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150216/6e3b316a/attachment.html>