Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Orders Vanishing


RCHobbyAddict

Recommended Posts

Hello,

I am running osc 2.3.1. I have some problem with the orders. I do not know what happens, but sometimes some orders just vanish from the list. When I check in phpmyadmin, they are there but are not in the list.

 

Also if I search by the order id using the small box on the orders page on the top right corner, the order shows. But it is nowhere in the list.

 

What can be the possible reason?

Link to comment
Share on other sites

the reason is most probably (and you can easily check this phpmyadmin) an order_status of 0 in the database/table orders. in that case, no match is found for the join in the lookup table for statuses, and the row cannot be displayed.

 

Order status 0 can happen due to various issues/bugs in the payment modules (in the most cases), but this will need to be pinpointed individually.

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...