Topic: Question for admins: Add one more post in my thread maybe? (Read 497 times)

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.

As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.

Just to add to LoyceV's reply:
I think when a post is deleted, it's actually moved to a topic which is visible only to admins.
If you go to your report history and click on a deleted post, you will see that the topic ID has been changed.

For example, this post had been made on topic number 5346386. When I click on it in my report history, I go to topic number 5346379 which is not visible to us.

PrimeNumber7

copper member

Activity: 1666

Merit: 1901

Amazon Prime Member #7

Quote from: PrimeNumber7 on July 05, 2021, 08:27:40 PM

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.

Does this mean that you do not keep track of the content of deleted posts? If not, that sounds risky. What did you do with the database entry for the old post?

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.

I think it is more likely that when a post is "deleted" that a field in a table in a record associated with the post is updated to reflect that the post is no longer publically available, so it will not be displayed when someone views a thread. However, the record is kept in the database. Occasionally posts will be removed in error, and when this happens, the admins may restore deleted posts.

Quote from: OgNasty on July 03, 2021, 05:11:58 PM

I think you're confusing deleting posts with archiving (threads) which is kind of like sending it to trash.

The "trash" for most forums is actually a board that is unavailable to the public but is still available to the moderators and/or admins (depending on the forum). It is very rare for threads to be removed from a forum database.

hilariousandco

global moderator

Activity: 3990

Merit: 2717

Join the world-leading crypto sportsbook NOW!

Globals can't do it, but I suppose you could maybe get around it with some trickery by splitting the threads and then merging them with another you created. Probably much easier to get an admin to do it though Grin

.

I can’t imagine the administration would want to start wasting their time handling requests like this. I can only imagine the door they’d be opening to unleash a wave of nonsense on themselves. I would think the preferred method of handling something like this would be to create a new thread and lock the old thread. That way you could handle the issue yourself without admin help.

It's happened a few times before and I think if it's necessary on a important or substantial thread then it should be done. It's provably rare that people run into this issue anyway.

FatFork

legendary

Activity: 1624

Merit: 2594

Top Crypto Casino

Quote from: LoyceV on July 06, 2021, 03:50:11 AM

Quote from: Pmalek on July 06, 2021, 02:40:28 AM

He used the term "repurpose". I believe he checks the database of already deleted posts (posts deleted at one point in the past) and just reallocates the message ID of a matching post to a different forum member.

It looks like it Shocked

This is going to mess up some of the forum scraping.
Your new msgID was originally created by skillscreating.

Quote from: Pmalek on July 06, 2021, 02:40:28 AM

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.

As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.

Really? I didn't know that. Damn, that must be one hell of a database.
I can see how reallocating the message IDs presents problems for scraping forum posts. Good luck with dealing with that mess. Grin

However, theymos' solution is quite elegant for this situation. I can't think of any simpler way to do this.

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

He used the term "repurpose". I believe he checks the database of already deleted posts (posts deleted at one point in the past) and just reallocates the message ID of a matching post to a different forum member.

It looks like it Shocked

This is going to mess up some of the forum scraping.
Your new msgID was originally created by skillscreating.

Quote from: PrimeNumber7 on July 05, 2021, 08:27:40 PM

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.

As far as I know the forum keeps all deleted posts, all edits made (after at least 10 minutes), and only Admins have access to this data.

FatFork

legendary

Activity: 1624

Merit: 2594

Top Crypto Casino

Quote from: PrimeNumber7 on July 05, 2021, 08:27:40 PM

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.

Does this mean that you do not keep track of the content of deleted posts? If not, that sounds risky. What did you do with the database entry for the old post?

Posts are deleted for a reason, storing their content would seem redundant. All posts are essentially records in the database, so removing a post also deletes its record from the database.
I think you're confusing deleting posts with archiving (threads) which is kind of like sending it to trash.

Pmalek

legendary

Activity: 2730

Merit: 7065

Thank theymos, that will come in handy!

Does this mean that you do not keep track of the content of deleted posts? If not, that sounds risky.

I think you guys misunderstood. I don't think theymos meant that he deletes a random post (spam or not) somewhere on the forum to re-use its message ID and make room for an additional post like he did in my thread or in 1miau's.

He used the term "repurpose". I believe he checks the database of already deleted posts (posts deleted at one point in the past) and just reallocates the message ID of a matching post to a different forum member.

PrimeNumber7

copper member

Activity: 1666

Merit: 1901

Amazon Prime Member #7

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.

Does this mean that you do not keep track of the content of deleted posts? If not, that sounds risky. What did you do with the database entry for the old post?

1miau

legendary

Activity: 2226

Merit: 6947

Currently not much available - see my websitelink

Done.

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.

So, we need to find a spam post created later, after the first post but before the next post where we want to have it added, getting the spam post deleted and we can re-use its ID? Cheesy

Yes, I'm following your topic since I`m also having a similar problem.

An ID isn't available right at the top. I added one as far up as possible.

Many thanks, that'll help to re-arrange it a bit.
If the above is true, I'll also try to chase a spam post. Cheesy

theymos

administrator

Activity: 5222

Merit: 13032

Done.

Posts are ordered in threads by message ID. What we do in these cases is that we repurpose the ID of a deleted post which lies in the appropriate range.

Quote from: RapTarX on July 05, 2021, 01:04:28 PM

Yes, I'm following your topic since I`m also having a similar problem.

An ID isn't available right at the top. I added one as far up as possible.

Pmalek

legendary

Activity: 2730

Merit: 7065

That's subjective to censorship Cheesy

I guess. Maybe I'm going off topic. Who has access to DB? Is it only theymos and/or cyrus too? Or any other global moderator?

I doubt global moderators have access to the database. We know from some old posts that theymos has access to it. Someone else has access to an old database of Bitcointalk as well. Whoever hacked the forum back in the day.

Here is one post where theymos talks about who owns and has access to what:

Quote

Bitcointalk.org:
- Cobra has ultimate control over the domain name. I have access to the domain name settings.
- I run the server. Cobra has no access to the database or server.
- The BTC is held by myself and the treasurers. Cobra has no access.

https://bitcointalksearch.org/topic/m.34255007

I don't know of any references that mention that Cyrus has access to the database, but I find it unlikely that he wouldn't have. Based on forum hierarchy, he is next in line and if something happened to theymos I am sure Cyrus has everything he needs to resume the work.

RapTarX

hero member

Activity: 1358

Merit: 851

Quote from: Halab on July 05, 2021, 02:26:29 AM

For Lauda's post, it looks like an edit directly in the DB (but I could be wrong), so don't expect anything.

That's subjective to censorship Cheesy

I guess. Maybe I'm going off topic. Who has access to DB? Is it only theymos and/or cyrus too? Or any other global moderator?
If theymos has access to it, I doubt he would change anything now as this is not a MUST doing, IMO; Lauda was something else though Grin

Halab

staff

Activity: 2408

Merit: 2021

I find your lack of faith in Bitcoin disturbing.

Quote from: 1miau on July 04, 2021, 05:12:38 PM

I will wait for now for an official response here about how it was done for the example from SFR10.
My guess is, it was done by a global moderator, maybe the permission can be given to all moderators.
Should not be much of an issue.

(This is not an official response)
I would be very surprised if GMs have the possibility to insert a post into a topic. I've never heard of this option and Theymos has disabled the option to merge two topics (we can split a topic in two though). I had a quick look at the SMF wiki and didn't see the option to insert a post into a topic. For Lauda's post, it looks like an edit directly in the DB (but I could be wrong), so don't expect anything.

1miau

legendary

Activity: 2226

Merit: 6947

Currently not much available - see my websitelink

Quote from: Pmalek on July 04, 2021, 03:23:37 AM

Quote from: Pmalek on July 04, 2021, 03:23:37 AM

Yes, I'm following your topic since I`m also having a similar problem. In our German "Translation Spam found, here you can report it", my second post is also limited and I can't add more data because I've reached the maximum number of characters.

You are exactly in the same spot as I was. You could maybe ask eneloop to delete his post, which is #3 in your thread. Since posts #4-7 are all yours, maybe you can make some changes and merge two of them together so you can continue with your table from post #2 in post #3.

Yes, I was considering it but I don't want anyone to delete his post(s) and if there's a solution, it would be much better if a new post can be added.
I believe I'm not the only one who would like to add some more "reserved" posts later. I've another topic where I'm running into the same problem but I can edit my next post there whenever I need more space.

Try PMing theymos and ask him directly, why not!? You can use SFR10's post and Lauda's thread as example that it has been done before. You have a valid request and I feel I did as well.

I will wait for now for an official response here about how it was done for the example from SFR10.
My guess is, it was done by a global moderator, maybe the permission can be given to all moderators.
Should not be much of an issue.

Pmalek

legendary

Activity: 2730

Merit: 7065