Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated

1054 Unknown column 'a.usergroup' in 'field list' after fresh installation

6 years 5 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Hi,
I have a similar problem as in the ticket www.jomsocial.com/forum/installation/372...-before-installation
I just did a brand new installation:
- Joomla 3.8.2
- via a quickstart installation of JA MOOD (multilingual installation without data uploaded).
- plus installed Akeeba backup and admin tools from Akeeba.
- Then, I installed the package JS 4.5, the process went through with success until going back to the admin site (then the error message).
I get the following error message when I click on JS in the components menu



I also checked if I have "usergroup" column in #__community_users table. It doesn't seem so:


Regards
yves

Attachments:
6 years 5 months ago
Licenses:

HI, Yves.

Thank you for contacting us.
You need to create that column manually. Just run this query:

ALTER TABLE `xxx_community_users` ADD `usergroup` TINYTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

Remember to change xxx to your table suffix.

- 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: yves
6 years 5 months ago
  • yves's Avatar
    Topic Author
  • yves
  • Offline
  • Junior Boarder
  • Posts: 111
  • Thank you received: 5
Licenses:
JomSocial Active

Thanks, it worked :-)

6 years 5 months ago
Licenses:

HI, Yves.

Great to hear that.
Cheers! :)

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