Error 1054 — Can't Open Groups

Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated

Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Error 1054 — Can't Open Groups

11 years 1 week ago

#79703

Topic Author
Jim
Offline
Fresh Boarder
Posts: 40
Thank you received: 1

Licenses:

JomSocial Active Socialize Expired

Jomsocial 3.1.1 was working just fine on my Joomla 3.2.3 site. I uninstalled Jomsocial 3.1.1 and upgraded to Jomsocial 3.2.0.1 according to instructions on your site. Now I get this message when trying to view a Group:

Error:  1054 - Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM `x9fa2_community_files` WHERE `groupid` = '24'

Also, Comments are not displayed.

11 years 1 week ago

#79710

Michał
Offline
Moderator
Posts: 13447
Thank you received: 3689

Licenses:

Hi, Jim.

Make a safe copy of your database. Run this SQL query in PhpMyAdmin:

ALTER TABLE `x9fa2_community_files` ADD `groupid` INT(11) NOT NULL;

This will create missing column.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you

The following user(s) said Thank You: Jim

Moderators: Piotr Garasiński

Notice

Support Forum

Error 1054 — Can't Open Groups

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere