Attribute Problems after 158 Move

158 latest github with update of old database
PHP 8
responsive_classic clone
OPC latest github
No URL, problem in admin

The old database has 156 products that do not show in the categories/products nor do they show with a search. All are products_status 0 but it appears that SOMEHOW they may be being used by the owner to modify other products' attributes. Getting the followin errors:

[15-Feb-2023 10:12:53 America/New_York] Request URI: /frammer1/index.php?cmd=category_product_listing&cPath=38&pID=101&action=attribute_features_copy_to_product&page=1&products_id=101, IP address: ***.***.***.***, Language id 1#1 require(/frammer1/category_product_listing.php) called at [/frammer1/index.php:11]
--> PHP Warning: Undefined array key "copy_attributes" in /frammer1/category_product_listing.php on line 1133.
**********************


[15-Feb-2023 10:12:32 America/New_York] Request URI: /frammer1/index.php?cmd=category_product_listing&action=update_attributes_copy_to_product&cPath=38&page=1, IP address: ***.***.***.***, Language id 1
#1 require(/frammer1/category_product_listing.php) called at [/frammer1/index.php:11]
--> PHP Warning: Undefined array key "products_id" in /frammer1/category_product_listing.php on line 281.
************************


[15-Feb-2023 10:11:06 America/New_York] Request URI: /frammer1/index.php?cmd=attributes_controller&products_filter=101&current_category_id=38, IP address: ***.***.***.***, Language id 1
#1 require(/frammer1/attributes_controller.php) called at [/frammer1/index.php:11]
--> PHP Warning: Undefined array key "products_options_type" in /frammer1/attributes_controller.php on line 1097.


[15-Feb-2023 10:11:06 America/New_York] Request URI: /frammer1/index.php?cmd=attributes_controller&products_filter=101&current_category_id=38, IP address: ***.***.***.***, Language id 1
#1 translate_type_to_name() called at [/frammer1/attributes_controller.php:1097]
#2 require(/frammer1/attributes_controller.php) called at [/frammer1/index.php:11]
--> PHP Warning: Undefined array key "" in /frammer1/attributes_controller.php on line 602.
******************************************

Guidance appreciated.

THANX

Using the site's phpMyAdmin, what results come back from the following query?

SELECT pa.*
                                     FROM (proucts_attributes pa
                                     LEFT JOIN products_options po ON pa.options_id = po.products_options_id
                                       AND po.language_id = 1)
                                     WHERE pa.products_id = 101
                                     ORDER BY LPAD(po.products_options_sort_order,11,'0'),
                                              LPAD(pa.options_id,11,'0'),
                                              LPAD(pa.products_options_sort_order,11,'0')

P.S. I'm *assuming *that the site's database doesn't use table-prefixes.

lat9:

Using the site's phpMyAdmin, what results come back from the following query?

SELECT pa.*
FROM (proucts_attributes pa
LEFT JOIN products_options po ON pa.options_id = po.products_options_id
AND po.language_id = 1)
WHERE pa.products_id = 101
ORDER BY LPAD(po.products_options_sort_order,11,'0'),
LPAD(pa.options_id,11,'0'),
LPAD(pa.products_options_sort_order,11,'0')

> P.S. I'm *assuming *that the site's database doesn't use table-prefixes.

Little typo,

SELECT pa.*
FROM (pro[B]d[/B]ucts_attributes pa
LEFT JOIN products_options po ON pa.options_id = po.products_options_id
AND po.language_id = 1)
WHERE pa.products_id = 101
ORDER BY LPAD(po.products_options_sort_order,11,'0'),
LPAD(pa.options_id,11,'0'),
LPAD(pa.products_options_sort_order,11,'0')

Edit: just noticed it was for @dbltoe, who would have realised this.

:blush:
Actually, I didn't until I threw it in navicat and it balked.

[Attachment no longer available]

Is this enough of a look?

It is! What's with that first record, with an *options_id *of 0; that can't be valid!

It's there for pert near ever one.:unsure: Thought it strange myself but the cart works until you mess with any attribute and you cannot search from the categories/products page and then alt < without a notice that things went "bump""

[Attachment no longer available]

Store owner says he got it from the developer that way.

There are also 98 product_id listings in the products directory with not a one of them being found by ID search in the admin.:dontgetit

dbltoe:

Store owner says he got it from the developer that way.

There are also 98 product_id listings in the products directory with not a one of them being found by ID search in the admin.:dontgetit
Do those "missing" products_id values have entries in the products_to_categories table?

I find 156 items in the products table with a products_status of 0 that have a setting in the categories_id in the products_to_categories table.

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.

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.

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.
The real question is "How did those option_id elements with a 0-value get there in the first place?"

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.

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.:P

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.

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.