♥BrockleyJohn Posted March 6, 2020 Share Posted March 6, 2020 @TomB01 One possible explanation is that you have two lots of order editor config settings and it has added the new definitions to the other config group. Try the query select configuration_group_id from configuration where configuration_key = "ORDER_EDITOR_USE_AJAX" how many rows do you get back? Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
TomB01 Posted March 6, 2020 Share Posted March 6, 2020 (edited) 5 minutes ago, BrockleyJohn said: @TomB01 One possible explanation is that you have two lots of order editor config settings and it has added the new definitions to the other config group. Try the query select configuration_group_id from configuration where configuration_key = "ORDER_EDITOR_USE_AJAX" how many rows do you get back? Edit: forget that earlier copy/paste. Looks like no rows ... Edited March 6, 2020 by TomB01 Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 6, 2020 Share Posted March 6, 2020 10 minutes ago, TomB01 said: Looks like no rows ... Try again - I can see one of that setting in your screenshot! Failing that, what do you get for select configuration_id, configuration_key, configuration_value, configuration_group_id from configuration where configuration_key like 'ORDER_EDITOR%'  Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
TomB01 Posted March 6, 2020 Share Posted March 6, 2020 1 minute ago, BrockleyJohn said: Try again - I can see one of that setting in your screenshot! Failing that, what do you get for select configuration_id, configuration_key, configuration_value, configuration_group_id from configuration where configuration_key like 'ORDER_EDITOR%'  Sorry - it was such a small result I was not recognizing it: configuration_group_id  19 Quote Link to comment Share on other sites More sharing options...
TomB01 Posted March 6, 2020 Share Posted March 6, 2020 (edited) So, somehow it's got that setting, but the Group_ID is 18 instead of 19? Is that why the setting is not showing up in my Admin? Remember that I somehow duplicated this twice - both in my test store and my live store. Answer to the later SQL: + Options     configuration_id configuration_key configuration_value configuration_group_id   Edit  Copy  Delete 656 ORDER_EDITOR_PAYMENT_DROPDOWN true 19   Edit  Copy  Delete 651 ORDER_EDITOR_ADD_PDF_INVOICE_EMAIL false 18   Edit  Copy  Delete 657 ORDER_EDITOR_USE_SPPC false 19   Edit  Copy  Delete 658 ORDER_EDITOR_USE_QTPRO false 19   Edit  Copy  Delete 659 ORDER_EDITOR_USE_AJAX true 19   Edit  Copy  Delete 660 ORDER_EDITOR_CREDIT_CARD Credit Card 19   Edit  Copy  Delete 655 ORDER_EDITOR_LIST_DIRECT_TO_EDITOR true 18 Edited March 6, 2020 by TomB01 Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 6, 2020 Share Posted March 6, 2020 15 minutes ago, TomB01 said: So, somehow it's got that setting, but the Group_ID is 18 instead of 19? Is that why the setting is not showing up in my Admin? Remember that I somehow duplicated this twice - both in my test store and my live store. Answer to the later SQL: + Options     configuration_id configuration_key configuration_value configuration_group_id   Edit  Copy  Delete 656 ORDER_EDITOR_PAYMENT_DROPDOWN true 19   Edit  Copy  Delete 651 ORDER_EDITOR_ADD_PDF_INVOICE_EMAIL false 18   Edit  Copy  Delete 657 ORDER_EDITOR_USE_SPPC false 19   Edit  Copy  Delete 658 ORDER_EDITOR_USE_QTPRO false 19   Edit  Copy  Delete 659 ORDER_EDITOR_USE_AJAX true 19   Edit  Copy  Delete 660 ORDER_EDITOR_CREDIT_CARD Credit Card 19   Edit  Copy  Delete 655 ORDER_EDITOR_LIST_DIRECT_TO_EDITOR true 18 I guess you have been installing and uninstalling. You have somehow added the new settings to config group 18 instead of 19. Simply edit the config group for the second and last rows to 19. TomB01 1 Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 6, 2020 Share Posted March 6, 2020 The code checks which config group ORDER_EDITOR_USE_AJAX is in but it doesn't check if there's more than one occurrence of it (hence my original question). TomB01 1 Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
TomB01 Posted March 6, 2020 Share Posted March 6, 2020 Yep - already changed those rows. It's possible there was some installing/uninstalling. If you go back further in this thread, there were some corrections you made for me when I originally attempted the installs. Maybe it was both of us. 😉 In any event, this removes a huge headache for me! Many, many thanks!  Quote Link to comment Share on other sites More sharing options...
artfulweb Posted March 17, 2020 Share Posted March 17, 2020 Hello John, in Phoenix v1.0.5.4 I am getting this (otherwise the rest is OK) Warning: Illegal string offset 'products_id' in /xx/xx/xx/xx/admin/order_editor/cart.php on line 35 lines 29-36 are: Â Â Â Â $subindex = 0; Â Â Â Â $att_array = []; Â Â Â Â $attributes_query = tep_db_query("select products_options, products_options_values, options_values_price, price_prefix from orders_products_attributes where orders_id = '" . (int)$orders_id . "' and orders_products_id = '" . (int)$products['orders_products_id'] . "'"); Â Â Â Â if (tep_db_num_rows($attributes_query)) { Â Â Â Â Â while ($attributes = tep_db_fetch_array($attributes_query)) { Â Â Â Â Â Â $option_id = sew_get_products_options_id($attributes['products_options']); Â Â Â Â Â Â $value_id = sew_get_products_options_values_id($option_id,$attributes['products_options_values'],0,$orders_products['products_id']); Â Â Â Â Â Â $att_array[$option_id] = $value_id; Â Â Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 17, 2020 Share Posted March 17, 2020 @artfulweb that's a bug, change the line to $value_id = sew_get_products_options_values_id($option_id,$attributes['products_options_values'],0,$products['products_id']); ie. $products['products_id'] not $orders_products['products_id']  Mac2256 1 Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
artfulweb Posted March 17, 2020 Share Posted March 17, 2020 9 minutes ago, BrockleyJohn said: @artfulweb that's a bug, change the line to $value_id = sew_get_products_options_values_id($option_id,$attributes['products_options_values'],0,$products['products_id']); ie. $products['products_id'] not $orders_products['products_id']  Thanks John, just perfect! Thanks for all your work keeping this addon updated. Can't do without it! Quote Link to comment Share on other sites More sharing options...
artfulweb Posted March 21, 2020 Share Posted March 21, 2020 Hi John, me again. Updated manually Phoenix to 1.0.5.5 and now Order Editor has disappeared. The order tabs revert back to having no more order editor buttons so I am not sure if it is the bootstrap button that now is used or if the problem goes deeper. Just so you know, as I know you are already very busy... Quote Link to comment Share on other sites More sharing options...
rupruprup Posted March 26, 2020 Share Posted March 26, 2020 (edited) I am building a shop based on Phoenix 1.0.5.5 but it seems that the order editor won't install .... Edited March 26, 2020 by rupruprup Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 26, 2020 Share Posted March 26, 2020 4 minutes ago, rupruprup said: I am building shop based on Phoenix 1.0.5.5 but it seems that the order editor won't install .... Do you mean you have tried and it failed - or are you just asking about the previous comment? I believe the install is ok but the Edit button on the orders page has disappeared. @artfulweb replace the file includes/hooks/admin/siteWide/listOrders.php with the attached and the edit button will appear in the list view (if the setting says do it). I need to design a solution for the single order view that will also work for all phoenix versions to keep installation simple. listOrders.php Mac2256 1 Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
rupruprup Posted March 27, 2020 Share Posted March 27, 2020 thank you, the addon is essential for me ... Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 27, 2020 Share Posted March 27, 2020 @artfulweb @rupruprup for 1.0.5.5 to get the edit button on view order, replace the file includes/modules/hooks/admin/orders_edit_order.php with the attached orders_edit_order.php Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
artfulweb Posted March 27, 2020 Share Posted March 27, 2020 11 minutes ago, BrockleyJohn said: @artfulweb @rupruprup for 1.0.5.5 to get the edit button on view order, replace the file includes/modules/hooks/admin/orders_edit_order.php with the attached orders_edit_order.php Hi John, is it supposed to be in includes/modules/hooks/admin/orders/ or just includes/modules/hooks/admin/ Quote Link to comment Share on other sites More sharing options...
artfulweb Posted March 27, 2020 Share Posted March 27, 2020 Deleted includes/modules/hooks/admin/orders/ and just put in includes/modules/hooks/admin/ Thanks! Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 27, 2020 Share Posted March 27, 2020 2 minutes ago, artfulweb said: Deleted includes/modules/hooks/admin/orders/ and just put in includes/modules/hooks/admin/ Thanks! @artfulweb for both buttons on 1.0.5.5 there are two files to replace /includes/modules/hooks/admin/orders_edit_order.php /includes/hooks/admin/orders/edit_orders.php no new files Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
artfulweb Posted March 27, 2020 Share Posted March 27, 2020 Thanks John! Quote Link to comment Share on other sites More sharing options...
rupruprup Posted March 27, 2020 Share Posted March 27, 2020 thank you, I will try it now Quote Link to comment Share on other sites More sharing options...
rupruprup Posted March 27, 2020 Share Posted March 27, 2020 the button works fine now and the config menu installed correctly but I cannot edit orders there are just 3 fields to enter and edit the customer addresses .... Â Â Â Quote Link to comment Share on other sites More sharing options...
♥BrockleyJohn Posted March 27, 2020 Share Posted March 27, 2020 Quote Contact me for work on updating existing stores - whether to Phoenix or the new osC when it's released. Looking for a payment or shipping module? Maybe I've already done it. Working on generalising bespoke solutions for Quickbooks integration, Easify integration and pay4later (DEKO) integration at 2.3.x Link to comment Share on other sites More sharing options...
dculley Posted March 27, 2020 Share Posted March 27, 2020 I took down Phoenix and did a clean start of 1.0.5.5. Well as clean as it can be. I'm trying to bring it up to speed with Order Edit app this weekend. My question is: Has anyone update the app on oscommers products for order edit for Phoenix version? Not sure if I can put all the above messages together to work. I'm just not that smart. Is there an OE that will work with Phoenix that will allow you use it with phone call ordering? add customers when needed. Change the order. Issue RMA's. Update shipping $ and do a new or update billing with customer payment method. Quote Link to comment Share on other sites More sharing options...
rupruprup Posted March 27, 2020 Share Posted March 27, 2020 Â @BrockleyJohn the complete part below the address fields is missing ... Â Â Quote Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.