Sedang Disiapkan

OSCommerce SNQ syntax fix

On admin page,

Here are pending orders, but if you click it, got the page

Orders Order ID:

Status: All OrdersPendingProcessingDelivered

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 '-20, 20' at line 1

select o.orders_id, o.customers_name, 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.orders_status = s.orders_status_id and s.language_id = '1' and s.orders_status_id = '1' and [url removed, login to view] = 'ot_total' order by o.orders_id DESC limit -20, 20

Please fix it asap while keeping the pending order info

Kemahiran: Troli Membeli-belah

Lihat lebih lanjut: you fix it, the fix it, fix it at, error on page fix, syntax, desc, sql syntax error, sql select order, mysql sql syntax, fix line, fix server error oscommerce orders, sql syntax, oscommerce click, error 1064, mysql error 1064, pending order status, click oscommerce, fix text, sql error 1064 mysql, server fix, check sql, fix asap, mysql server error, text check mysql, order status mysql

Tentang Majikan:
( 29 ulasan ) issaquah, United States

ID Projek: #376992