Images Breaking on Mobile in PrestaShop

[rexglenn]

Hello everyone,

I’m running into a really odd issue with my PrestaShop store and I’m hoping someone here might be able to shed some light on it. My website is designed to replicate a Texas Roadhouse-style online ordering experience, where customers can browse steaks, ribs, and other menu items just like they would when looking at the Texas Roadhouse menu in person. The main problem is that whenever I try to load my “Texas Roadhouse Menu” category page, it takes much longer than any of my other categories to load, and sometimes it even times out. Other categories with similar amounts of products load just fine, so it seems specific to this section.

I’ve tried checking the server logs and noticed that the menu page generates unusually heavy queries, even though the product count is not significantly higher than others. For example, the Texas Roadhouse menu page has about 50 products, but my "Seafood" section with around 40 products loads instantly. I’ve already cleared cache, re-indexed, and disabled unnecessary modules to test if it was an add-on issue, but the page is still sluggish. Oddly, if I clone the products and place them into a temporary test category, they load fine. So it seems like the problem lies with the Texas Roadhouse category setup itself.

Another issue I noticed is that the product images for the Texas Roadhouse menu section sometimes fail to display on mobile, showing broken image icons. I checked the image regeneration settings in PrestaShop and even tried regenerating all thumbnails, but the problem keeps happening intermittently. What’s confusing is that this only happens in the Texas Roadhouse menu category, not in others . It makes me wonder if there’s some corruption or misconfiguration tied specifically to this category in the database.

I also attempted to disable friendly URLs and then re-enable them to see if the URL rewriting was causing conflicts, since my Texas Roadhouse category URL is a bit long (something like “/texas-roadhouse-menu-steaks-ribs-rolls”). That didn’t resolve it either. I even checked permissions on the server side to make sure images and category files were accessible. Everything seems correct, yet the Texas Roadhouse section keeps acting strangely while the rest of the site runs smoothly.

At this point, I’m at a bit of a loss. I don’t want to completely delete and rebuild the Texas Roadhouse category since it’s already linked across different parts of my site, including SEO and customer accounts with saved carts. Has anyone experienced something similar with a single category behaving this way in PrestaShop? Could it be a database index corruption, or maybe some caching issue that only affects one category? Any guidance on how I can troubleshoot or repair this without losing all the links tied to the Texas Roadhouse menu would be greatly appreciated. Please assist me as I am not a technical person.

Edited September 9 by rexglenn (see edit history)

[rexglenn]

On 9/8/2025 at 12:34 AM, rexglenn said:

Hello everyone,

I’m running into a really odd issue with my PrestaShop store and I’m hoping someone here might be able to shed some light on it. My website is designed to replicate a Texas Roadhouse-style online ordering experience, where customers can browse steaks, ribs, and other menu items just like they would when looking at the Texas Roadhouse menu in person. The main problem is that whenever I try to load my “Texas Roadhouse Menu” category page, it takes much longer than any of my other categories to load, and sometimes it even times out. Other categories with similar amounts of products load just fine, so it seems specific to this section.

I’ve tried checking the server logs and noticed that the menu page generates unusually heavy queries, even though the product count is not significantly higher than others. For example, the Texas Roadhouse menu page has about 50 products, but my "Seafood" section with around 40 products loads instantly. I’ve already cleared cache, re-indexed, and disabled unnecessary modules to test if it was an add-on issue, but the page is still sluggish. Oddly, if I clone the products and place them into a temporary test category, they load fine. So it seems like the problem lies with the Texas Roadhouse category setup itself.

Another issue I noticed is that the product images for the Texas Roadhouse menu section sometimes fail to display on mobile, showing broken image icons. I checked the image regeneration settings in PrestaShop and even tried regenerating all thumbnails, but the problem keeps happening intermittently. What’s confusing is that this only happens in the Texas Roadhouse menu category, not in others. For a working example of how the menu should look, click here. It makes me wonder if there’s some corruption or misconfiguration tied specifically to this category in the database.

I also attempted to disable friendly URLs and then re-enable them to see if the URL rewriting was causing conflicts, since my Texas Roadhouse category URL is a bit long (something like “/texas-roadhouse-menu-steaks-ribs-rolls”). That didn’t resolve it either. I even checked permissions on the server side to make sure images and category files were accessible. Everything seems correct, yet the Texas Roadhouse section keeps acting strangely while the rest of the site runs smoothly.

At this point, I’m at a bit of a loss. I don’t want to completely delete and rebuild the Texas Roadhouse category since it’s already linked across different parts of my site, including SEO and customer accounts with saved carts. Has anyone experienced something similar with a single category behaving this way in PrestaShop? Could it be a database index corruption, or maybe some caching issue that only affects one category? Any guidance on how I can troubleshoot or repair this without losing all the links tied to the Texas Roadhouse menu would be greatly appreciated. Please assist me as I am not a technical person.

Is there anyone who can give me insights what to do as I am not a techie. Please I want to solve this issue

Edited September 9 by rexglenn (see edit history)

[ComGrafPL]

Any issues showing on console? ( browser inspection ) Any category images or custom modules related to categories?

[cocos.codes]

Access the database via phpMyAdmin, select your database on the left, and on the right, click on the column with records (so that it sorts by the largest number of records).

Post a screenshot or write if you have any tables that contain, for example, 10k or more records.

I marked where to click on the screenshot:

[Maxcole]

It sounds like the issue might be tied to a corrupted or misconfigured database record specific to your “Texas Roadhouse Menu” category rather than the products themselves. Since cloning the items into another category resolves the delay, that points toward a possible issue in the ps_category or ps_category_lang tables, such as a missing or duplicated entry, or an index problem causing inefficient queries.

A few steps you could try before deleting or rebuilding the category:

Check database integrity:

In phpMyAdmin, run “Check table” and “Repair table” for ps_category, ps_category_lang, and ps_category_product.

You can also use PrestaShop’s built-in “Database > Check & Fix” tool under Advanced Parameters > Database to detect inconsistencies.

Clear category-level cache manually:

Delete the cache folder in /var/cache/prod (or /cache/smarty/cache in older versions).

Sometimes category-specific caching doesn’t clear properly from the back office.

Inspect category metadata and URL rewriting:

Ensure that the link_rewrite and meta_title fields are unique and not excessively long. Very long slugs or special characters can trigger heavier URL parsing on some setups.

Review product image links:

Intermittent broken images can be due to missing records in the ps_image or ps_image_shop tables. Regeneration sometimes skips these if the product-to-image mapping isn’t consistent.

Compare the affected category’s image IDs with a working one to see if some entries are missing.

Turn on debug mode temporarily:

Go to Advanced Parameters > Performance and enable “Debug Mode.”

Then reload the category page to see the specific query or module slowing it down.

Rebuild category tree:

Try disabling and re-enabling the parent category or moving it under another parent temporarily to force PrestaShop to reindex the hierarchy.

This type of single-category slowdown often comes down to a corrupted database link or an old cache entry that doesn’t refresh properly. If nothing works, you can export the category’s structure via SQL or a PrestaShop module, recreate it with the same ID, and reimport — preserving SEO and product associations.

For reference, I’ve faced similar caching and media issues when optimizing image-heavy content pages (like anime streaming and video categories on my site, and clearing the database indexes plus regenerating thumbnails usually resolved them.