By Paul Murray on Wednesday, 28 October 2015
Posted in Technical Issues
Likes 0
Views 586
Votes 0
Hi SI Team

Videos, I have to say I love them. Really in combination with Groups they are pretty much every thing they should be.

I have some minor issues however.
I have posted videos here:

http://finalbug.net/videos/group/17-learn-fcpx
http://finalbug.net/videos/group/18-learn-resolve

FYI I notice that they are published with my user name”paurray” and not real name “Paul David Murray”
Maybe this is part of the problem.

When I go to my profile:

http://finalbug.net/profiledrop/62-paurray
And look at the little Video Counter below my Avatar I see “0” Videos
When I click on the link:
http://finalbug.net/videos/user/62-paurray
I see the videos.

Is it possible that the video counter is not working?

please advise

Paul
Hey Paul,

After checking this, it looks like the videos that you created are mostly for groups and it doesn't get included in your profile because those videos are not considered "yours" since they are uploaded on behalf of the groups.

I have altered this behavior since it makes sense to also include videos that you uploaded in a group as clicking on the link also displays them. This behavior will be fixed in the next release of EasySocial
·
Sunday, 01 November 2015 00:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Paul,

Can you provide us with your PHPMYADMIN access?

Because I tried to run this sql in mijoSQL extension, I hitting this :
The page you are trying to access is restricted due to a security rule.

If you believe the security rule is affecting the normal operation of your website, contact your host support team and provide detailed instructions how to recreate this error.
They will be able to assist you with rectifying the problem and adjusting the security configuration if needed.


select count(1) from (select * from (select ct.*, (select pri.value as `access` from `fbug_social_privacy_items` as pri left join `fbug_social_privacy_customize` as prc on pri.id = prc.uid and prc.utype = 'item' where pri.uid = ct.id and pri.`type` = 'videos' UNION ALL select prm.value as `access` from `fbug_social_privacy_map` as prm inner join `fbug_social_privacy` as pp on prm.privacy_id = pp.id left join `fbug_social_privacy_customize` as prc on prm.id = prc.uid and prc.utype = 'user' where prm.uid = ct.user_id and prm.utype = 'user' and pp.type = 'videos' and pp.rule = 'view' union all select prm.value as `access` from `fbug_social_privacy_map` as prm inner join `fbug_social_privacy` as pp on prm.privacy_id = pp.id inner join `fbug_social_profiles_maps` pmp on prm.uid = pmp.profile_id where prm.utype = 'profiles' and pmp.user_id = ct.user_id and pp.type = 'videos' and pp.rule = 'view' limit 1) as access, (select concat(',', group_concat(prc.user_id SEPARATOR ','), ',') as `custom_access` from `fbug_social_privacy_items` as pri left join `fbug_social_privacy_customize` as prc on pri.id = prc.uid and prc.utype = 'item' where pri.uid = ct.id and pri.`type` = 'videos' UNION ALL select concat(',', group_concat(prc.user_id SEPARATOR ','), ',') as `custom_access` from `fbug_social_privacy_map` as prm inner join `fbug_social_privacy` as pp on prm.privacy_id = pp.id left join `fbug_social_privacy_customize` as prc on prm.id = prc.uid and prc.utype = 'user' where prm.uid = ct.user_id and prm.utype = 'user' and pp.type = 'videos' and pp.rule = 'view' limit 1) as custom_access from `fbug_social_videos` as ct) as x WHERE ( (x.`access` = '0') OR ( (x.`access` = '10') AND (0 > 0 ) ) OR ( (x.`access` = '30') AND ( (select count(1) from `fbug_social_friends` where ( `actor_id` = x.`user_id` and `target_id` = 0) OR (`target_id` = x.`user_id` and `actor_id` = 0) and `state` = 1) > 0 ) ) OR ( (x.`access` = '40') AND ( x.`user_id` = 0 ) ) OR ( (x.`access` = '100') AND ( x.`custom_access` LIKE '%,0,%' ) ) OR (x.`user_id` = 0) )) as a where a.state = '1' and a.uid = '62' and a.type = 'user'


It seems like your server restrict user execute sql from your backend.
·
Thursday, 29 October 2015 01:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Arlex

I am including the details that you need in the Site Details Section (Optional Information)
I am around for another couple of hours if you need further assistance.

thanks

Paul
·
Thursday, 29 October 2015 01:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi SI

Team. Just wondering if you made some progress with respect to this issue?

best

Paul
·
Friday, 30 October 2015 18:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Paul,

I am really sorry for the delay of this reply as it is a weekend for us here. I don't seem to see any phpmyadmin informtion provided under the optional information section.

Can you please advise?
·
Saturday, 31 October 2015 17:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark

I have put the info in, up at the top of this thread in the section: Additional Message

thanks for looking into this for me.

best

Paul
·
Saturday, 31 October 2015 20:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Paul,

I am really sorry for the delay of this reply as it is a weekend for us here. Hm, this is odd because I don't see these details

Can you please add it here instead, http://stackideas.com/dashboard/site ?
·
Sunday, 01 November 2015 00:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay, it's actually there. There's a bug in our new forum :x
·
Sunday, 01 November 2015 00:32
·
0 Likes
·
0 Votes
·
0 Comments
·
Hey Mark

Thanks for this.
Yes I agree it makes sense like this

best

Paul
·
Monday, 02 November 2015 00:31
·
0 Likes
·
0 Votes
·
0 Comments
·
You're welcome Paul.
·
Monday, 02 November 2015 10:40
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post