Yeah. I’d send them this so they know you’ve already done substantial troubleshooting and don’t send you through all the basic steps:

Subject: SP Page Builder – “No Pages Found” although pages exist in database

Hi, I’m having an issue where SP Page Builder shows “No pages found” in the Joomla administrator.

The problem originally existed with SP Page Builder 5.4.2 and continues after successfully upgrading to SP Page Builder 6.9.0. Joomla is currently 5.4.8.

We have confirmed:

• #__sppagebuilder contains 90 records where extension = 'com_sppagebuilder' and extension_view = 'page'.
• Most are published (published = 1), access = 1, and language = '*'.
• The pages still work on the frontend. For example, SPPB page ID 86 (FAQ) renders normally.
• The administrator Pages request to /editor.pages returns HTTP 200, but the JSON response contains: totalItems: 0, totalPages: 0, results: [].
• There are no page filters being passed that would explain the zero results.
• Joomla System → Maintenance → Database now reports No Problems for SP Page Builder.
• The #__sppagebuilder.id primary key has AUTO_INCREMENT correctly configured.
• We also checked extension_view, published, access, language, catid, active, and created_by; nothing explains why all pages are excluded.

During the 6.9 upgrade there was also a partial 6.3.0 migration involving #__sppagebuilder_collection_fields.is_single_location. That migration was verified as completed, the Joomla schema record was corrected from 6.2.3 to 6.3.0, and 6.9.0 subsequently installed successfully. Joomla now reports no database problems.

The original “No Pages Found” issue existed before this upgrade, so it does not appear to have been caused by 6.9.

Can you please advise what condition/query /editor.pages uses to retrieve standalone SPPB pages, or whether this is a known issue? The page data clearly still exists, so I do not want to uninstall SPPB or delete/recreate the pages.