Getting Undefined Index Error When Saving a Product

/home/sentawebikondri/storage/modification/

straightlight wrote: ↑

Thu Jun 21, 2018 10:11 pm

/home/sentawebikondri/storage/modification/

Caused by an installed extension. Ensure that the declared indexed fields still exists on the database product table.

seanstorm100 wrote: ↑

Sat Jan 04, 2020 8:14 pm

Hi straightlight,

I got a similar error: PHP Notice: Undefined index: option_value_id in /storage/modification/admin/model/catalog/product.php on line 199
I checked the DB and I am seeing product_option_value_id, I also ran a check on the Database, all Tables returned OK. Do you have any other insights on this? This is actually the first time I am getting these errors (2 duplicates at the same time) but I do have a multivendor extension (updated 02-01-20), auto-assign related products extension (installed 02-01-20), x-shipping (2 Months), and email verification (2 weeks). I recently installed vQmod (On Thursday).
This error came about while I was sleeping and I am the only one that has access to the store as it is not yet public. Could it be that an assigned option longer exists in the DB?

I am using OC Default, 3.0.3.2
Thank you!

straightlight wrote: ↑

Thu Jun 21, 2018 10:11 pm

/home/sentawebikondri/storage/modification/

Caused by an installed extension. Ensure that the declared indexed fields still exists on the database product table.

straightlight wrote: ↑

Sat Jan 04, 2020 9:33 pm

seanstorm100 wrote: ↑

Sat Jan 04, 2020 8:14 pm

Hi straightlight,

I got a similar error: PHP Notice: Undefined index: option_value_id in /storage/modification/admin/model/catalog/product.php on line 199
I checked the DB and I am seeing product_option_value_id, I also ran a check on the Database, all Tables returned OK. Do you have any other insights on this? This is actually the first time I am getting these errors (2 duplicates at the same time) but I do have a multivendor extension (updated 02-01-20), auto-assign related products extension (installed 02-01-20), x-shipping (2 Months), and email verification (2 weeks). I recently installed vQmod (On Thursday).
This error came about while I was sleeping and I am the only one that has access to the store as it is not yet public. Could it be that an assigned option longer exists in the DB?

I am using OC Default, 3.0.3.2
Thank you!

straightlight wrote: ↑

Thu Jun 21, 2018 10:11 pm

Caused by an installed extension. Ensure that the declared indexed fields still exists on the database product table.

You are seeing the product_option_value_id on the database table but do you actually see the option_value_id as well? If not, undefined index means that the field itself could either not be queried or found on the database table itself.

straightlight wrote: ↑

Sat Jan 04, 2020 9:33 pm

seanstorm100 wrote: ↑

Sat Jan 04, 2020 8:14 pm

Hi straightlight,

I got a similar error: PHP Notice: Undefined index: option_value_id in /storage/modification/admin/model/catalog/product.php on line 199
I checked the DB and I am seeing product_option_value_id, I also ran a check on the Database, all Tables returned OK. Do you have any other insights on this? This is actually the first time I am getting these errors (2 duplicates at the same time) but I do have a multivendor extension (updated 02-01-20), auto-assign related products extension (installed 02-01-20), x-shipping (2 Months), and email verification (2 weeks). I recently installed vQmod (On Thursday).
This error came about while I was sleeping and I am the only one that has access to the store as it is not yet public. Could it be that an assigned option longer exists in the DB?

I am using OC Default, 3.0.3.2
Thank you!

straightlight wrote: ↑

Thu Jun 21, 2018 10:11 pm

Caused by an installed extension. Ensure that the declared indexed fields still exists on the database product table.

You are seeing the product_option_value_id on the database table but do you actually see the option_value_id as well? If not, undefined index means that the field itself could either not be queried or found on the database table itself.

/storage/modification/admin/model/catalog/product.php on line 199

198 - foreach ($product_option['product_option_value'] as $product_option_value) {
199 - 	$this->db->query("INSERT INTO " . DB_PREFIX . "product_option_value SET product_option_value_id = '" . 
                (int)$product_option_value['product_option_value_id'] . "', product_option_id = '" . (int)$product_option_id . "', product_id = '" . (int)$product_id . "', 
                option_id = '" . (int)$product_option['option_id'] . "', option_value_id = '" . (int)$product_option_value['option_value_id'] . "', quantity = '" .                                                 
                (int)$product_option_value['quantity'] . "', subtract = '" . (int)$product_option_value['subtract'] . "', price = '" . (float)$product_option_value['price'] . "', 
                price_prefix = '" . $this->db->escape($product_option_value['price_prefix']) . "', points = '" . (int)$product_option_value['points'] . "', points_prefix = '" . 
                $this->db->escape($product_option_value['points_prefix']) . "', weight = '" . (float)$product_option_value['weight'] . "', weight_prefix = '" . $this->db- 
                >escape($product_option_value['weight_prefix']) . "'");
                
200                	}
201					}
202				} else {
203					$this->db->query("INSERT INTO " . DB_PREFIX . "product_option SET product_option_id = '" . (int)$product_option['product_option_id'] . "', product_id = '" . (int)$product_id . "', option_id = '" . (int)$product_option['option_id'] . "', value = '" . $this->db->escape($product_option['value']) . "', required = '" . (int)$product_option['required'] . "'");
204				}
205			}
206		}

letxobnav wrote: ↑

Sat Jan 04, 2020 11:32 pm

undefined index means that the variable is used as a pointer to an array value but that pointer does not exist.
as in $x = $data['y']; and there is no $data['y'] defined/present.

/storage/modification/admin/model/catalog/product.php on line 199

better state what is on line 199 so you know if it comes from a database query or from the data array passed to the function which in turn may come from the post array from the product form.

as it is a modified file, you only know what is on line 199.

straightlight wrote: ↑

Sun Jan 05, 2020 2:50 am

The provided screenshot links are invalid from your previous post.

letxobnav wrote: ↑

Sun Jan 05, 2020 6:56 am

Then this is the array reference giving the warning:

Code: Select all

(int)$product_option_value['option_value_id']

there is no pointer 'option_value_id' present in array $product_option_value which is referenced when trying to insert the record in the product_option_value table.

array $product_option_value comes from array $product_option['product_option_value'] and
$product_option['product_option_value'] comes from array $data['product_option']

So that is not a database field/index issue but most likely an extension problem as the $data array is passed to the function editProduct when saving a product.
In other words, the data passed to the function in $data['product_option'] is not complete.

you could trace it by placing

Code: Select all

$this->log->write(print_r($data['product_option'],true));

just after

Code: Select all

if (isset($data['product_option'])) {

then check your oc error log

if (isset($data['product_option'])) {

seanstorm100 wrote: ↑

Sun Jan 05, 2020 7:59 am

Thanks letxobnav,

I will add that and place the errors when they come back. I haven't seen them again since morning.

letxobnav wrote: ↑

Sun Jan 05, 2020 6:56 am

Then this is the array reference giving the warning:

Code: Select all

(int)$product_option_value['option_value_id']

there is no pointer 'option_value_id' present in array $product_option_value which is referenced when trying to insert the record in the product_option_value table.

array $product_option_value comes from array $product_option['product_option_value'] and
$product_option['product_option_value'] comes from array $data['product_option']

So that is not a database field/index issue but most likely an extension problem as the $data array is passed to the function editProduct when saving a product.
In other words, the data passed to the function in $data['product_option'] is not complete.

you could trace it by placing

Code: Select all

$this->log->write(print_r($data['product_option'],true));

just after

Code: Select all

if (isset($data['product_option'])) {

then check your oc error log

letxobnav wrote: ↑

Sun Jan 05, 2020 4:20 pm

you can do both, one is in the function to add a product and one in the function to edit the product (update).

it should list out the entire options record structure in your oc error log so you can see the variables used/missing like:

Code: Select all

2020-01-05 16:19:10 - Array
(
    [0] => Array
        (
            [product_option_id] => 299
            [name] => Gift Bag Options
            [option_id] => 14
            [type] => checkbox
            [required] => 0
            [product_option_value] => Array
                (
                    [0] => Array
                        (
                            [option_value_id] => 61
                            [product_option_value_id] => 164
                            [quantity] => 0
                            [subtract] => 0
                            [price_prefix] => +
                            [price] => 30.0000
                            [points_prefix] => +
                            [points] => 0
                            [weight_prefix] => +
                            [weight] => 0.00000000
                        )

                    [1] => Array
                        (
                            [option_value_id] => 62
                            [product_option_value_id] => 165
                            [quantity] => 0
                            [subtract] => 0
                            [price_prefix] => +
                            [price] => 60.0000
                            [points_prefix] => +
                            [points] => 0
                            [weight_prefix] => +
                            [weight] => 0.00000000
                        )

                )

        )

)