[Vtigercrm-developers] Sales Order > Projects

[Uma S]

Hi,

Yes, query clearly says from which we need to retrieve the records is not
mentioned soon after FROM it says limit which is wrong, even join on tables
vtiger_salesorder and vtiger_salesordercf is missed.

Control flow of the code need to be debugged to resolve this issue.

On Tue, Feb 3, 2015 at 9:13 PM, Stacey Johnson <stacey.johnson110 at gmail.com>
wrote:

> Hi Uma, see below... Is it something easy to recognize?
>
> Tue Feb  3 22:28:29 2015,637 [6184] INFO VT - PearDatabase ->ADODB error
>  Query Failed: SELECT DISTINCT
> vtiger_crmentity.crmid,vtiger_salesorder.subject,
> vtiger_salesorder.salesorder_no, vtiger_salesorder.quoteid,
> vtiger_salesorder.contactid, vtiger_crmentity.smownerid,
> vtiger_salesorder.total, vtiger_salesorder.accountid,
> vtiger_salesordercf.cf_759 FROM  LIMIT 100 , 1::->[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 100 , 1' at line 1
>
> On Tue, Feb 3, 2015 at 3:38 PM, Uma S <uma.s at vtiger.com> wrote:
>
>> Hi,
>>
>> That's good, Can you please print the query and check in sales-order
>> related-list of projects module to see how it's trying to access
>> sales-order data from projects module, so that will throw some clue to
>> solve this.
>>
>>
>> Regards
>> Uma S
>> Vtiger Team
>>
>> On Tue, Feb 3, 2015 at 1:41 PM, Stacey Johnson <
>> stacey.johnson110 at gmail.com> wrote:
>>
>>> I used this script:
>>>
>>>
>>> <?php
>>> // Turn on debugging level
>>> $Vtiger_Utils_Log = true;
>>>
>>> include_once('vtlib/Vtiger/Module.php');
>>> $moduleInstance = Vtiger_Module::getInstance('Project');
>>> $applicationsModule = Vtiger_Module::getInstance('SalesOrder');
>>> $relationLabel = 'Sales orders';
>>> $moduleInstance->setRelatedList(
>>> $applicationsModule, $relationLabel, NULL, get_dependents_list
>>> );
>>>
>>> ?>
>>>
>>> Same as other modules where all working well...
>>>
>>> Stacey
>>>
>>> On Tue, Feb 3, 2015 at 1:55 PM, Uma S <uma.s at vtiger.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> I hope you have created custom relation-ship between sales-order to
>>>> projects module, In this we need to check with api() generating
>>>> related-list, what is the query that's been getting executed?
>>>>
>>>> On Mon, Feb 2, 2015 at 9:38 PM, Stacey Johnson <
>>>> stacey.johnson110 at gmail.com> wrote:
>>>>
>>>>> Related SO to Projects but it not showing in Projects related list.
>>>>> Relation set correctly so the reason sits somewhere else.
>>>>> Any idea pls?
>>>>>
>>>>> Stacey
>>>>>
>>>>> _______________________________________________
>>>>> http://www.vtiger.com/
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> With
>>>> Best Regards
>>>> Uma.S
>>>> Vtiger Team
>>>>
>>>> _______________________________________________
>>>> http://www.vtiger.com/
>>>>
>>>
>>>
>>> _______________________________________________
>>> http://www.vtiger.com/
>>>
>>
>>
>>
>> --
>> With
>> Best Regards
>> Uma.S
>> Vtiger Team
>>
>> _______________________________________________
>> http://www.vtiger.com/
>>
>
>
> _______________________________________________
> http://www.vtiger.com/
>



-- 
With
Best Regards
Uma.S
Vtiger Team
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150203/13f09564/attachment.html>