Author |
Topic |
cripto9t
Average Member
USA
881 Posts |
Posted - 22 December 2004 : 18:46:11
|
quote: Originally posted by bitwise2000
Thanks... in the readme, the changes specified for default.asp puzzle me. I don't find that code in 3.4.03. Is that sub AdminOptions() specific to 3.4.05?
A readme bug . The Default.asp changes should be made in Topic.asp. I'll fix the pronto |
_-/Cripto9t\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 23 December 2004 : 04:17:04
|
Nothing to do. I have updated the pop_flag.asp. I try to modified my admin_forums.asp but i have always the same error:
All replies to Topics older than 11/23/2004 10:07:47 AM were archived
Microsoft JET Database Engine error '80040e14'
Syntax error in INSERT INTO statement.
/forumgdr/admin_forums.asp, line 646
|
Edited by - ken derringer on 23 December 2004 09:44:06 |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 23 December 2004 : 08:02:11
|
Ken I made a copy of your admin_forums, could you edit your last post and remove it so we don't have to scroll down as much . It's always better to post a link to files or just a few lines above the error.
I'll take a guess and say it's the poll mod. quote: If you have added fields to the (TOPICS and A_TOPICS) or (REPLY and A_REPLY) database tables, you will need to add them to the forum Sqls' in the "unarchive" portion of "pop_flag.asp".
It needs to be added to pop.flag.asp.
Remove the comments ' from the code in red. Then archive the forum and post the results.
strsql = "INSERT INTO " & strArchiveTablePrefix & "TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG)"
strsql = strsql & " VALUES (" & strsqlvalues & ")"
'Response.Write strSql
'Response.End
Needs to look like
strsql = "INSERT INTO " & strArchiveTablePrefix & "TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG)"
strsql = strsql & " VALUES (" & strsqlvalues & ")"
Response.Write strSql
Response.End Also don't unarchive any more posts until polls have been added to your pop_flag.asp. |
_-/Cripto9t\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 23 December 2004 : 09:56:11
|
THis is the result of the admin_forum.asp:
All replies to Topics older than 11/23/2004 3:48:15 PM were archived
.
Topic exists, Stats Updated...... .
Topic exists, Stats Updated...... .
Topic exists, Stats Updated...... .
Topic exists, Stats Updated...... INSERT INTO FORUM_A_TOPICS (CAT_ID, FORUM_ID, TOPIC_ID, T_STATUS, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_POLLSTATUS, T_SIG) VALUES (1, 1, 1740, 0, 'Manowar vs Blind Guardian', 'Caro Zac, come ti permetti di definire i mitici MANOWAR "merda" , occupano il monolocale del mio cuore insieme ai grandissimi bardi di Krefeld ed ai bambini terribili di Bodom. Hai provato ad ascoltare canzoni immortali come "Heart of Steel" piuttosto che "Battle Hymns" o ancora "Blood of the Kings", "Sign of the Hammer", la lista potrebbe essere ancora lunga. Ignoranti! Arroganti!, ascoltati "Kings of Metal" e poi "Warriors of the world" e poi parla! Sono gli unici che reggono il confronto con i quattro del guardiano cieco! "We don''t turn down for anyone we do what the **** we please!" P.s. Sarebbe un''accopiata vincente! Nick', 557, 74, 0, 1088, '20040919193144', '20040712143756', 0, '82.48.120.109', 369, 56120, '', NULL, 0, , 0, 0 ) |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 23 December 2004 : 12:04:50
|
One of the poll fields is empty.
I Added Davios' poll to pop_flag.asp. I'll post it in a seperate post. You will need to make those changes and you still need to make the changes to admin_forums.asp, if you haven't already.
I'll see if I can write something temporary to fix that post.
|
_-/Cripto9t\-_ |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 23 December 2004 : 12:05:57
|
Adding Davios' Poll Mod
All these changes are in pop.asp
- Find this code (line 43)
strSql = strSql & " T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_SIG, T_MESSAGE" ADD ",T_ISPOLL " so it looks like this
strSql = strSql & " T_LAST_EDIT, T_LAST_EDITBY, T_STICKY, T_ISPOLL, T_SIG, T_MESSAGE"
- Find this code (line 70)
tLastedit = rsChk("T_LAST_EDIT")
tLasteditby = rsChk("T_LAST_EDITBY")
tSticky = rsChk("T_STICKY") ADD this line under that
tIspoll = rsChk("T_ISPOLL")
- Find this code (line 142)
strTValues = strTValues & ", " & 0
strTValues = strTValues & ", " & tLastedit
strTValues = strTValues & ", " & tLasteditby
strTValues = strTValues & ", " & tSticky ADD this code under that
strTValues = strTValues & ", " & tIspoll
strTValues = strTValues & ", " & 0
- Find this code line (166)
strSql = strSql & ", T_ARCHIVE_FLAG"
strSql = strSql & ", T_LAST_EDIT"
strSql = strSql & ", T_LAST_EDITBY"
strSql = strSql & ", T_STICKY" ADD this code under that
strSql = strSql & ", T_ISPOLL"
strSql = strSql & ", T_POLLSTATUS"
That's it |
_-/Cripto9t\-_ |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 23 December 2004 : 12:38:58
|
Ken the easiest way to archive that forum would be to delete the topics you unarchived. If you want to save the posts you can try the following: Are any of the topics you unarchived polls? If not you can add this bit of code, I think you will be able to archive that forum.
Find this in admin_forums.asp
strSQL = "SELECT TOPIC_ID FROM " & strArchiveTablePrefix & "TOPICS WHERE TOPIC_ID=" & drs("TOPIC_ID")
set rsTcheck = my_conn.execute(strSQL)
if isnull(drs("T_LAST_EDITBY")) then
intT_LAST_EDITBY = "NULL"
else
intT_LAST_EDITBY = drs("T_LAST_EDITBY")
end if
if isnull(drs("T_LAST_POST_REPLY_ID")) then
intT_LAST_POST_REPLY_ID = "NULL"
else
intT_LAST_POST_REPLY_ID = drs("T_LAST_POST_REPLY_ID")
end if
if isnull(drs("T_UREPLIES")) then
intT_UREPLIES = "NULL"
intT_UREPLIEScnt = 0
else
intT_UREPLIES = drs("T_UREPLIES")
intT_UREPLIEScnt = drs("T_UREPLIES")
end if ADD this code under that
'## temporary code to fill empty field in topics table
if trim(drs("T_ISPOLL")) = "" then
drs("T_ISPOLL") = 0
end if Then add the comments back to 'Response.Write strSql 'Response.End
Then archive the forum again. |
_-/Cripto9t\-_ |
|
|
bitwise2000
Starting Member
38 Posts |
Posted - 27 December 2004 : 16:08:28
|
Cripto9t; this a very nice, useful mod. However, the instructions in the readme don't nearly match the code changes specified in the sample files you provide. The latter are correct, making the changes as described in the readme will result in trouble. Otherwise, good work! |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 27 December 2004 : 17:48:44
|
quote: Originally posted by bitwise2000
making the changes as described in the readme will result in trouble. Otherwise, good work!
Thanks bitwise, I appreciate your input. I usually do a fresh install useing only the readme, so I can find the mistakes. However I don't recall doing that with this mod . I'll install it useing only the readme and try to work out the mistakes.
|
_-/Cripto9t\-_ |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 10 January 2005 : 04:48:13
|
Ok, Now it works. Thanks! If I have other problem, i write you! |
|
|
ken derringer
Starting Member
40 Posts |
Posted - 10 January 2005 : 05:18:31
|
Ok. I have found a problem! Don't hate me... I see that I don't have the flag/unflagh icons, if the topic is "stickly". The topic is archived, and I can't unarchive that. I can unarchive that only if I unstickly the topic... |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 10 January 2005 : 11:36:49
|
Ken that's the way it should work.
The icons shouldn't show if a topic is "sticky". Sticky topics are flagged from archiving.
As for the unarchiving, I didn't realise you could make a topic sticky in the archives until I read your post . I think it should stay as is. A topic must be "unstuck" before it can be unarchived just as it has to be "unstuck" for archiving.
I hope this all makes sense . |
_-/Cripto9t\-_ |
|
|
ppehrson
Starting Member
14 Posts |
Posted - 10 January 2005 : 16:40:15
|
Maybe I'm just a *** but it is Topic.asp you need to edit. NOT default.asp as stated in the readme.
-peter |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 13 January 2005 : 09:57:23
|
Download updated. I made a few changes in pop_flag.asp concerning count updates. The old file worked fine but this one looks neater.
I also added a new HTML readme. It's easier to read. I used it to do a clean install, so the readme mistakes should be corrected.
|
_-/Cripto9t\-_ |
|
|
skwayb
Starting Member
17 Posts |
Posted - 01 February 2005 : 16:58:34
|
Got the mod installed and through testing I am running into this error on MSSQL when I try to unarchive a message. quote: Microsoft OLE DB Provider for SQL Server error '80040e14'
Cannot insert explicit value for identity column in table 'FORUM_TOPICS' when IDENTITY_INSERT is set to OFF.
/forum/pop_flag.asp, line 173
Looks like I need to add quote: SET IDENTITY_INSERT FORUM_TOPICS ON
Before the insert statement and then turn IDENTITY_INSERT off after it is done so the same thing can be done for the FORUM_REPLY table before the insert.
Any ideas? Or does that look like the only option since both the Reply_ID and Topic_ID are identities.
|
Edited by - skwayb on 01 February 2005 17:02:12 |
|
|
Topic |
|
|
|