• From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Topic: Wrong SQL query in function last_sales_order_details()

This commit created problem in line 635 by did not call the constant TB_PREF.

Phuong

notrinos's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Wrong SQL query in function last_sales_order_details()

I see. Will commit in a while. Thanks.

Joe

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

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..

apmuthu's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

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