Edit Orders v4.0 Support Thread

[twinkiejr]

Thanks got it I hope.

[mydanilo]

lhungil

I ran the query you pm'd me.

configuration_id configuration_title configuration_key configuration_value configuration_description configuration_group_id sort_order last_modified date_added use_function set_function
1737 IH version IH_VERSION 4.3.1 IH Version is stored but not shown on configuration menus 0 10000 2013-08-26 12:46:37 2013-08-26 12:46:37 NULL NULL
1847 Third Party Inventory Plugin GOOGLE_PRODUCTS_SWITCH_STOCK_PLUGIN none Does your system use a third party plugin for managing variant/attribute inventory? Select the plugin used or leave as 'none' for default action: 0 560 NULL 2013-08-26 13:21:05 NULL zen_cfg_select_drop_down(array(array('id' => 'none', 'text' => 'none'), array('id' => 'stockbyattributes', 'text' => 'Stock By Attributes'), array('id' => 'numinixproductvariants', 'text' => 'Numinix Product Variants')),

[mydanilo]

search for PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED

/includes/functions/functions_lookups.php

Line #231 : if (PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' and $not_readonly == 'true') {

renamedadminfolder/includes/classes/attributes.php

Line #206 : if(PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' && $readonly === false) {

Line #256 : if(PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' && $readonly === false) {

renamedadminfolder//includes/functions/general.php

Line #2024 : if (PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' and $not_readonly == 'true') {
-----------------------------

For: PRODUCTS_OPTIONS_TYPE_READONLY

includes/functions/functions_lookups.php

Line #231 : if (PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' and $not_readonly == 'true') {

Line #235 : where pa.products_id = '" . (int)$products_id . "' and po.products_options_type != '" . PRODUCTS_OPTIONS_TYPE_READONLY . "' limit 1";

/includes/modules/attributes.php

Line #180 : if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #486 : if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #552 : case ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY):

renamedadmin/edit_orders.php

Line #992 : case PRODUCTS_OPTIONS_TYPE_READONLY:

Line #1532 : case PRODUCTS_OPTIONS_TYPE_READONLY:

renamedadmin/includes/attributes_preview.php

Line #173 : if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_FILE or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_TEXT or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_CHECKBOX or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_RADIO or $products_options->RecordCount() == 1 or $products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #484 : if ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #550 : case ($products_options_names->fields['products_options_type'] == PRODUCTS_OPTIONS_TYPE_READONLY):

renamedadmin/includes/classes/attributes.php

Line #27 : function get_attribute_options_values_by_type($zf_product_id, $options_type = PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #98 : function get_attribute_options_names_by_type($zf_product_id, $options_type = PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #155 : function get_attributes_options_by_type($zf_product_id, $options_type = PRODUCTS_OPTIONS_TYPE_READONLY) {

Line #206 : if(PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' && $readonly === false) {

Line #207 : $query .= 'AND opt.products_options_type != \'' . PRODUCTS_OPTIONS_TYPE_READONLY . '\' ';

Line #256 : if(PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' && $readonly === false) {

Line #257 : $query .= 'AND opt.products_options_type != \'' . PRODUCTS_OPTIONS_TYPE_READONLY . '\' ';

renamedadmin/includes/functions/general.php

Line #2024 : if (PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED == '1' and $not_readonly == 'true') {

Line #2028 : where pa.products_id = '" . (int)$products_id . "' and po.products_options_type != '" . PRODUCTS_OPTIONS_TYPE_READONLY . "' limit 1";

[Bruce_m]

Have just installed this Plugin having used it on an earlier version.
Currently on v1.5.1 with the 'Big Royal Mail' shipping modules installed.

When I go to edit an order the shipping options are shown as below:



I have checked and feel sure I have uploaded everything correctly. Is this a conflict of the two plugins an can it be fixed?
Thanks in advance.

[DivaVocals]

Have just installed this Plugin having used it on an earlier version.
Currently on v1.5.1 with the 'Big Royal Mail' shipping modules installed.

When I go to edit an order the shipping options are shown as below:



I have checked and feel sure I have uploaded everything correctly. Is this a conflict of the two plugins an can it be fixed?
Thanks in advance.

Can't see the teeny tiny image you posted.. So don't know what the issue is at the moment..

[mydanilo]

I went back to my test install with a different db and set of products but the same mods installed. I just added new options and option values to a product and the behavior is the same as previously reported when editing orders, no selectable options on step 3 when adding products to orders. It must be something in the combination of mods that screws things up (mistake in merging maybe).

[lhungil]

...
I ran the query (select * from configuration where configuration_group_id='0').
...

It looks like some required attribute entries are missing from your Zen Cart database. You should take a look at the link lat9 posted earlier: "Attribute Required for Text flag not working" (and add the missing entries back into the database).

search for PRODUCTS_OPTIONS_TYPE_READONLY_IGNORED
...

You should see something like the following letting you know what the configured value for those entries are in your database. If you do not find these (you can see they are used in many places by Zen Cart and this module)... Something has happened to your Zen Cart installation to remove core database entries (required for attributes to function)... If you do find them, what are they set to?

Attachment 13127

Note: If these are missing, there may be other things broken / missing in your database (or installation)...

[DivaVocals]

It looks like some required attribute entries are missing from your Zen Cart database. You should take a look at the link lat9 posted earlier: "Attribute Required for Text flag not working" (and add the missing entries back into the database).


You should see something like the following letting you know what the configured value for those entries are in your database. If you do not find these (you can see they are used in many places by Zen Cart and this module)... Something has happened to your Zen Cart installation to remove core database entries (required for attributes to function)... If you do find them, what are they set to?

Attachment 13127

Note: If these are missing, there may be other things broken / missing in your database (or installation)...

and this goes back to what both lat9 and I have both posted suggested.. the MOST likely cause is an errant SQL install file from one of his other modules which has removed the configuration table entries.. The post that lat9 posted clearly outlines the kind of errant SQL that would cause this.

[Bruce_m]

Can't see the teeny tiny image you posted.. So don't know what the issue is at the moment..

Hope this is a little clearer.

[DivaVocals]

Hope this is a little clearer.

NO ONE can SEE these images.. the detail is too small.. Why don't you simply STATE what the issue is.. it will be SOOOOOOO much easier...

from what you've posted thus far, the issue is with the Big Royal Mail' shipping module. You are either SEEING or NOT SEEING something when you click the shpping dropdown.. What is it you are SEEING or NOT SEEING, and what is it you expect to see or not see instead??