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 - Groups

9 years 9 months ago
  • Udi's Avatar
    Topic Author
  • Udi
  • Offline
  • Fresh Boarder
  • Posts: 52
  • Thank you received: 12
Licenses:
JomSocial Active

ISSUE SUMMARY:
Hi,
Going to Prod !!!

J3.4.3
JS 4.0.9
Template - JA-Social II

Cannot Update group - Err 1054
Reason - SQL err - see attached.

Please help.

regards,
Udi


STEPS TO REPLICATE:
1
2
3
4
5
RESULT
EXPECTED RESULT
BROWSER

Attachments:
9 years 9 months ago
Licenses:

Hi, Udi.

You probably migrated recently...
Error is quite clear: unknown column "unlisted" in community_groups table. Column titled "unlisted" is missing in table #_community_groups. You need to create it manually.

Please, read this: www.jomsocial.com/forum/installation/287...r-1054-events#140164

- 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 9 months ago
  • Udi's Avatar
    Topic Author
  • Udi
  • Offline
  • Fresh Boarder
  • Posts: 52
  • Thank you received: 12
Licenses:
JomSocial Active

Hi Michal,

Yep .. the new version is up and you're invited www.gh-c.org :-)

You pointed to a topic I started.
It was regarding Events.

Now we have that issue in Groups.

What is the exact syntax please?

Are there other tables that require same handling?

regards,

Udi

9 years 9 months ago
Licenses:

Hi, Udi.

Ah, sorry, missed that. Try this;

ALTER TABLE `xvja3_community_groups` ADD `unlisted` TINYINT(1) NOT NULL;

Make sure that table prefix is correct.

- 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: Udi
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