Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs

Dashboard
Notifications
Mark all as read
Meta

Imported answers incorrectly reported

+3
−2

There is a post asking about "Plants before the Sun in the Order of Creation."

On my screen, it registers as having no answers, but when I look at the question, I see 4 answers.

Do imported answers not qualify as answers?

Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

0 comment threads

1 answer

+2
−0

Ah, there was another one! Thanks for finding that.

This question was (somehow) imported twice, at these two URLs:

Both questions were then deleted (by the System user), presumably as part of the import.

I saw the first one, because answers were not deleted and that gave me a navigation path. (I have an answer there, so it showed up on my profile.) I undeleted the question and then noticed that every answer was there twice, so I deleted the duplicates. I didn't notice that the reporting was wrong:

screenshot from question page

The first (undeleted) question in the screenshot actually has eight answers, two copies each of four answers. The second (deleted) question has no attached answers but reports having four.

I don't know the details about how import works, but I know that posts (meaning questions and answers) are individually imported and then knitted back together. An incoming answer has a parent ID for the question, but that's an ID on SE, so it needs to be rewritten to match up with the new question ID on Codidact. Apparently something went wrong in those associations, aside from the duplication. (If if were just a duplicate import we would expect to see two questions with four answers each, duplicates all the way down.)

There was at least one other question that came in with duplicate answers, which probably means it, too, has a stub question hiding behind a deletion. This will probably need to be repaired in the database; I'll escalate this to someone who has access to do that.


I'm digging through imported questions now to collect data and fix what needs fixing along the way (to the extent I can).

Unanswered questions that came in twice, one deleted and one not:


Answered questions that came in twice, each with answers intact, one question deleted and the other not, answers on the deleted question were not also deleted (I've fixed that now so confusing links won't show up on profiles):


Answered questions that came in twice, each with answers intact, one question deleted and the other not, and answers on the deleted question were deleted by the system:


Answered questions that came in twice, with the following results:

  • visible question had two copies of each answer, i.e. all imported answers got connected to one of the questions (I deleted the duplicates)
  • visible question reports zero answers on the question list, incorrectly
  • deleted question has zero answers
  • deleted question reports the original number of answers on the question list

These questions did that:


I think that's all of them. I don't know what commonalities questions in each group share, but... here's some data.

Lots of things went wrong in data import, it appears (and we'll want to understand them before doing this again), but I think there are only two extant questions that are incorrectly reporting their answer counts, so I hope that's something a developer can fix in the database.

If I've done this right, then there should be no more bad links on people's profiles -- meaning links to answers on deleted questions where the answers didn't get deleted like they should have. It should be the case now that the only navigation path to these posts is search (for people who can see deleted posts), and if you do that you'll see clearly in the search results that it's deleted.

Why does this post require moderator attention?
You might want to add some details to your flag.

0 comment threads

Sign up to answer this question »

Like any library, this site offers tons of great information, but does not offer personalized, professional advice, and does not take the place of seeking such advice from your rabbi.

This community is part of the Codidact network. We have other communities too — take a look!

You can also join us in chat!

Want to advertise this community? Use our templates!