Dissappearing Order Status

[Mike_Jandreau]

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?

[♥Monika in Germany]

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

[Mike_Jandreau]

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?

[♥Monika in Germany]

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

[Mike_Jandreau]

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.

[♥Monika in Germany]

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.