Attribute Problems after 158 Move

[dbltoe]

Added one category and two products with no attributes this morning which resulted in three logs.

[16-Feb-2023 09:30:14 America/New_York] Request URI: /jetmar_Chris/index.php?cmd=attributes_controller&products_filter=8&current_category_id=22, IP address: 67.209.13.115, Language id 1
#1 require(/jetmar_Chris/attributes_controller.php) called at [/jetmar_Chris/index.php:11]
--> PHP Warning: Undefined array key "products_options_type" in /jetmar_Chris/attributes_controller.php on line 1097.

[16-Feb-2023 09:30:14 America/New_York] Request URI: /jetmar_Chris/index.php?cmd=attributes_controller&products_filter=8&current_category_id=22, IP address: 67.209.13.115, Language id 1
#1 translate_type_to_name() called at [/jetmar_Chris/attributes_controller.php:1097]
#2 require(/jetmar_Chris/attributes_controller.php) called at [/jetmar_Chris/index.php:11]
--> PHP Warning: Undefined array key "" in /jetmar_Chris/attributes_controller.php on line 602.

[dbltoe]

Just to bring all up to date....

I deleted all line items with a value of 0 in the options_id field of the products_attributes table of the database.

All is fine now.

[lat9]

Just to bring all up to date....

I deleted all line items with a value of 0 in the options_id field of the products_attributes table of the database.

All is fine now.

The real question is "How did those option_id elements with a 0-value get there in the first place?"

[dbltoe]

Agreed!

Most of them were from products added in 2016 and I was told that the person who built it passed in November of 2020.

<personal>
And, until a week after I took over the site, I didn't know the developer was a young man I'd known all his life. My wife was in his mother's wedding.
I suggested he use Zen Cart for his side business.
Early forties is way to young to go.
</personal>

He had enough knowledge that he may have done what many of us did early on in ZC. The "I can just code that in here" or "I'll just throw this in the database" only to find out later that there was the right way, the wrong way, and the Zen Cart way.

[royaldave]

Just to bring all up to date....

I deleted all line items with a value of 0 in the options_id field of the products_attributes table of the database.

All is fine now.

I have just noticed the same thing.

I added some attributes to a few products and it triggered the same warning.

And yes, a couple of the products have options_id of 0 attached.

The products investigated were added in 2020. I can't think of anything 'different' I would have done - but one theory is that these products are a copy of another and I would have used the then version of 'multiple product copy' to do this.