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