Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM

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.

Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM

12 years 2 months ago

#99438

Topic Author
justin
Offline
Fresh Boarder
Posts: 45
Thank you received: 0

Licenses:

JomSocial Active

After upgrading to Joomla 3.3.2 and upgrading to Jomsocial 3.2.0.7

I have this issue when I try to click on an existing jomsocial group?

Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM 'xxxx_community_files` WHERE `groupid` = xxx

I see this has been resolved on other threads, but no explanation was given. I am having this issue on a development site and I need to know how to fix this when my live site is updated.
I have access to phpmyadmin if I need to run any queries.

12 years 2 months ago

#99443

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

Licenses:

Hi, Justin.

So you upgraded to old version of JomSocial :D
Current version is 3.2.1.3. Try to upgrade to this version and check if issue persist.
If YES, then read this topic: www.jomsocial.com/forum/installation/177...l-select-count#90371

- 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

12 years 2 months ago

#99448

Topic Author
justin
Offline
Fresh Boarder
Posts: 45
Thank you received: 0

Licenses:

JomSocial Active

Found the solution in that thread thanks. Below

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

Change xxx to your db table suffix.

This issue could happen after migration. It indicates that some columns are not present in tables. So they need to be created manually.

Moderators: Piotr Garasiński

Notice

Support Forum

Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM

Licenses:

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere