Printable View
I have v1.5.1 with the classic template
I installed edit-order about a year ago and it worked fine.
I wanted to change an order today but the "edit" button is not showing up?
I looked in the configuration tab and edit -order is there.
Could I have switched off the edit-order somewhere? Sorry for the dumb question.
I looked for th e"how to use" but don't find that :(
I uploaded the edit-order files with ftp and now I have the "edit" button again :smile:.Quote:
Originally Posted by marton_1
When I click the edit button the edit template shows up OK.
When I edit something and click update I get an error message.
The error log shows
The Products_id` = '668' is correctCode:[25-Dec-2015 23:17:37 Europe/Zurich] PHP Fatal error: 1054:Unknown column 'p.products_quantity' in 'field list' :: SELECT `p`.`products_quantity` FROM `products` WHERE `p`.`products_id` = '668' in /home/httpd/vhosts/simmar.ch/httpdocs/catalog/includes/classes/db/mysql/query_factory.php on line 120
Is there some way I can force the config.eo_onetime.php to run again? Or is that not a good idea
This is how Products_id` = '668' row looks in the products table
I had not made any changes to my original files in the 1_modified_core_files section. So I just uploaded the new files from the add-on/plug-in; no merging required :)
I see when I added a new product to an order that works but th eorder value is not updated :(
I activated the edit orders log "Trace" and got this
============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 1108
Action Requested: edit
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_loworderfee;ot_gv;o t_total
============================================================Code:============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 1108
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_loworderfee;ot_gv;ot_total
Requested Products:
array (
250 =>
array (
'qty' => '1',
'name' => 'Den Winter Parka mit Fellkragen',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '2887',
'type' => '2',
),
1 =>
array (
'value' => '2896',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '49.90',
),
251 =>
array (
'qty' => '2',
'name' => 'Strickpullover Elch',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '3086',
'type' => '2',
),
1 =>
array (
'value' => '3092',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '24.90',
),
252 =>
array (
'qty' => '1',
'name' => 'Strickpullover Elch',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '3086',
'type' => '2',
),
1 =>
array (
'value' => '3091',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '24.90',
),
253 =>
array (
'qty' => '1',
'name' => 'Strickpullover Elch',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '3086',
'type' => '2',
),
1 =>
array (
'value' => '3096',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '24.90',
),
254 =>
array (
'qty' => '2',
'name' => 'Strickpullover Elch',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '3089',
'type' => '2',
),
1 =>
array (
'value' => '3092',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '34.90',
),
255 =>
array (
'qty' => '1',
'name' => 'Den Winter Parka mit Fellkragen',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '2887',
'type' => '2',
),
1 =>
array (
'value' => '2896',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '49.90',
),
275 =>
array (
'qty' => '1',
'name' => 'Puppy Angel Down Kapuze und Kustfel Padded Vest, regular OW240',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '7911',
'type' => '2',
),
1 =>
array (
'value' => '7915',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '79.90',
),
)
============================================================
= Processing Requested Updates to Products
============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 1108
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_loworderfee;ot_gv;o t_total
With debug Product I get
============================================================
= Edit Orders (4.1.4) Action Log
============================================================
Order ID: 1108
Action Requested: update_order
Enabled Order Totals: ot_subtotal;ot_shipping;ot_coupon;ot_group_pricing;ot_tax;ot_loworderfee;ot_gv;o t_total
Code:0 =>
array (
'option' => 'Grosse',
'value' => '30cm',
'option_id' => '2',
'value_id' => '268',
'prefix' => '+',
'price' => '12.0000',
),
1 =>
array (
'option' => 'Farbe',
'value' => 'Fuchsia',
'option_id' => '1',
'value_id' => '75',
'prefix' => '+',
'price' => '0.0000',
),
),
),
6 =>
array (
'qty' => 1,
'id' => '1906',
'name' => 'Puppy Angel Down Kapuze und Kustfel Padded Vest, regular OW240',
'model' => '',
'tax' => '0.0000',
'price' => '79.9000',
'final_price' => '79.9000',
'onetime_charges' => '0.0000',
'products_priced_by_attribute' => '0',
'product_is_free' => '0',
'products_discount_type' => '0',
'products_discount_type_from' => '0',
'attributes' =>
array (
0 =>
array (
'option' => 'Grosse',
'value' => 'ML',
'option_id' => '2',
'value_id' => '769',
'prefix' => '+',
'price' => '0.0000',
),
1 =>
array (
'option' => 'Farbe',
'value' => 'Grau',
'option_id' => '1',
'value_id' => '71',
'prefix' => '+',
'price' => '0.0000',
),
),
),
)
Order Product ID: 250 Row ID: 0
Product in Request:
array (
'qty' => 1,
'name' => 'Den Winter Parka mit Fellkragen',
'onetime_charges' => '0.0000',
'attr' =>
array (
2 =>
array (
'value' => '2890',
'type' => '2',
),
1 =>
array (
'value' => '2896',
'type' => '2',
),
),
'model' => '',
'tax' => '0',
'final_price' => '49.90',
)
Old Product:
array (
'qty' => 1,
'id' => '668',
'name' => 'Den Winter Parka mit Fellkragen',
'model' => '',
'tax' => '0.0000',
'price' => '37.9000',
'final_price' => '49.9000',
'onetime_charges' => '0.0000',
'products_priced_by_attribute' => '0',
'product_is_free' => '0',
'products_discount_type' => '0',
'products_discount_type_from' => '0',
'attributes' =>
array (
0 =>
array (
'option' => 'Grosse',
'value' => '30cm',
'option_id' => '2',
'value_id' => '268',
'prefix' => '+',
'price' => '12.0000',
),
1 =>
array (
'option' => 'Farbe',
'value' => 'Silber',
'option_id' => '1',
'value_id' => '31',
'prefix' => '+',
'price' => '0.0000',
),
),
)
Old Order Subtotal: 269.2000
Old Order Totals:
array (
0 =>
array (
'title' => 'Zwischensumme:',
'text' => 'CHF 269,20',
'class' => 'ot_subtotal',
),
1 =>
array (
'title' => 'Versandkosten:',
'text' => 'CHF 0,00',
'class' => 'ot_shipping',
),
2 =>
array (
'title' => 'Endsumme:',
'text' => 'CHF 269,20',
'class' => 'ot_total',
),
)
Old Tax (total): 0.00
Old Tax Groups:
array (
)
That's a "known bug". You'll need to edit the file /YOUR_ADMIN/includes/functions/extra_functions/edit_orders_functions.php. Change the line that reads:Quote:
Originally Posted by marton_1
toCode:'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS .
Code:'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` AS `p`' .
Thank you very much for your reply, even on Christmas weekend!
Your fix solved the problem that I reported but now I have
Oh dear :(Code:"26-Dec-2015 21:21:50 Europe/Zurich] PHP Fatal error: Call to undefined function zen_product_in_category() in /home/httpd/vhosts/simmar.ch/httpdocs/catalog/admin/includes/functions/extra_functions/edit_orders_functions.php on line 326
I changed the name of my admin folder!!
Yeah, but those that have tagged ths thread to follow any of the previus 815 messages possibly received a copy of it. Would recommend changing the actual admin folder path. As for the missing function, sounds like a missing file in the functions directory. Going to do a "local" search first to advise which file(s) to reload to the store.Quote:
Originally Posted by marton_1
Yeah, looks like there might be something amiss with: includes/functions/functions_categories.phpQuote:
Originally Posted by marton_1
Thanks. please do give me advice about any possible missing file :)Quote:
Originally Posted by mc12345678
I did change the actual admin folder path :) I blame too much post Christmas wine :)
Hmmm, the file
You said to check and the file includes/functions/functions_categories.php was missing; I loaded it up and got
There seem to be a number of files missing in my shop that were there a year ago :(Code:[26-Dec-2015 23:17:06 Europe/Berlin] PHP Fatal error: Call to undefined function zen_product_in_category() in C:\xampp\htdocs\zencart151\--admin---\includes\functions\extra_functions\edit_orders_functions.php on line 326
No clue why?