freetext with no subs

1. freetext with no subs

   #1

   Okay, I'm not sure whether this is an actual bug or a result of admin experimentation. I've been going through the freetexts (cos I'm working on a sub for the Freetext Mashup) and I came across the freetext of 0 (which happens to be the first freetext listed). I clicked on it and nothing comes up (the freetext page simply reloads). Funny thing is, if I move my cursor over it, it says 9 subs are tagged as 0.

2. Re: freetext with no subs

   #2

   I'm going to say Stubs, In Work Public and In Work Private submissions. They are all capable of being tagged with freetext. Stubs won't show it, and the others are still in the system, but not available to a general query

3. Re: freetext with no subs

   #3

   Oh I see. Thanks for the clarification.

4. Re: freetext with no subs

   #4

   Truth. Was looking at what it would take to modify the query to be more accurate and I am not sure it is worth the extra power involved.
   
   Just thinking out loud here, freetext is stored in the submission as a concated string. The freetext table only holds the freetext and the id of the submission it is connected to. In order to associate the freetext with the status of the sub I would only have to suck up the condition id via the content id. Hmmm.
   
   I am going to do some benchmarking on the two queries and see what's up. Might not be that expensive after all.

5. Re: freetext with no subs

   #5

   That didn't take long. :)
   
   The "0" was an anomaly. Probably a bad delete or something but it was residual in the database. I already did a check on the freetext so all the freetext there should be visible submissions (normal, visible in work, visible collab, whatever).
   
   So I had it right, just that issue with the 0 that had to be cleaned up.
   
   Will have to watch and see if it reappears. If it does, I know the next place I will have to hunt!
   
   Thanks!

6. Re: freetext with no subs

   #6

   I just took a look and the 0 freetext has disappeared so it looks that particular anomaly is gone. So good work :up:

Bug Reports · All categories · Guildhall