post_info.asp

		if ForumChkSkipAllowed = 1 then
			strSql = strSql & ", T_STICKY"
		end if

		strSql = strSql & ", T_STICKY"

		if ForumChkSkipAllowed = 1 then
			if Request.Form("sticky") = 1 then
				strSql = strSql & ", 1 "
			else
				strSql = strSql & ", 0 "
			end if
		end if

		if ForumChkSkipAllowed = 1 then
			if Request.Form("sticky") = 1 then
				strSql = strSql & ", 1 "
			else
				strSql = strSql & ", 0 "
			end if
		else
			strSql = strSql & ", 0 "
		end if

quote:

---

Originally posted by Wyrlin

Richard, after appling the above fix I also had to go in to the db and add 0 to the fields already missing it. Could this not be done in Update forum counts? Just a thought.

---

quote:

---

Also, the topics you have already posted, they need to be updated.

if you goto your Admin Options and then choose:

Alternative MOD Setup

Then enter the following in the box:

Update T_STICKY Field
[UPDATE]
TOPICS
T_STICKY#0#(T_STICKY IS NULL)
[END]

(make sure it looks exactly like it does above, there should be 5 lines of code)

and click on Submit.

this will update the existing topics that have the wrong value.

---

quote:

---

Also, the topics you have already posted, they need to be updated.

if you goto your Admin Options and then choose:

Alternative MOD Setup

Then enter the following in the box:

Update T_STICKY Field
[UPDATE]
TOPICS
T_STICKY#0#(T_STICKY IS NULL)
[END]

(make sure it looks exactly like it does above, there should be 5 lines of code)

and click on Submit.

this will update the existing topics that have the wrong value.

---