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.

Adding Groups to bulk of users

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

Hi,

I read similar topic, but in my case, there are no duplicate records.

Is there any documantation how to add it directly to the db?

regards,
Udi

10 years 3 months ago
Licenses:

Hi, Udi.

So you want to assign users to certain group en mass?
Please, read this topic: www.jomsocial.com/forum/tips-tricks/1811...-via-sql-query#92326

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

Hi Michal,

Thank you - that's exactly what I looked for.

Does it mean that all user' groups are stored in 1 field? string?

regards,
Udi

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

Hi Michal,

I'm looking for the page you pointd read this topic: www.jomsocial.com/forum/tips-tricks/1811...-via-sql-query#92326

But I get an error - access denied.

Please advise.

regards,
Udi

9 years 6 months ago
Licenses:

Hi, Craig.

Make a safe copy of your DB first!!

Please run this query in db:

(see attached txt file)

your_database_name - replace with your db name
prefix - replace with your db tables prefix
12 - replace with your group ID

What this query does?

Updates data in column "groups" in table "prefix_community_users" in "your_database_name" database. It contains a condition: when cell in "groups" column is empty add just a number, but if there are already other numbers adds number with comma.

- 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

This message has an attachment file.
Please log in or register to see it.

The following user(s) said Thank You: Udi
9 years 6 months ago
  • Udi's Avatar
    Topic Author
  • Udi
  • Offline
  • Fresh Boarder
  • Posts: 52
  • Thank you received: 12
Licenses:
JomSocial Active

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