Since upgrading to JS 3.2.0.5, users (front-end) or administrators (back-end) cannot view a Group page.

When the link to view a Group page is clicked, here is the error message:
1054 - Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM `sqlprefix_community_files` WHERE `groupid` = '15'

It's a similar problem as outlined in post: www.jomsocial.com/forum/installation/16843-error-1064-groupid
I was going to leave a post there, but there was no "Reply" button.

There wasn't a problem accessing a Group page before updating JS.

Here's my system info:

• PHP Built On Linux ip-10-155-152-181 3.2.0-54-virtual #82-Ubuntu SMP Tue Sep 10 20:31:18 UTC 2013 x86_64
• Database Version 5.6.13-log
• Database Collation utf8_general_ci
• PHP Version 5.3.26
• Web Server Apache/2.2.22 (Ubuntu)
• WebServer to PHP Interface apache2handler
• Joomla! Version Joomla! 3.3.0 Stable [ Ember ] 30-April-2014 14:00 GMT
• Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Hi Jeff,

can you provide me CPanel access ? i need to inspect your file + database directly :)

Warm Regards,

David

Hi David,

I provided my credentials in a private message on JomSocial. Sorry if there was a better way to PM you, but I was not sure how else to send you the private info. Probably could have put it in my original post.

- jeff

Hi Jeff,

i think i already fixed your problem, please check again and if still persist, let me know :)

Warm Regards,

David

Thanks David! Yes, you fixed it... it works fine now.

Could you let me know what the solution was, in case it happens again? Thanks!

- jeff

David, the View Group page problem is fixed on the front-end. Thanks!

However, since you adjusted the MySQL tables, there's still a problem that I've noticed. In the backend, in the JomSocial admin component, there are no Groups or Group Categories that show up in the list... even though there are groups and categories on the front-end.

Hi Jeff,

thanks for your response :) give me some time to inspect this issue :) I will post it here after finish inspect this issue :)

By the way, the credentials not valid anymore for backend access.. i'm not try for the CPanel yet :) maybe you can update with valid credentials so i can login into your backend (or CPanel if the cpanel credentials already changed)

Warm Regards,

David