Quote Originally Posted by armytags.com View Post
My greetings to the edit orders team.

I just changed of server my website with zen cart. These are the data of my instalation and server:
Zen Cart 1.5.1
Data Base: MySQL 5.5.30
Versión PHP: 5.3.3 (Zend: 2.3.0)

The problem is when I am adding products to an order already placed since the admin page, I get the next error shown in the log:

[19-Jun-2019 19:00:46] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into
zen_orders_products_attributes set

The table zen_orders_products_attributes has the same parameters in my previous server, and never appeared that error. I checked it. "products_prid" had no default value and it still worked. So what is the cause of this error now? Any advice?

Thanks in advance.
You don't say which version of Edit Orders that you're using, but given that you're running on zc1.5.1 it's most likely a no-longer-supported version.

My best guess is that your new server has a more strict version of MySQL installed as that's where the fatal error you identified will come from.