Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

HELP!!!! Order History won't come up!!


Recommended Posts

I have looked high and low and can't find the answer to this problem. It seems like I am the only one going through it. I get the following error when I login and when you go to order history:


1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX' at line 1


select distinct op.products_id from orders o, orders_products op, products p where o.customers_id = '2' and o.orders_id = op.orders_id and op.products_id = p.products_id and p.products_status = '1' group by products_id order by o.date_purchased desc limit MAX_DISPLAY_PRODUCTS_IN_ORDER_HISTORY_BOX




That comes up when you first login. Then when you go to Order History this is what I get:


1064 - You have an error in your SQL syntax near 'MAX_DISPLAY_ORDER_HISTORY' at line 1


select o.orders_id, o.date_purchased, o.delivery_name, ot.text as order_total, s.orders_status_name from orders o left join orders_total ot on (o.orders_id = ot.orders_id) left join orders_status s on (o.orders_status = s.orders_status_id and s.language_id = '1') where o.customers_id = '2' and ot.class = 'ot_total' order by orders_id DESC limit 0, MAX_DISPLAY_ORDER_HISTORY




Here you can see the problem below:




and here is the error with the order history:




Here is the information on my server:


Server OS: Linux 2.4.16C12_V Database: MySQL 3.23.38

Server Date: 02/26/2003 11:29:40 Datebase Date: 02/26/2003 11:29:40

Server Up Time: 11:29am up 3 days, 20:54, 1 user, load average: 0.01, 0.09, 0.09


HTTP Server: Apache

PHP Version: 4.0.6 (Zend: 1.0.6)


Hardware: COBALT RAQ 550


This is all the information I can possible provide about this. If anybody can please give me some feedback as to what might be causing this.. or start me in the right direction.. or have the solution.. ANYTHING.. it will be much appreciated!


Thank You :!: :!: :!:

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...