Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Good morning. I upgraded to the latest version of PhocaCart (4.01Beta3) but I have a problem that I cannot find the solution to. On the Administrative side in the Products section I no longer see the products. In the server and in the database everything is fine. In the general page of the administrative side, nothing is seen except if I select the categories or if I recall the single products. I repeat that the catalog is fully functional as well as the site side from which it is possible to choose products, place orders, pay etc. etc.
I have noticed something that seems anomalous to me. When I try to regenerate the preview of a product the system replies to me this:
Miniature (s) regenerated
Product xxxxxxx: The original file does not exist
but I can assure you that, as I have already said, the site, the catalog and the database are perfect ...
SELECT DISTINCT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.published, a.ordering, a.featured, a.language, a.sku, a.image, a.price, a.price_original, a.stock, a.hits, l.title AS language_title, l.image AS language_image, uc.name AS editor, ag.title AS access_level, pc.ordering
FROM `zysgmctf_phocacart_products` AS a
LEFT JOIN `zysgmctf_languages` AS l ON l.lang_code = a.language
LEFT JOIN zysgmctf_users AS uc ON uc.id = a.checked_out
LEFT JOIN zysgmctf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN zysgmctf_phocacart_product_categories AS pc ON a.id = pc.product_id
LEFT JOIN zysgmctf_phocacart_categories AS c ON c.id = pc.category_id
LEFT JOIN zysgmctf_phocacart_product_stock AS ps ON a.id = ps.product_id
WHERE (a.published IN (0, 1)) AND pc.category_id = 0
ORDER BY a.hits DESC LIMIT 20
SELECT COUNT (*)
FROM `zysgmctf_phocacart_products` AS a
LEFT JOIN `zysgmctf_languages` AS l ON l.lang_code = a.language
LEFT JOIN zysgmctf_users AS uc ON uc.id = a.checked_out
LEFT JOIN zysgmctf_viewlevels AS ag ON ag.id = a.access
LEFT JOIN zysgmctf_phocacart_product_categories AS pc ON a.id = pc.product_id
LEFT JOIN zysgmctf_phocacart_categories AS c ON c.id = pc.category_id
LEFT JOIN zysgmctf_phocacart_product_stock AS ps ON a.id = ps.product_id
WHERE (a.published IN (0, 1)) AND pc.category_id = 0
SELECT a.id FROM zysgmctf_phocacart_currencies AS a WHERE a.id = 1 AND a.published = 1 ORDER BY a.id
SELECT a. * FROM zysgmctf_phocacart_currencies AS a WHERE a.id = 1 ORDER BY a.id
SELECT a.title AS text, a.id AS value, a.parent_id as parentid FROM zysgmctf_phocacart_categories AS a ORDER BY a.ordering
Excuse me but I think it is a problem with the "filter" options. Some work others don't release results and there seems to be no image for them. I also found that if I log out of the account and then return, the images of the products magically reappear and then disappear if, for example, I ask for a view by Title ...
... I thought it might depend on the database but even in this case the problem remained, despite using a backup from 15 days ago. So I think the problem is in the product filter options. Which files deal with the product filter? The idea is to replace or install them in case they got damaged for some reason ... I have a backup site on an online server exactly like the official site and I can try there ...
