[Vtigercrm-developers] Sales Order > Projects

[Stacey Johnson]

Sure, I am just concerned as this showed after migration from 6.1 to 6.2

Regards
Stacey


On Wed, Feb 4, 2015 at 12:36 AM, Uma S <uma.s at vtiger.com> wrote:

> 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
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150204/d228c2fe/attachment.html>