[2.2.1] No user profile tab

[Stuart Wright]

I have a showcase but no tab as expected in my profile:
https://www.avforums.com/members/stuart-wright.1/

 

[Bob]

Do you have the options set?

 

[Stuart Wright]

Do you have the options set?

View attachment 1040

Yes, I checked that setting. It is ticked.

 

[Bob]

Do you have the 3 TM's associated with the profile disabled for any reason?

 

[Bob]

Just going step by step here... if those 3 are enabled, then the next step is to make sure the showcase_count field is in the xf_user table

Check the xf_user table and make sure there is a field named: showcase_count

This field was added in Showcase version 1.3.0 Beta 1, so its been there for awhile now

if the field is there, can you tell me what value is set for YOUR record? It should be 1, since you have 1 showcase item. If its 0, change it to 1

If the field is missing, you will need to add it

ALTER TABLE xf_user ADD showcase_count int(10) unsigned NOT NULL DEFAULT '0'

Since you only have 6 showcase items, you can quickly set the value to 1 for the 6 showcase item users.

 

[Stuart Wright]

The field is there, but my showcase count is zero. I don't think any of your cache rebuild routines for showcases fixes the showcase count in the user table.

 

[Bob]

The field is there, but my showcase count is zero. I don't think any of your cache rebuild routines for showcases fixes the showcase count in the user table.

You'll need to manually update the other 5 Item owners as well as it doesn't look like they have data either.

There is a method available. I can add this to the cache rebuilds (Rebuild Showcase User Item Counts)

    /**
     * Updates the showcase_count field in the xf_user table for all users that have at least 1 visible item.
     * This is mainly used for the install file when the showcase_count field was added to the xf_user table.
     * Can be fired via CRON for routine maintenance or rebuild count
     */
    public function updateUserShowcaseCount()
    {
        $userIds = $this->_getDb()->fetchCol('
            SELECT DISTINCT user_id
            FROM xf_nflj_showcase_item
            WHERE item_state = "visible"
        ');
   
        foreach ($userIds as $userId)
        {
            $itemCount = $this->_getDb()->fetchOne('
                SELECT COUNT(*) as count
                FROM xf_nflj_showcase_item
                WHERE user_id = ?
                    AND item_state = "visible"
            ', $userId);
               
            $this->_getDb()->update(
                'xf_user',
                array('showcase_count' => $itemCount),
                'user_id = ' . $userId
            );
        }
    }

 

[Stuart Wright]

Ran a query to fix it and the tab shows up. Thanks, Bob.

 

[Bob]

 

[Stuart Wright]

https://www.avforums.com/showcase/
Also getting a 'Home Cinema Showcases: 5' message in the sidebar when there are 6.

 

[Bob]

run the 'Rebuild Showcase Categories' (Tools >> Rebuild Caches). That will rebuild the item counts for each category.