Edit Orders v4.0 Support Thread

[marton_1]

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

[marton_1]

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 .

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

[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

The Products_id` = '668' is correct
Is there some way I can force the config.eo_onetime.php to run again? Or is that not a good idea

[marton_1]

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 :)

[marton_1]

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

============================================================
= 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

   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 (
)

[lat9]

I uploaded the edit-order files with ftp and now I have the "edit" button again .

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

[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

The Products_id` = '668' is correct
Is there some way I can force the config.eo_onetime.php to run again? Or is that not a good idea

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:

'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS .

to

'SELECT `p`.`products_quantity` FROM `' . TABLE_PRODUCTS . '` AS `p`' .

[marton_1]

Thank you very much for your reply, even on Christmas weekend!
Your fix solved the problem that I reported but now I have

"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

Oh dear

I changed the name of my admin folder!!

[mc12345678]

Thank you very much for your reply, even on Christmas weekend!
Your fix solved the problem that I reported but now I have

"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

Oh dear

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.

[mc12345678]

Thank you very much for your reply, even on Christmas weekend!
Your fix solved the problem that I reported but now I have

"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

Oh dear

I changed the name of my admin folder!!

Yeah, looks like there might be something amiss with: includes/functions/functions_categories.php

[marton_1]

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.

Thanks. please do give me advice about any possible missing file :)

I did change the actual admin folder path :) I blame too much post Christmas wine :)

[marton_1]

Hmmm, the file

You said to check and the file includes/functions/functions_categories.php was missing; I loaded it up and got

[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

There seem to be a number of files missing in my shop that were there a year ago

No clue why?