Item count on Gallery Tab shows double

[Tonyvic]

If a member adds one photo the Tab shows Two etc., any advice appreciated.
I'm using the latest version.

[SMFHacks]

Can you take a screenshot?

[Tonyvic]

Sure, I added this pic but it does the same if a regular member posts one.

[SMFHacks]

What happens when you click unviewed? In the gallery how many photos does it show

Also what SMF version?

[Tonyvic]

Three pics were added to Gallery overnight, six showing on tab. After selecting 'Unviewed' there are three pics but still showing six on tab.
SMF version 2.1.4

[SMFHacks]

Copy this file to your sources folder and see if it helps

[Tonyvic]

Unfortunatly it is still the same with the updated file.
I uploaded a pic as a regular user (Tonyvic) it shows (2) on the tab. Not sure if it's correct but shows as new to me (Leavic) as well.

[SMFHacks]

Try running this sql query on your database replace #### with your member id for Leavic I am assuming admin user

Code: [Select]

SELECT
*
FROM smf_gallery_pic as p
LEFT JOIN smf_members AS m ON (p.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN smf_gallery_catperm AS c ON (c.ID_GROUP IN (1) AND c.ID_CAT = p.ID_CAT)
LEFT JOIN smf_gallery_log_mark_view AS v ON (p.ID_PICTURE = v.ID_PICTURE AND v.ID_MEMBER = #### AND v.user_id_cat = p.user_id_cat)
LEFT JOIN smf_gallery_usersettings AS s ON (s.ID_MEMBER = m.ID_MEMBER)
WHERE v.ID_PICTURE IS NULL AND ((p.USER_ID_CAT !=0 AND p.approved =1) OR (p.approved =1 AND p.USER_ID_CAT =0 AND (c.view IS NULL OR c.view =1))) GROUP by p.ID_PICTURE


[Tonyvic]

I will have to learn the query database again my ancient brain has forgotten, before I get to that I just noticed 138 errors from ADMIN (All the same in SMF log) and since I uploaded the updated file.
Leavic is me as a Regular User.

[SMFHacks]

hmm revert back try old file and see if errors are logged

[Tonyvic]

Errors now stopped, I will get on with the query suggested. Thanks.

[Tonyvic]

I run the query but unsure of what I should now do.
I see nothing to say there is an error, but see the result in attached.

[SMFHacks]

It doesn't show the rows or anything else on the page?
It should have a list pictures in the database.
I want to see if the id's are unique or not.

[Tonyvic]

Just got back to this, I am totally lost on the database & unsure what to do.
To recap, any user whatever group produce the double count.
Looking into this I wonder if I did the upgrade wrong, as in the Package Manager I see (attachment below) . I'm sure this issue only started after that so can I just uninstall 10.1.2 & check then do the upgrade again via the upgrade button?

[SMFHacks]

The upgrade won't affect this.

I guess from the SQL screenshot would have liked to see the whole page hard to tell otherwise...