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:
Code:
[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¤t_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¤t_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
Re: Attribute Problems after 158 Move
Using the site's phpMyAdmin, what results come back from the following query?
Code:
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.
Re: Attribute Problems after 158 Move
Quote:
Originally Posted by
lat9
Using the site's phpMyAdmin, what results come back from the following query?
Code:
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,
Code:
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.
1 Attachment(s)
Re: Attribute Problems after 158 Move
:blush:
Actually, I didn't until I threw it in navicat and it balked.
Attachment 20212
Is this enough of a look?
Re: Attribute Problems after 158 Move
It is! What's with that first record, with an options_id of 0; that can't be valid!
1 Attachment(s)
Re: Attribute Problems after 158 Move
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 20213
Re: Attribute Problems after 158 Move
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
Re: Attribute Problems after 158 Move
Quote:
Originally Posted by
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?
Re: Attribute Problems after 158 Move
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.
Re: Attribute Problems after 158 Move
Added one category and two products with no attributes this morning which resulted in three logs.
Code:
[16-Feb-2023 09:30:14 America/New_York] Request URI: /jetmar_Chris/index.php?cmd=attributes_controller&products_filter=8¤t_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¤t_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.
