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.

Try to delete groups pending moderation gives error

8 years 11 months ago
  • calvin's Avatar
    Topic Author
  • calvin
  • Offline
  • Fresh Boarder
  • Posts: 27
  • Thank you received: 1
Licenses:
JomSocial Expired

ISSUE SUMMARY:
When in backend try to delete a group I get an SQL error

Unknown column 'groupid' in 'where clause' SQL=SELECT `id` FROM `XXXX_community_files` WHERE `groupid` = '36'

I am wondering if I had a bad update or something ? I saw this was an issue elsewhere in the forum but you didnt tell us how to help our own sites just that you fixed it direct in the DB. I am happy to do it myself if I know how.

8 years 11 months ago
Licenses:

Hi, Calvin.

Login to MyPHPAdmin click on SQl button and fire this query:

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

This happened after upgrade of JomSocial... certain columns weren't created in DB so you need to create them 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
The following user(s) said Thank You: calvin
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