Archiving query build bug

[Parisian]

Since you removed your bug tracker I'll post it here. When "Has poll" but "Does not have poll" options are ticked for the forum archive setting it builds the query component:

  array(1) {
    [0]=>
    string(34) "poll_state=0 or poll_state IS NULL"
  }

However when this gets compiled to SQL it becomes:

  ["clause"]=>
  string(216) "topic_archive_status=? AND approved=? AND poll_state=0 or poll_state IS NULL AND posts<? AND last_post<? AND pinned=? AND forum_id IN(6,21,31,36,378) AND starter_id NOT IN(1,83091,1690153,28665,209765) AND featured=?"
  ["binds"]=>
  array(6) {

As you can see the or condition is not gated with a parenthesis, it should be:

... (poll_state=0 or poll_state IS NULL) ...

Otherwise the SQL operator logic ignores the entire right hand side of the condition list, which breaks the entire archiving system.

[bfarber]

Thanks for bringing this to our attention. It should be rectified in a future maintenance release.

As an aside, please feel free to submit a ticket when you find a bug to ensure it is seen by the development team and addressed.