I just received 2 orders on one of my customer website, built with OSC 2.2, Cre-loaded, but the client did not receive the Purchase order.
When we verified in the admin area, for the clients order, we received this error.
Orders Order ID:
Status: All OrdersPendingProcessingDeliveredPaypal ProcessingAllow DownloadOn HoldCanceledAwaiting CC Processing
Customers Order Total Date Purchased Status Action
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 '-10, 10' at line 1
select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, [url removed, login to view], o.currency_value, s.orders_status_name, [url removed, login to view] as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.customers_id = '59' and o.orders_status = s.orders_status_id and s.language_id = '1' and [url removed, login to view] = 'ot_total' order by orders_id DESC limit -10, 10
We need this fixed ASAP.
Đã trao cho:
7 freelancer đang chào giá trung bình $63 cho công việc này
Let Me make it. Having enough experience with OSC. Done many work in OSC for design integration and Bug Fixing. More in pmb kindly chek it. -Thanking you Andey.
As a professional, you cannot afford to let this problem persist. Choose a provider who can guarantee rapid problem resolution or your money-back. Is your business worth it?
HI, We can provide best solution for your site.We are expert in developing of opensources like PHPBB, Mambo,zencart,Oscommerce,Tikiwiki.... Please see our site: www.extremewebworld.com thanks sandeep