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 7 months ago
  • nick's Avatar
    Topic Author
  • nick
  • Offline
  • Fresh Boarder
  • Posts: 35
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi,
I am getting this error when accessing groups:
1054 - Unknown column 'groupid' in 'where clause' SQL=SELECT COUNT(*) FROM `xxxx_community_files` WHERE `groupid` = '29'
I am aware of several threads on this subject and have tried to implement the solution as suggested here:
www.jomsocial.com/forum/installation/177...l-select-count#90371
However it didn't work for me.
Many thanks in advance for your help.
Nick

9 years 7 months ago
Licenses:

Hi, NIck.

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
9 years 7 months ago
  • nick's Avatar
    Topic Author
  • nick
  • Offline
  • Fresh Boarder
  • Posts: 35
  • Thank you received: 0
Licenses:
JomSocial Expired

Hi Michal,
as I have already said in my message, this didn't work for me.
Please let me know if you need access to my cpanel and have a look into the database. I will be happy to assist you in any way.
Thanks.
Nick

9 years 7 months ago
Licenses:

Hi, NIck.

Oh, I'm sorry I missed that.
Yes, please, edit your first post and add PHPmyAdmin or cPanel credentials.

- 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
9 years 7 months ago
  • nick's Avatar
    Topic Author
  • nick
  • Offline
  • Fresh Boarder
  • Posts: 35
  • Thank you received: 0
Licenses:
JomSocial Expired

Done. Edited the first post and added cpanel login details.

9 years 7 months ago
Licenses:

Hi, NIck.

Are you sure they are right? I can't log in...

- 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
9 years 7 months ago
  • nick's Avatar
    Topic Author
  • nick
  • Offline
  • Fresh Boarder
  • Posts: 35
  • Thank you received: 0
Licenses:
JomSocial Expired

Sorry, I was in a hurry and gave you a wrong password. I have now corrected it in the first post.
Many thanks.
Nick

9 years 7 months ago
Licenses:

Hi, Nick.

Are you sure you used suggested fix in right database? As I had to run this query...
Please, check now if it helped.

- 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
9 years 7 months ago
  • nick's Avatar
    Topic Author
  • nick
  • Offline
  • Fresh Boarder
  • Posts: 35
  • Thank you received: 0
Licenses:
JomSocial Expired

Thank you Michal. Yes, I actually made a mistake and ran the query on a wrong database... Sorry and many thanks for your help once more.
Cheers
Nick

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved