| Author |
 Topic  |
|
|
Wixxerd
Starting Member
25 Posts |
 Posted - 22 June 2001 : 12:41:08
|
Not sure if this is a bug or something I made happen when applying mods.
Any time I create a new forum, or anytime I create a new topic, it is created as "Locked". On forums, I am unable to unlock them, and life continues.
On topics, I can unlock them, but they still display as locked. I checked T_STATUS on the SQL DB, and it appears that everything else is 1, yet they aren't locked?
Little confused, and need to get this fixed as I'm in the process of finalizing betas and rolling this out to my website...
|
|
|
Wixxerd
Starting Member
25 Posts |
Posted - 23 June 2001 : 14:20:37
|
Does anyone have an answer to this? I really need to resolve this in order to roll these forums out to my site...
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 23 June 2001 : 14:50:06
|
Sounds like instead of using setup.asp to create the tables in the SQL Database, you upsized the Access DB. Upsizing the Access DB doesn't always work, the best way is to use setup.asp to create all of the tables in a SQL Database.
All you need to do is drop all of the current forum tables from the SQL DB and then run:
setup.asp?rc=5 to create the tables again. |
|
|
|
Wixxerd
Starting Member
25 Posts |
Posted - 23 June 2001 : 15:04:00
|
quote:
Sounds like instead of using setup.asp to create the tables in the SQL Database, you upsized the Access DB. Upsizing the Access DB doesn't always work, the best way is to use setup.asp to create all of the tables in a SQL Database.
All you need to do is drop all of the current forum tables from the SQL DB and then run:
setup.asp?rc=5 to create the tables again.
Actually... I just exported the Access tables to the SQL server via ODBC, and then reset all the identity fields.
Did some digging in the code and for some reason in Forum.asp on line #337 is this line : if rsCStatus("CAT_STATUS") <> 0 and rsFStatus("F_STATUS") <> 0 and rs("T_STATUS") <> 0 then %>
Logically this makes sense, if I'm not locked, check topic date for folder color.
I messed with it a bunch, but then discovered if I rewrote the logic to this :
<%if rsCStatus("CAT_STATUS") = 0 and rsFStatus("F_STATUS") = 0 and rs("T_STATUS") = 0 then
if rs("T_LAST_POST") > Session(strCookieURL & "last_here_date") then
Response.Write "<img src=""icon_folder_new_locked.gif"" height=15 width=15 border=0 hspace=0 alt=""Topic Locked"">"
else
Response.Write "<img src=""icon_folder_locked.gif"" height=15 width=15 border=0 hspace=0 alt=""Topic Locked"">"
end if
else%>
<%=ChkIsNew(rs("T_LAST_POST")) %><%
end if
Suddenly, my topics started displaying properly, and I could create new ones without them showing up locked.
Not really sure how a simple logic change fixes this? Honestly, what was there before should have worked???
Do I still need to drop / recreate my tables? Everything else appears ok except my read counts? (I applied Huwr's fix, or was it Kal's? But it didn't seem to fix all of them... just some of them?!??!)
Edited by - Wixxerd on 23 June 2001 15:34:27 |
|
|
| |
Topic |
|
|
|
Topic Locked
