Is it possible to recover a deleted Forum topic

Brett Parker

unread,

Jun 8, 2018, 1:59:30 PM6/8/18

to saka...@apereo.org

Greetings,

I had an Instructor accidentally delete one of their forum topics in a class. Is it possible to recover that in some way? I have DB server backups but rolling back with that would cause data loss with other classes currently active.

So wondering if either it is still in the current database and can be relinked or fixed in a way or exported from a backup that I could spin up in a dev environment and then import back into production in some way?

I feel this is a longshot but if there is anything that can be done please let me know.

Running Sakai 11.3. Thanks.

Brett

Kenwrick Chan

unread,

Jun 8, 2018, 2:23:16 PM6/8/18

to Brett Parker, saka...@apereo.org

In most cases forums leaves data intact but breaks the link between the site and forum content. So if you look in MFR_OPEN_FORUM_T for an existing forum/site relationship value of "surrogateKey" then update the NULL value of surrogateKey (the deleted forum) with the site reference.

kenwrick

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe@apereo.org.
To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

Austin

unread,

Jun 8, 2018, 2:45:09 PM6/8/18

to saka...@apereo.org

find the site's forums

select a.id, a.context_id, b.id, b.title, b.surrogateKey from mfr_area_t as a inner join mfr_open_forum_t as b on a.id = b.surrogateKey where a.context_id = '<site_id>';

since the deleted topic's of_surrogateKey will be null, you may need to search for the topic based on the title, created by, and/or created date

select id, title, of_surrogateKey, pf_surrogateKey, pt_surrogateKey, created, created_by from mfr_topic_t where created_by = '<user_id>' and of_surrogateKey is null;

then update the mfr_topic_t record using the forum id you got from the first query

Brett Parker

unread,

Jun 8, 2018, 3:00:41 PM6/8/18

to Austin, saka...@apereo.org

That is very helpful. Thank you!

-Brett-

From: saka...@apereo.org <saka...@apereo.org> On Behalf Of Austin
Sent: Friday, June 8, 2018 1:45 PM
To: saka...@apereo.org
Subject: Re: [sakai-dev] Is it possible to recover a deleted Forum topic

find the site's forums

select a.id, a.context_id, b.id, b.title, b.surrogateKey from mfr_area_t as a inner join mfr_open_forum_t as b on a.id = b.surrogateKey where a.context_id = '<site_id>';

since the deleted topic's of_surrogateKey will be null, you may need to search for the topic based on the title, created by, and/or created date

select id, title, of_surrogateKey, pf_surrogateKey, pt_surrogateKey, created, created_by from mfr_topic_t where created_by = '<user_id>' and of_surrogateKey is null;

then update the mfr_topic_t record using the forum id you got from the first query

On Fri, Jun 8, 2018 at 8:23 AM, Kenwrick Chan <kc...@hawaii.edu> wrote:

In most cases forums leaves data intact but breaks the link between the site and forum content. So if you look in MFR_OPEN_FORUM_T for an existing forum/site relationship value of "surrogateKey" then update the NULL value of surrogateKey (the deleted forum) with the site reference.

kenwrick

On Fri, Jun 8, 2018 at 7:59 AM, Brett Parker <brpa...@wsc.edu> wrote:

Greetings,

I had an Instructor accidentally delete one of their forum topics in a class. Is it possible to recover that in some way? I have DB server backups but rolling back with that would cause data loss with other classes currently active.

So wondering if either it is still in the current database and can be relinked or fixed in a way or exported from a backup that I could spin up in a dev environment and then import back into production in some way?

I feel this is a longshot but if there is anything that can be done please let me know.

Running Sakai 11.3. Thanks.

Brett

--

You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.

To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.

To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+...@apereo.org.

Austin

unread,

Jun 8, 2018, 3:12:41 PM6/8/18

to saka...@apereo.org

"then update the mfr_topic_t record's of_surrogateKey using the forum id you got from the first query"

On Fri, Jun 8, 2018 at 9:00 AM, Brett Parker <brpa...@wsc.edu> wrote:

That is very helpful. Thank you!

-Brett-

From: saka...@apereo.org <saka...@apereo.org> On Behalf Of Austin
Sent: Friday, June 8, 2018 1:45 PM
To: saka...@apereo.org
Subject: Re: [sakai-dev] Is it possible to recover a deleted Forum topic

find the site's forums

select a.id, a.context_id, b.id, b.title, b.surrogateKey from mfr_area_t as a inner join mfr_open_forum_t as b on a.id = b.surrogateKey where a.context_id = '<site_id>';

since the deleted topic's of_surrogateKey will be null, you may need to search for the topic based on the title, created by, and/or created date

select id, title, of_surrogateKey, pf_surrogateKey, pt_surrogateKey, created, created_by from mfr_topic_t where created_by = '<user_id>' and of_surrogateKey is null;

then update the mfr_topic_t record using the forum id you got from the first query

On Fri, Jun 8, 2018 at 8:23 AM, Kenwrick Chan <kc...@hawaii.edu> wrote:

In most cases forums leaves data intact but breaks the link between the site and forum content. So if you look in MFR_OPEN_FORUM_T for an existing forum/site relationship value of "surrogateKey" then update the NULL value of surrogateKey (the deleted forum) with the site reference.

kenwrick

On Fri, Jun 8, 2018 at 7:59 AM, Brett Parker <brpa...@wsc.edu> wrote:

Greetings,

I had an Instructor accidentally delete one of their forum topics in a class. Is it possible to recover that in some way? I have DB server backups but rolling back with that would cause data loss with other classes currently active.

So wondering if either it is still in the current database and can be relinked or fixed in a way or exported from a backup that I could spin up in a dev environment and then import back into production in some way?

I feel this is a longshot but if there is anything that can be done please let me know.

Running Sakai 11.3. Thanks.

Brett

--

You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe@apereo.org.

To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe@apereo.org.

To post to this group, send email to saka...@apereo.org.
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sakai-dev+unsubscribe@apereo.org.

Reply all

Reply to author

Forward