| Author |
 Topic  |
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
 Posted - 10 November 2001 : 01:57:28
|
Yes there are two mods that I noticed, one calling the field T_INPLACE and one calling T_MSGICON
As richard said, those fields will have to be created in the archive table. The forum.asp I just sent you will work (should anyway), but will remove those mods from showing up... I still have the old one if you want me to send you that back, if you want to create those fields in the archive tables.
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 November 2001 : 02:04:56
|
| Eric, Can I send you an updated version of a MOD that I posted on your Resource Site? I uploaded an older version the other night that didn't have the corrected dbs files to prevent this problem. |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 02:08:13
|
Sure :)
Soon I want to get the feature to re-upload a mod into the site, but I'd have to disable the error checking that checks for files already on in the directory, but then someone could edit there mod and overwrite someone elses file, thats why thats taking so long.
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 02:21:03
|
ok its updated :)
----------
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code
Need a Mod? Check out the Mod Resource |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 10 November 2001 : 02:24:24
|
Thanks.
For Capt_Dunzell:
just place the following code in a new file (you can just name it dbs_messageiconsfix.asp) and upload it to your forum directory.
Message Icons Mod Archive Fix(Default)
[ALTER]
A_TOPICS
ADD#T_MSGICON#int#NULL#1
[END]
[ALTER]
A_REPLY
ADD#R_MSGICON#int#NULL#1
[END]
Then click on MOD Setup in your Admin Options to run it. |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 10:38:14
|
Okay, different error now. 
I ran the database update, and put in Erics forum.asp and I get:
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum.asp, line 365
Line 365:
<td bgcolor="<% =strForumCellColor %>" valign="center" align="center"><img src='icon_mi_<% =rs("T_MSGICON") %>.gif' height=15 width=15 border=0 hspace=0></td>
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 10:42:32
|
yeah that would be because I removed calling them from the DB :( if you backed up the old forum.asp you had, use that and it should work. If not I still have it, let me know and I'll send it to you.
----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 10:47:05
|
I tried my old Forum.asp and it gave me the same error as the first post.
http://66.34.117.92/forum/ |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
Posted - 10 November 2001 : 20:30:18
|
Okay, I started with a new forum.asp file and added back in the mods I have installed, testing each one as I finished. The issue is caused by the Lock in place mod with this code:
--------------------------------------------------------------------
forum.asp
--------------------------------------------------------------------
Approx. Line 138, you will find this line
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
Change the code to this
strSql = strSql & " ORDER BY " & strTablePrefix & "TOPICS.T_INPLACE DESC "
strSql = strSql & " , " & strTablePrefix & "TOPICS.T_LAST_POST DESC "
---------------------------------------------------------
Is there a way to make this mod work while still having a functioning archive?
http://66.34.117.92/forum/ |
|
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 20:45:01
|
Change any instance of 'strTablePrefix' to 'strActivePrefix' and see what that does
----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Da_Stimulator
DEV Team Forum Moderator
USA
3373 Posts |
Posted - 10 November 2001 : 21:12:48
|
Ok, I'm ASSUMING (thats a bad thing) that the T_INPLACE is an intiger. You may want to open the dbs setup file and find out, and alter the following code to suit. But put this in any text editor and save it as dbs_fixinplace.asp and upload it to your forum directory, and run admin_mod_dbsetup.asp and select 'Fix Topic In Place'
Fix Topic In Place
[ALTER]
A_TOPICS
ADD#T_INPLACE#int#NULL#
[END]
[ALTER]
A_REPLY
ADD#T_INPLACE#int#NULL#
[END]
----
-Eric (da_stimulator)
Stims Snitz Test area - Running 3.3.03, 4 beta, Huw's code, and Davio's code
Need a Mod? Check out the Mod Resource |
|
|
|
Capt_Dunzell
Junior Member
USA
160 Posts |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 11 November 2001 : 07:42:58
|
Make sure you have added T_INPLACE and T_MSGICONS to your FORUM_A_TOPICS table.
Then for EVERY instance in forum.asp where T_INPLACE or T_MSGICON is included in an Query string being built, double check you have strActivePrefix in front of it.
This worked for me fine on my forums as I had the exact same problem a while back.
Halo of Xegony |
|
|
|
Topic |
|
Topic Locked
