suddenly archived activities - groups are empty! Recovery!

YIDO

Hello after one of my fellow grandmasters registered in one of my groups today, I have to say that the activities of my groups have been archived. Why?
1) Is there an expiration date after activities are archived? Where can I change it or set it to unlimited!
2) How can I reactivate or restore the archived articles from the page or group activities? If I mark all archived articles and then click on marked archived again, this is only carried out for a few. The rest remains archived? Apparently there has to be a limit somewhere. This MUST go! With the request for quick help.
Thank you!

Ninja

YIDO
Hi
Apply this :
take a backup of site first.
The :

you need to execute this query from phpmyadmin or database manager that provided by your hosting.
UPDATE#_community_activitiesSETarchived= '0' ;

replace #_ with your table prefix, e.g: jos_community_activities

YIDO

error
Static analysis:

2 errors were found during the analysis.

Unexpected sign. (near "=" at position 45)
Unexpected sign. (near "'0'" at position 47)
SQL command:

UPDATE d1ay7_community_activitiesSETarchived = '0'

MySQL reports: Documentation

1064 - SQL syntax error. Please look up the correct syntax in the manual at '' 0 '' in line 1

Please have a look on it. I have made a backup and than I tried to run your script on PhpMyAdmin. Do you have a Idea, what is going wrong?

Ninja

YIDO
Hi
Kindly edit fields in first post and submit PHPmyadmin login.

YIDO

I do not quite understand. I have adjusted your code according to your instructions. Unfortunately, something seems wrong, as you can see from the screenshot. Apparently, [= '0'] is not a valid argument. Unfortunately I am not familiar with the programming language, so I ask you to help me here. Thank you.

Ninja

YIDO
Hi
The Activities state are set to 1 at the moment and by above query it will back to 0 to make visible.
I need phpmyadmin login to apply this for you.
please submit the details in edit fields option so i can do this on your site.

YIDO

Hello, I have now moved my Jomsocial to another domain (now: Yido.de). So far everything works again except for my unwanted archived articles in the feed. (I wonder how could this happen and where can I prevent the program from archiving automatically? Can you make settings somewhere that should not be archived please?

Thank you for your offer via MyPhpAdmin. How can I give you SQL access restricted to the affected database without having to reveal my entire provider access? (There is also sensitive data in other databases, which I am not allowed to make accessible) Do you have any instructions?

Ninja

YIDO
Hi
This is from your cpanel, you can ask your hosting provider about the access part.

please open your PHPMyAdmin, select the database and execute this SQL:
UPDATEd1ay7_community_activitiesSETarchived= '0';
so it will no archived activity items anymore.

Query : http://prntscr.com/t2fzr8

YIDO

Hi, Pankaj,

it finally worked. It was the missing spaces before and after SET! (Were unfortunately not inserted in your first mail. For you this might be a matter of course, for me as a programming amateur it was a big challenge. But last but not least, all archived articles are back now!

Thanks and regards
Uwe

Ninja

YIDO
Forum editor removed the tags so i added it again carefully with screenshot to avoid the errors.
Glad to hear it works!