account_history.php

[cigcode]

when i go to account_history.php my history are not there can anyone tell me why? am i missing something? all i get is

 

Displaying 0 to 0 (of 0 orders) Result Pages: -4 -3 -2 -1 0

 

any help

[Guest]

check order_status table, see if pending, delivered, etc is in there. if not open up a backup sql and see what you had in there before.

[cigcode]

ok i have this

 

1 1 Pending

2 1 Processing

3 1 Delivered

4 1 Updated

99999 1 Paypal Processing

 

any help? i dont think this has been working from start.. from what i know

[Guest]

if a new install, i would reinstall the database

[cigcode]

thats the thing its not a new install.. i have users data in the db.. i learned about this from an email from one of the current users on the site.. :( any other way? btw thank you for your help!

[cigcode]

anyone :( from what i see this here...

 

 $history_query_raw = "select o.orders_id, o.date_purchased, o.delivery_name, o.billing_name, ot.text as order_total, s.orders_status_name from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot, " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$customer_id . "' and o.orders_id = ot.orders_id and ot.class = 'ot_total' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id DESC";
   
$history_split = new splitPageResults($history_query_raw, MAX_DISPLAY_ORDER_HISTORY);
   $history_query = tep_db_query($history_split->sql_query);

 

is running fine but.. when it gets to the while loops that is where it halts

[cigcode]

common man.. will anyone please help me all i want to do is get this working that is all, please :( any ideas?

[tdupres]

I have the exact same problem, as do many other members. I'm not having much luck with this and I'm thinking about getting rid of that section in the customer account box! If I can?

I can see all the orders placed but not by the individual?

[cigcode]

ok let me work at it for a few more if i get someware i will post it back here again :(

[Guest]

I have the same problem. I notice that the table order_status remains completely empty even after orders are placed. The table order_status_history is filled with order data.

 

The query searching for past orders from a given customer uses the empty order_status table. Perhaps this is why it is returning 0 records.

[Guest]

I had mistakenly emptied the data from the order_status table. I refilled my order_status table with

 

INSERT INTO orders_status VALUES (1, 1, 'Pending');

INSERT INTO orders_status VALUES (2, 1, 'Processing');

INSERT INTO orders_status VALUES (3, 1, 'Delivered');

 

and everything works perfectly now.

[tdupres]

Hi

 

I have got my oreders working!! They apear in four separate rows when viewed in admin but I'm calling that a feature! :D

 

Basically I uploaded the original orders.php, removed the ot.class line of code, and now it works! The only thing I skiped was running the query in phpmyadmin!

 

It now work and as I don't have to update it I am leaving it as is until it becomes a problem.

 

I hope it continues to work.

 

Here is the forum:

 

http://www.oscommerce.com/forums/index.php?showtopic=41103&hl=