MyBB 1.8.20 Pre-Release Build

[woostar]

Just checking this is only a file-change update, since the install folder hasn't been updated.

---

Is it just my test forum or have 2 new queries come from somewhere:

SELECT replyto FROM test_posts WHERE visible = 0

SELECT COUNT(aid) AS unapprovedattachments FROM test_attachments WHERE visible=0

Save me having to look for them, where are they located?

---

OK, scrub the query question. Found it here: https://github.com/mybb/mybb/pull/3488/files

---

Typo when a thread is waiting for approval

"and aiting Moderation: 1 unapproved thread."

---

Narrowed down the error to rogue code on line 783 - global.php

	$moderation_queue = substr_replace($moderation_queue, ' '.$lang->and.' ', strrpos($moderation_queue, $lang->comma), strlen($lang->comma));

---

I can fresh install, but is anyone else having problems dropping the files into an existing 1.8.19 forum (using 1.8.19 database).

I'm guessing there must be a change somewhere in the database.

---

The remove attachment works well when editing an existing post... but if you add an attachment to a new thread (or new post in advanced mode) and then change your mind and press the remove button before posting, it doesn't remove the attachment Ajax (although it does actually remove it from the post - it doesn't look like its been removed).

Hard to explain. You'll need to try it to see what I mean lol.