Profile likes tab...again

FYI try clicking the like button here to reproduce.

http://community.inv...ry__type__given

You can also see the second issue there as well.

Also I think this is related to that "second issue".

http://community.inv...pp_tab__gallery

This page does not have the likes that were given before the upgrade.

Updating Fixed In to: 5.0.0 Beta 1
Updating Status to: Fixed

You may need to run this first

delete from reputation_cache where type='image_id';

but these will be added to the upgrader for the next beta

UPDATE reputation_cache SET type='image_id' where app='gallery' and type='id';
UPDATE reputation_index SET type='image_id' where app='gallery' and type='id';

Note that the most liked page you linked to last is cached, so that should auto fix itself at some point.

Well...it seems to have worked for the most part. And in fact images that weren't showing up before are showing up now under the received tab.

But in the given tab...it seems that some images are showing which the user doesn't have likes for. Um...I'm assuming that maybe they liked the image and then unliked it later?

Type is pid and this is in the rep_like_cache

a:2:{s:10:"cache_data";a:6:{s:3:"app";s:7:"gallery";s:4:"type";s:3:"pid";s:2:"id";s:2:"41";s:5:"count";i:1;s:11:"memberNames";a:1:{i:22;a:2:{s:1:"n";s:4:"Waco";s:1:"s";s:4:"waco";}}s:9:"memberIds";a:1:{i:0;s:2:"22";}}s:12:"cache_expire";i:1344946738;}

And indeed Waco is the user who is having this issue. Though he's not the only one and I can reproduce the same as above for every one that I investigate.

I'm assuming I should do

DELETE from reputation_cache WHERE type='pid' as well?

What I'll probably do is restore my Gallery 4 DB and run the upgrader over again when the next beta is out.

Ok maybe the issue at hand is something else...but I also think I might've messed something up while running the queries..

If I like an image and then refresh the page, my like disappears. If I try to like it again it says there was a problem storing my vote.

Reproducible on this image.

http://community.inv...731-cycle-19km/

Additionally the like does not show up in the profile tab (but I can't reproduce that here).

Updating Status to: Confirmed - General

That's a separate issue really, and may very well be our site or the central reputation system. I'll reopen this, but may have to split the report (we'll see).

Yeah...I think I've stuffed a lot of things into one bug report sorry. You might also be fixing things that are also fixing these other issues I'm reporting (I feel a lot of this stems from the fact that preupgrade likes do not show up in the profile type or most liked content page) so I will wait for the next beta before tackling likes and reputation again. Well..assuming there's another beta...

Updating Status to: Fixed

Ok, pid is for comments (not images). While that needs to be addressed as well, it wouldn't change images showing in the profile.

UPDATE reputation_index SET type='comment_id' where app='gallery' and type='pid';

Having said that, you illustrated another issue - the 'type' is being cached inside the serialized array and that cannot be updated. We can, however, just empty the gallery entries in reputation_cache as they will dynamically rebuild.

delete from ibf_reputation_cache where app='gallery'

I also found some areas in Gallery still referring to 'id' instead of 'image_id' which is contributing to the problem. Fixed those. I think collectively these changes should resolve the problems in this report.