[Vtigercrm-developers] Related list add record error

Uma S uma.s at vtiger.com
Mon Feb 16 07:09:57 GMT 2015


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20150216/82b038da/attachment-0001.html>


More information about the vtigercrm-developers mailing list