You're correct, @mc12345678; I'm having a bad day!
Printable View
You're correct, @mc12345678; I'm having a bad day!
Sorry to hear, if it helps any, take an inventory: let's see pulse, check. No loss of appendages today, check. Haven't poked my eyes out, check. Whew, could be worse. :)Quote:
Originally Posted by lat9
Now I can't speak to the interoperability, but like so many of the other things posted, I've been reading along and that one caught my eye. Not to mention that when I've merged that file on other's servers I always ask myself, why was it done that way?
Anyways, bound to get better. :)
Just wondering...has anyone figured this out yet? It seems as though the processing just gets cut off each time. Would it be a memory problem?
Quote:
Originally Posted by jvdd
@jvdd, a memory issue would be my guess. Check your store's /logs directory for some myDEBUG-adm-*.log file(s) on/around the time you attempted to update that order.
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.Quote:
Originally Posted by armytags.com
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.
My apologies:
Edit Orders 4.0.4.
"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."
Ok, and how can I solve it? upgrading edit orders?
Thanks for your answer.
Check your store's /logs directory for myDEBUG-adm-*.log files created on/about the time that the EO order-update failed. Post the contents of the file located using 'CODE' tags (the big # in the menu-bar when you're writing a post) and be sure to xxx-out the name of your admin sub-directory as I'm sure that it's part of the debug-log.
Ok. I think I got it. My apologies if I don't follow well your requests.
This was the first one (I' ll explain later) when I tried to add an item to an order:
After doing some research, and reading some posts about that error 1364, I went to the DB with PHP admin, located the table "zen_orders_products_attributes", changed the default value of "products_prid" to NULL and tried again. Then it gave me an error message again, but this time I checked the order and the product was added to the order. I checked the myDEBUG log and found this message:Code:[20-Jun-2019 03:37:33] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into zen_orders_products set
orders_id = 12094,
products_id = 3,
products_model = '',
products_name = 'Order Pair of Silencers Black',
products_price = '1.5000',
final_price = '1.5',
products_tax = '0',
products_quantity = 1,
onetime_charges = 0; in /storage/xxxx/xxxx/xxxxxxx/public_html/xxxxx/includes/classes/db/mysql/query_factory.php on line 120
After receiving that message I changed the default value to NONE again, because I wasn't sure if that change could affect the normal placing of orders by the website. Should I change it back to some value to avoid this problem?Code:[20-Jun-2019 03:40:32] PHP Fatal error: 1364:Field 'products_prid' doesn't have a default value :: insert into zen_orders_products_attributes set
orders_id = 12094,
orders_products_id = 2731,
products_options = 'Silenciadores',
products_options_values = 'Negro',
options_values_price = '0.0000',
products_options_id = '2',
products_options_values_id = '4',
price_prefix = '',
product_attribute_is_free = '0',
products_attributes_weight = '0',
products_attributes_weight_prefix = '',
attributes_discounted = '0',
attributes_price_base_included = '0',
attributes_price_onetime = '0.0000',
attributes_price_factor = '0.0000',
attributes_price_factor_offset = '0.0000',
attributes_price_factor_onetime = '0.0000',
attributes_price_factor_onetime_offset = '0.0000',
attributes_qty_prices = '',
attributes_qty_prices_onetime = '',
attributes_price_words = '0.0000',
attributes_price_words_free = '0',
attributes_price_letters = '0.0000',
attributes_price_letters_free = '0'; in /xxxxxx/xxxx/xxx/xxxxxxx/public_html/xxxxx/includes/classes/db/mysql/query_factory.php on line 120
The options are: NONE, PERSONALIZED, NULL and CURRENT TIMESTAMP.
Thanks again for your answers.
@armytags.com, I'd thought that your posting of EO 4.0.4 was a typo as EO's current version is 4.4.0!
If you are you really running on Zen Cart 1.5.1 with EO 4.0.4, you'll need to update your Zen Cart so that you can have the benefit of all the changes and corrections over the past 7 years and then also update your Edit Orders installation to use the current version.
Although changing the database schema might get you past the symptom of the error you're experiencing, it's not addressing the root-cause of the issue (code should, and now does, set that required field) and has the possibility of causing follow-on issues when you do upgrade.