SQl query for Reset Groups Dates

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.

SQl query for Reset Groups Dates

12 years 3 weeks ago

#105206

Topic Author
testcouch
Offline
Junior Boarder
Posts: 110
Thank you received: 12

Licenses:

JomSocial Expired

hi, i know it's not realy a support question but it would helps me to push activity on my site. i use jomsocial since few years and during the time there are admin created groups wich looks quite old for new Member.

i would need a sql query that adds +2 Years to a respective Group ID..including Group Creation Date, Discussions Date, Announcement Date, Activities Date..and so on

is something possible? many thanks

12 years 3 weeks ago

#105211

Michał
Offline
Moderator
Posts: 13447
Thank you received: 3689

Licenses:

Hi.

That will be a whole set of SQL queries, and quite complicated as you want to add years to date not change whole (by replacing be certain date). I'm not sure if this is possible using pure SQL or you need to have php application for this...

Nevertheless I can't help you with this. I suggest to ask professional developer for help:
www.jomsocial.com/jomsocial-developers

- 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

Notice

Support Forum

SQl query for Reset Groups Dates

Licenses:

Licenses:

Join 180,000 websites creating Amazing communities

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere