[Vtigercrm-developers] Sales Order > Projects

[Uma S]

Sorry! Migration will not cause any affect on this.

On Wed, Feb 4, 2015 at 12:36 PM, Stacey Johnson <stacey.johnson110 at gmail.com
> wrote:

> 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/
>>
>
>
> _______________________________________________
> 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/20150204/aab53af7/attachment.html>