No Admin Orders Showing Help Please

[EuroTech]

I'm using authorize.net for my payments. That all works find. OSC is auth& capturing the payment. It shows under the main configuation that there is an order. but when i go to cusotmers -> orders there is nothing. my database has the orders there. but nothing shows in admin. How can I fix this ASAP? please help.

[EuroTech]

I'm using authorize.net for my payments. That all works find. OSC is auth& capturing the payment. It shows under the main configuation that there is an order. but when i go to cusotmers -> orders there is nothing. my database has the orders there. but nothing shows in admin. How can I fix this ASAP? please help.

 

 

I did some changes as the per things I read in here. Now the orders show up but I have no product info for the order. Everything in in the database. This stuff is killing me here. Can anyone help me please?

[Guest]

I am having the same exact problem. When I go to the admin page it shows that I have 10 clients that placed orders but when I click on the link it says I have zero orders pending. But when I go to the database it shows me the 10 orders that were placed. I just don't want to have to log into the database everytime someone places an order from my clients site. If you find anything out about this please post it.

[EuroTech]

I am having the same exact problem. When I go to the admin page it shows that I have 10 clients that placed orders but when I click on the link it says I have zero orders pending. But when I go to the database it shows me the 10 orders that were placed. I just don't want to have to log into the database everytime someone places an order from my clients site. If you find anything out about this please post it.

 

I will let you know. I'm going nuts for almost a week to figure this out.

 

 

I am having the same exact problem. When I go to the admin page it shows that I have 10 clients that placed orders but when I click on the link it says I have zero orders pending. But when I go to the database it shows me the 10 orders that were placed. I just don't want to have to log into the database everytime someone places an order from my clients site. If you find anything out about this please post it.

 

By the way, What contributions do you have installed? I think it has something to do with that.

[Guest]

have you tried the original orders.php file in the admin? Do you still get the same problem?

[EuroTech]

have you tried the original orders.php file in the admin? Do you still get the same problem?

 

Yes I did. Same issue. strange cause my orders are all in the db. i get order to show up now, but no order details are inside.

[Guest]

Ok once you put the default file, try a test order see if it goes through ok. Because works with the default osc so must be a code change that caused it.

[EuroTech]

Ok once you put the default file, try a test order see if it goes through ok. Because works with the default osc so must be a code change that caused it.

 

I tried this and still nothing.

[Guest]

I have tried everything you just said. I actually went back and did a clean install of osc and it still did it. I have no clue why either because I have installed this many times for many clients and never had a problem with it but for some reason this one just decided to start acting up and it was out of nowhere too. It was working last week and I didn't change any code since then and it just stoped showing the orders on the order page even though it would still let you know how many pending orders you have on the admin page.

[Guest]

Try this as a test, find this code in admin\orders.php

 

	if (isset($HTTP_GET_VARS['cID'])) {
  $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";
} elseif (isset($HTTP_GET_VARS['status'])) {
  $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";
} else {
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC";
}

 

change it to this:

 

	if (isset($HTTP_GET_VARS['cID'])) {
  $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id DESC";
} elseif (isset($HTTP_GET_VARS['status'])) {
  $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' order by o.orders_id DESC";
} else {
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by o.orders_id DESC";
}

 

See if it works

[EuroTech]

Try this as a test, find this code in admin\orders.php

 

	if (isset($HTTP_GET_VARS['cID'])) {
  $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by orders_id DESC";
} elseif (isset($HTTP_GET_VARS['status'])) {
  $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' and ot.class = 'ot_total' order by o.orders_id DESC";
} else {
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and ot.class = 'ot_total' order by o.orders_id DESC";
}

 

change it to this:

 

	if (isset($HTTP_GET_VARS['cID'])) {
  $cID = tep_db_prepare_input($HTTP_GET_VARS['cID']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.customers_id, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.customers_id = '" . (int)$cID . "' and o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by orders_id DESC";
} elseif (isset($HTTP_GET_VARS['status'])) {
  $status = tep_db_prepare_input($HTTP_GET_VARS['status']);
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' and s.orders_status_id = '" . (int)$status . "' order by o.orders_id DESC";
} else {
  $orders_query_raw = "select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from " . TABLE_ORDERS . " o left join " . TABLE_ORDERS_TOTAL . " ot on (o.orders_id = ot.orders_id), " . TABLE_ORDERS_STATUS . " s where o.orders_status = s.orders_status_id and s.language_id = '" . (int)$languages_id . "' order by o.orders_id DESC";
}

 

See if it works

 

Nope didnt work. It showed my orders but still no details my new orders. Also it showing the total subotal and shipping costs under the orders. Why is it showing like that?

[Guest]

ok couple of other things

 

- check if you have data in the address_format table

- check if you have data in the order_status table

 

Also try the modules->Total order make sure Total is set to true.

[Guest]

I have no clue what I did, I was just looking at the admin/includes/orders.php file and pulling all my hair out and the owner of the store called and thanked me for fixing it. I didn't know what he was talking about but when I logged back onto the site for some reason it was working again. Im not sure if there was a temp problem with the php on my hosts server but I wish you luck getting yours back up and running.

[EuroTech]

ok couple of other things

 

- check if you have data in the address_format table

- check if you have data in the order_status table

 

Also try the modules->Total order make sure Total is set to true.

 

The address_format & order_status tables have info in them. One thing I noticed is the orders_invoice_id table for my authorize.net says No Index defined! i uploaded the sql again and still the same message. Can anyone tell me whats suppose to be there?

[EuroTech]

I'm using authorize.net for my payments. That all works find. OSC is auth& capturing the payment. It shows under the main configuation that there is an order. but when i go to cusotmers -> orders there is nothing. my database has the orders there. but nothing shows in admin. How can I fix this ASAP? please help.

 

Can anyone offer any more help? I really stuck here.