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

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.

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

9 years 10 months ago

#90362

Topic Author
Christian
Offline
Fresh Boarder
Posts: 10
Thank you received: 1

Licenses:

JomSocial Expired

Hello, we migrated from an very old version of JomSocial 1.6.283 to 3.2.0.5 and have the same problem like in this post: www.jomsocial.com/forum/installation/168...ql-select-count-from

Could you please give a hint for an workaround or better a solution? Thanks in advance

p.s. the Joomla 3.3 migration is installed on our test server at www.wahl-verwandtschaft.de/joomla_3_3 (@text2net-Server) / productive page located at www.wahlverwandtschaften.org

9 years 10 months ago

#90371

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

Licenses:

Hi, Christian.

I fixed it for you. For future references, run this SQL query in your db:

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.

- 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

Moderators: Piotr Garasiński

Notice

Support Forum

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

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere