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!

    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

      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?

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

          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.

            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.

              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?

                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

                  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

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

                      Ninja locked the discussion.
                      Write a Reply...
                      You need to Login to view replies.