Attribute Problems after 158 Move

[dbltoe]

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

[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.

[simon1066]

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 (products_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.

[dbltoe]

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

Attachment 20212

Is this enough of a look?

[lat9]

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

[dbltoe]

It's there for pert near ever one. 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 20213

[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.

[lat9]

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.

Do those "missing" products_id values have entries in the products_to_categories table?

[dbltoe]

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.

[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.