<![CDATA[FrontAccounting forum — Wrong SQL query in function last_sales_order_details()]]>2018-11-28T08:39:21ZPunBBhttps://frontaccounting.com/punbb/viewtopic.php?id=7845<![CDATA[Re: Wrong SQL query in function last_sales_order_details()]]>This issue has been fixed and committed to stable release. The fixed file can be downloaded here.
@apmuthu.
I guess your solution with alter tables can wait until the next major. For those needed this, they can run this solution on their databases.
/Joe
]]>https://frontaccounting.com/punbb/profile.php?id=32018-11-28T08:39:21Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=33424#p33424<![CDATA[Re: Wrong SQL query in function last_sales_order_details()]]>Can actually revert the whole commit and introduce the indices stated in my commit and commented in the original commit..]]>https://frontaccounting.com/punbb/profile.php?id=3642018-11-28T03:44:47Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=33423#p33423<![CDATA[Re: Wrong SQL query in function last_sales_order_details()]]>I see. Will commit in a while. Thanks.
Joe
]]>https://frontaccounting.com/punbb/profile.php?id=32018-11-27T16:54:20Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=33417#p33417<![CDATA[Wrong SQL query in function last_sales_order_details()]]>This commit created problem in line 635 by did not call the constant TB_PREF.]]>https://frontaccounting.com/punbb/profile.php?id=367722018-11-27T15:17:25Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=33416#p33416