Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Dissappearing Order Status


Mike_Jandreau

Recommended Posts

I run an online store for my dad's small collectible's shop, which hardly gets any traffic, until this time of year for the holidays.

 

I ran a "sale" contrib today, and marked everything down, great. I then placed a test order (just to make sure everything still works), great.

 

However, when I update the order to any of the order statuses that I created, it defaults to order_status 0, and the "status" on "orders.php" shows blank, in the admin panel.

 

I'm guessing that maybe something's corrupt in the database, but I ran a "repair" on all tables, and nothing came up as wrong, or broken.

 

I also tried deleting the statuses that I listed, and adding new ones, they do the same thing.

 

Any ideas what would cause this?

www.moviesnobs.net - Reel Reviews, Real Viewers
Link to comment
Share on other sites

if this happens on orders.php, I'd compare that field to a vanilla one.

:-)

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

No luck. Replaced the "orders.php" and "orders_status.php" with clean versions, still does the same thing.

 

Now, when I change an order status, it changes to 0, and then dissappears from the orders list, until I go into phpMyAdmin, and reset it to a real order value.

 

Any other ideas?

www.moviesnobs.net - Reel Reviews, Real Viewers
Link to comment
Share on other sites

when debugging, you have to test a gazillion things as you know.

 

what I'd do next:

 

1) check if the history table is filled with the bogus values only, or the order row in orders table also

 

2) setup your statuses correctly again, then open an order in edit mode and view source code. Check if the dropdown has the correct ids for text -> value

:-)

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

1) History has good values for anything I don't change manually in the database. If I change it from orders.php, it goes to the default of 0, which is, as we know, nothing.

 

2) It won't allow me to set up any new statuses, when I try, they get saved as a blank status, with a new number corresponding to them in the database.

The numbers on "Orders.php" show correctly. But when I select one of those options, it defaults back to 0 for some reason.

 

I'm thinking I should just do a clean install, but that'd be a lot of work. Maybe I'll wait for 3.0 to come out.

 

Thanks anyway.

www.moviesnobs.net - Reel Reviews, Real Viewers
Link to comment
Share on other sites

that does not sound like the right way, but if it's yours go for it. Wait for 3.0 that is really funny! we are at alpha3 and it has still a bunch of bugs.

 

and you certainly did not understand my 1)

 

a change in orders.php normally makes a new entry in the history table AND changes the orders table

 

if you cannot create or update your statuses, and have compared all relevant root files, there is still a lot of otehr options to check. Like debugging the insert/update code. Of course if your shop is new, reinstall.

:-)

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...