Edit Orders v4.0 Support Thread

[athena]

Thanks... i was on my way there for SBA... cool...

[swguy]

I could swear the new sanitizers in 155a + latest Github EO are not playing well. Am I crazy?

[lat9]

I could swear the new sanitizers in 155a + latest Github EO are not playing well. Am I crazy?

A little more information would certainly help; how are they not playing well?

[swguy]

I'll do an install on a clean system shortly and report back. Wasn't sure if anyone else had tried it and had bad results so I wanted to check first.

Update later: Dup'ed; see post below.

[swguy]

Does it make sense to pull the latest from https://github.com/lat9/edit_orders and call that the 1.5.4 version so we can get on with updating for 1.5.5? (last update to this plugin was 01/14 for 1.5.3.)

[swguy]

OK, I can repro the issue. What's happening is that on the 4th step (Add Now), on the default database with test products, I get correct attributes and options:

<input type='submit' value='Add now'><input type="hidden" name="id[3][value]" value="8"><input type="hidden" name="id[3][type]" value="0">

but on my database, these fields have been damaged:

<input type='submit' value='Add now'><input type="hidden" name="id[26]" value="Array"><input type="hidden" name="id[27]" value="Array">

(which creates empty values in orders_products_attributes.

So going back a step, on the default database in step 3, I get

<label class="attribsSelect" for="attrib-3">Model</label><select rel="dropdown" name="id[3][value]" id="attrib-3">

and on my database, I get

<label class="attribsSelect" for="attrib-27">Mounting Orientation:</label><select rel="dropdown" name="id[27][value]" id="attrib-27">

which looks the same to me.

Gets into init_sanitize fine, but goes from ./includes/classes/AdminRequestSanitizer.php into filterSimpleAlphanumPlus which clobbers the array (line 335).

It looks like on my side, the ParameterDefinitions array does not include the entry for MULTI_DIMENSIONAL.

[swguy]

One thing that looks interesting - why does admin/includes/extra_datafiles/eo_sanitization.php add an array entry for "update_products"
but not for add_prdct ? (I tried that and it didn't fix my issue but it's still curious.)

[lat9]

@swguy, you say you're using the demo products, but there's no option named "Mounting Options". If you could identify the specifics of the product and its attributes that you're trying to add to the order, I could probably help.

I'm also not sure what you mean by:

It looks like on my side, the ParameterDefinitions array does not include the entry for MULTI_DIMENSIONAL.

... although, in reviewing the sanitization array (in /ADMIN/includes/extra_datafiles/eo_sanitization.php) there's an entry for the update_order path, but not one for the add_prdct one.

[lat9]

OK, got one. Tried to add the "Big Linked" version of "A Bug's Life ..." entered all the attributes, clicked "Add" and came back to the same screen (with debug-logs generated). At this point, I've got something to work with and will report back when I've got a solution.

[mc12345678]

OK, I can repro the issue. What's happening is that on the 4th step (Add Now), on the default database with test products, I get correct attributes and options:

<input type='submit' value='Add now'><input type="hidden" name="id[3][value]" value="8"><input type="hidden" name="id[3][type]" value="0">

but on my database, these fields have been damaged:

<input type='submit' value='Add now'><input type="hidden" name="id[26]" value="Array"><input type="hidden" name="id[27]" value="Array">

(which creates empty values in orders_products_attributes.

So going back a step, on the default database in step 3, I get

<label class="attribsSelect" for="attrib-3">Model</label><select rel="dropdown" name="id[3][value]" id="attrib-3">

and on my database, I get

<label class="attribsSelect" for="attrib-27">Mounting Orientation:</label><select rel="dropdown" name="id[27][value]" id="attrib-27">

which looks the same to me.

Gets into init_sanitize fine, but goes from ./includes/classes/AdminRequestSanitizer.php into filterSimpleAlphanumPlus which clobbers the array (line 335).

It looks like on my side, the ParameterDefinitions array does not include the entry for MULTI_DIMENSIONAL.

@swguy, you say you're using the demo products, but there's no option named "Mounting Options". If you could identify the specifics of the product and its attributes that you're trying to add to the order, I could probably help.

Morning lat9. Looks like a comparison of operation is being performed between a default zc store and a "live" store, which is the "my database" version. Considering the timing of the discussion and issues, should also note that there appears to be something amiss with the products_attributes table or related with that database as a change to another plugin was required to address sort orders of attributes. That change required not using the sort order provided by routine query to the products_attributes table and instead to use the sort order provided by the products_options_values table. A suggestion was made to correct the issue with the products_attributes table, the status of which is unknown, but alternate software (for more than one reason) was sought.

Or perhaps it *is* something else as the issue can occur in the default database.