Skip to Content Skip to Menu

CB Activity Stream - Pagination/More Button Not Loading Additional Items

  • Oishiku
  • Oishiku
  • ONLINE
  • Posts: 13
  • Thanks: 3
  • Karma: 2
4 days 6 hours ago #343437 by Oishiku
Hello, 
I've run into an issue with the streaming of activity.  

CB Activity version: 2.11.0+build.2026.01.12.21.55.56.a25ef0f6c
Joomla version: 5.4.3
PHP version: 8.2

Issue:
The Recent Activity stream (stream ID 1, asset: activity_stream.2) is not loading additional items via pagination. The activity table has 160 records with stream_id correctly set (86 personal, 74 groupjive).

Behavior observed:
With Paging Enabled, Page Limit 15, Auto Load Enabled — items display correctly but auto-scroll does not trigger loading of additional items when reaching the bottom of the stream so you only view 15 items.

With Auto Load Disabled — the More button appears, but clicking it removes the button from the DOM with no network request fired (confirmed via browser DevTools Network tab — no XHR/fetch request generated on click).

With Auto Update Enabled — repeated "No posts to display" messages cascade on screen. 

With Page Limit 0 — all items attempt to render but styling breaks down and "No posts to display" messages appear before items load.

The stream container renders with data-cbactivity-autoload only when Auto Load is enabled, but when enabled the More button does not appear. When Auto Load is disabled, the More button appears but its click handler removes the button without making an AJAX call.

Question: What is the correct configuration to enable working pagination on the Recent Activity stream? Is there a known issue with the More button AJAX handler when Auto Load is disabled?

Thank you.

 

Please Log in or Create an account to join the conversation.

  • krileon
  • krileon
  • ONLINE
  • Posts: 50216
  • Thanks: 8597
  • Karma: 1470
3 days 17 hours ago #343439 by krileon
It's normal to not see the more button with auto loading enable, because it has already been clicked by time you reach the half way point of the page. Your configuration itself seams fine.

Sounds like you've a JavaScript error breaking the paging or there is nothing further to load in (e.g. could be due to access permissions). Press F12 to open your browsers developer tools. Next click the Console tab. Now attempt to click the More button or scroll to it and see if any errors show in the console.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

  • Oishiku
  • Oishiku
  • ONLINE
  • Posts: 13
  • Thanks: 3
  • Karma: 2
3 days 9 hours ago - 3 days 9 hours ago #343443 by Oishiku
Thank you for your response.

We followed your suggestion and checked the browser console carefully. Here is what we found:

JavaScript errors: None. The console is completely clean with no errors when the page loads or when scrolling to the bottom of the stream.

Access permissions: All 86 activity records in stream_id=2 have
Code:
published=1
. The stream itself is set to Public access. We are testing both logged in and logged out with the same result — no additional items load.

What we observe: With Auto Load enabled, the More button briefly appears as we scroll, then disappears with an animation as expected — confirming the scroll detection IS working. However no additional items appear after it fires.

Possible cause: Further investigation of the database revealed that all activity records have
Code:
page = NULL
in the
Code:
comprofiler_plugin_activity
table. These records were imported via SQL from a Joomla 3 CB Activity table which did not have a
Code:
page
column. The rendered HTML confirms this — every item shows
Code:
data-cbactivity-page=""
with no value.We believe CB's pagination cursor relies on the
Code:
page
column to know what offset to request next. With all values NULL, every auto-load request appears to return the same first page of items, so CB discards them as duplicates and shows nothing new.
  1. What format/value should the
    Code:
    page
    column contain, and is there a way to rebuild or repopulate it for existing records?
  2. Is there a CB Activity tool, console command, or SQL approach to reindex the activity stream pagination for imported records?
Last edit: 3 days 9 hours ago by Oishiku. Reason: Paragraphs were missing

Please Log in or Create an account to join the conversation.

  • Oishiku
  • Oishiku
  • ONLINE
  • Posts: 13
  • Thanks: 3
  • Karma: 2
1 day 4 hours ago #343446 by Oishiku
Thank you for pointing us in the right direction with the console check. While there were no JavaScript errors, your suggestion to look more closely at the paging mechanism helped us find the root cause.

The issue was confirmed: the `page` column in `comprofiler_plugin_activity` was NULL for all records imported via SQL from a Joomla 3 CB Activity table (which did not have a `page` column). CB Activity's pagination cursor relies on this field to determine the next batch offset.

We discovered that the `page` column format is `UNIX_TIMESTAMP(date).id` — for example, a record with id=180 and date 2026-03-02 04:33:15 gets the page value `1772425995.180`.

The fix was straightforward:


```sql
UPDATE comprofiler_plugin_activity 
SET page = CONCAT(UNIX_TIMESTAMP(date), '.', id) 
WHERE page IS NULL;
```

After running this, pagination works perfectly — auto-load fires as expected and additional items appear when scrolling.

Posting this in case it helps others migrating CB Activity data from Joomla 3 to Joomla 5 via SQL import. The `page` column is new in the J5 version and needs to be populated for imported records.

Thank you again for your help.
The following user(s) said Thank You: krileon

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum