Jump to content

DB: does the "Valid" field in the ps_orders table has a relationships with other tables?


ballashop

Recommended Posts

Hi,

I noticed in the back end that some orders gave € 0.00 on the label: "total paid from registration" even if the order is complete and shipped.

1712728473_totalpay.thumb.png.6e6c856d07712c99a43f1621ef9a1911.png


Via query on the db:
SELECT * FROM ps_orders WHERE reference = "ordernumber";
and I found a field called "valid" the value was 0.

835785799_validfield.thumb.png.af7964eae7b6fe961534bbb057daf0fc.png

UPDATE `ps_orders` SET` valid` = '1' WHERE `ps_orders`.`id_order` = orderid;
After making the change to 1, the data reappeared:

 

1749665992_totalpayshowing.png.b32d84fae73af20063c8ba02be6450e2.png


I would like to ask the community if this change can affect other tables, if there are relationships with this data so it would be better not to change it.
Thanks for any reply.

Balla

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...