blog documentation FAQ followers forum marketplace services youtube

solved user_jrPage_item_count

The Jamroom Network » Forum » Using Jamroom » Page » user_jrPage_item_count
hammondegs
@hammondegs
10 years ago
80 posts
For some reason the item_key 'user_jrPage_item_count' is missing from the database for user number 1 (Admin). Visit here: https://www.barklycommunity.org/administrator/page
In the admin profile stats it shows a count of 4... where did it derive this from? And further more, it doesn't matter how many pags admin creates, it stays at 4. Currently there are 2 pages. Events shows a total of 6, when there is only 4.
Every other user profile has user_jrPage_item_count and updates page count without issue.
updated by @hammondegs: 11/22/14 02:06:05AM
brian
@brian
10 years ago
10,148 posts
It should actually be profile_jrPage_item_count - you shouldn't actually see any keys for pages in the user table (since pages belong to a profile). I will check that out.

Note that if you create a page for your SITE however, and not a profile, then no profile counter is created.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
hammondegs
@hammondegs
10 years ago
80 posts
I thank you for your assistance.
I was looking in the wrong place.
Manually changing profile_jrPage_item_count via SQL changes the display, however creating pages for the admin's profile does not add to the count.

I have created 3 site pages and 4 profile pages - therefore I should have a tally of 4?

BTW - The events tally is correct. I missed 2 events that had expired and weren't displaying.
updated by @hammondegs: 10/18/14 09:18:25PM
brian
@brian
10 years ago
10,148 posts
Actually just going back to the code on this, there are user counts so you can see how many items of a certain type that user has created.

When you are creating the pages as the admin user, are you creating those pages for the admin's profile or for the site? If you're creating them for the site, then the count will not be in the admin's profile.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
hammondegs
@hammondegs
10 years ago
80 posts
I have done both methods.
3 for the site
4 for the admin profile

The admin currently shows 4 pages because I made it that way with SQL.
It hasn't done a page tally by itself since 2 or 3 updates ago.
brian
@brian
10 years ago
10,148 posts
hammondegs:
I have done both methods.
3 for the site
4 for the admin profile

The admin currently shows 4 pages because I made it that way with SQL.
It hasn't done a page tally by itself since 2 or 3 updates ago.

OK I can check it out and see if I can spot an issue.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
hammondegs
@hammondegs
10 years ago
80 posts
Thanks Brian.
It's appears to only be on the admin profile this happens.
So far all other profiles are fine.

The admin user_jrPage_item_count was present in core v5.2.9 and dissapeared in the next 2 updates. It was about then this issue arose.
brian
@brian
10 years ago
10,148 posts
This should be all fixed up in the latest Page Creator module, version 1.1.2 - note that the counts are only updated when a new page is added or an existing page is deleted, so as the admin just create a quick test page and it should update your profile and user counts to the correct values.

Hope this helps!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
hammondegs
@hammondegs
10 years ago
80 posts
Certainly has!
Thanks Brian, you Jamroom crew are legends :)
Cheers, David.

Tags