I am having a problem, whereby going into catalog–>product features, then editing a product feature, I select the categories tab and click “add to categories”. It does nnot work. Inittially this problem began with us saving categories we added to the feature. If we then edited the feature again and checked, the categories we added were gone. So they appeared to save but did not actually save.
Then only 1 user account had the problem where they logged into edit a productfeature and add categories, but when they clicked “add categories” the grayed out lightbox layer would load and that’s it. The category selection window would not show up. Now all users are experiencing this.
Can anyone provide a suggestion as to what may be going on?
I checked the LOGS since I have no idea what’s happening and noticed a database error listed. It may be unrelated, but here is the output of one such error in case it helps:
<br /> cscart_categories.age_limit, IF(products.age_limit > cscart_categories.parent_age_limit, products.age_limit, cscart_categories.parent_age_limit), IF(cscart_categories.age_limit > cscart_categories.parent_age_limit, cscart_categories.age_limit, cscart_categories.parent_age_limit)) as age_limit, cscart_seo_names.name as seo_name FROM cscart_products as products LEFT JOIN cscart_product_descriptions as descr1 ON descr1.product_id = products.product_id AND descr1.lang_code = 'EN' LEFT JOIN cscart_product_popularity as popularity ON popularity.product_id = products.product_id LEFT JOIN cscart_product_prices as prices ON prices.product_id = products.product_id AND prices.lower_limit = 1 LEFT JOIN cscart_product_prices as prices_2 ON prices.product_id = prices_2.product_id AND prices_2.lower_limit = 1 AND prices_2.price < prices.price AND prices_2.usergroup_id IN (0, 0, 1) INNER JOIN cscart_products_categories as products_categories ON products_categories.product_id = products.product_id INNER JOIN cscart_categories ON cscart_categories.category_id = products_categories.category_id AND (cscart_categories.usergroup_ids = '' OR FIND_IN_SET(0, cscart_categories.usergroup_ids) OR FIND_IN_SET(1, cscart_categories.usergroup_ids)) AND (products.usergroup_ids = '' OR FIND_IN_SET(0, products.usergroup_ids) OR FIND_IN_SET(1, products.usergroup_ids)) AND cscart_categories.status IN ('A', 'H') AND products.status IN ('A') LEFT JOIN cscart_product_sales ON cscart_product_sales.product_id = products.product_id AND cscart_product_sales.category_id = products_categories.category_id LEFT JOIN cscart_seo_names ON cscart_seo_names.object_id = products.product_id AND cscart_seo_names.type = 'p' WHERE 1 AND cscart_categories.category_id IN (194) AND prices.usergroup_id IN (0, 0, 1) AND prices_2.price IS NULL GROUP BY products.product_id ORDER BY descr1.product asc LIMIT -20, 20<br /> ```<br /> <br /> The backtrace o n this listed:<br /> ```php <br /> /home/badagoo/public_html/store/core/fn.database.php (db_error): 310<br /> /home/badagoo/public_html/store/core/fn.database.php (db_query): 37<br /> /home/badagoo/public_html/store/core/fn.catalog.php (db_get_array): 3133<br /> /home/badagoo/public_html/store/controllers/customer/categories.php (fn_get_products): 66<br /> /home/badagoo/public_html/store/core/fn.control.php (include): 519<br /> /home/badagoo/public_html/store/core/fn.control.php (fn_run_controller): 384<br /> /home/badagoo/public_html/store/index.php (fn_dispatch): 27<br />