| Author |
 Topic  |
|
Wipeout2k
Starting Member
8 Posts |
 Posted - 27 February 2002 : 17:02:08
|
Running v3.3.03 w/ Avatar mod
Tried both HUWRs mod, as well as the sticky topic.
Followed the readme, extracted the files to the proper location, but the admin_mod_dbsetup.asp hangs. It just sits there doing nothing, leave it for 5-10 min, still nothing.
Any ideas of where this may be erroring?
-Wipe
Edited by - Wipeout2k on 27 February 2002 17:03:02 |
 |
|
|
Rmak
Starting Member
13 Posts |
Posted - 28 February 2002 : 00:08:00
|
Hello... im new to this MOD installation and everything and with this snizz forum....
i just finish installing the sticky MOD, but this might sounds stupid but where is the option to make it sticky???
i did all the modifications within the forum.asp,post.asp,post_info.asp when im posting with admin account i dont see the button to make it sticky.
did i miss a step somewhere?
thanks for the help
Rob
|
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 03 March 2002 : 12:02:23
|
quote:
Without wanting to drag this out, I tried to run the MOD on my forum and I got the error:
Adding Column T_STICKY...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_STICKY int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
I get this error as well.
Snitz 3.3.3
Access 2000 DB.
Private hosting.
I simply opened the DB up in Access and added the fields manually.
 |
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 03 March 2002 : 13:04:24
|
quote:
... getting that error message when i click on a topic i am getting this one
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
I also had this error.
It is because the two Sticky fields were not added to the fetch of the Topic Data Fields.
I added the two fields in here:
'## Forum_SQL - Get all topics from DB
strSql ="SELECT " & strActivePrefix & "TOPICS.T_STATUS, " & strActivePrefix & "TOPICS.CAT_ID, "
strSql = strSql & strActivePrefix & "TOPICS.FORUM_ID, " & strActivePrefix & "TOPICS.TOPIC_ID, "
strSql = strSql & strActivePrefix & "TOPICS.T_VIEW_COUNT, " & strActivePrefix & "TOPICS.T_SUBJECT, "
strSql = strSql & strActivePrefix & "TOPICS.T_AUTHOR, "
'#### KC Sticky Topic Mod 0 - 4 ############################
strSql = strSql & strActivePrefix & "TOPICS.T_STICKY, "
strSql = strSql & strActivePrefix & "TOPICS.T_TOPSTICKY, "
'#### END KC Sticky Topic Mod 0- 4 ############################
strSql = strSql & strActivePrefix & "TOPICS.T_REPLIES, " & strActivePrefix & "TOPICS.T_LAST_POST, "
strSql = strSql & strActivePrefix & "TOPICS.T_LAST_POST_AUTHOR, "
strSql = strSql & strMemberTablePrefix & "MEMBERS.M_NAME, "
strSql = strSql & "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS, "
strSql = strSql & strActivePrefix & "TOPICS, "
strSql = strSql & strMemberTablePrefix & "MEMBERS AS MEMBERS_1 "
That is about 20 lines above where the first of the 4 mods to FORUM.ASP go.
I number mods on a given page so I know how many to look for, and already had them numbered 1-4 to 4-4, so I named this one 0-4 in case you are wondering what that was.
I also put ny name is if it's something I did to an existing mod.
I suppose I should have just renumbered them 1-5 to 5-5 but what the heck ;-}
It would be nice to have the MOD install rotine fixed.
As mentioned in a post above this, I had to manually edit the DB.
One other note.
I am trying this mod on a new forum with only a couple of posts.
I manually put 0 values in the exsting topics I had for the two Sticky fields.
My guess is if you install this on an existing database with a lot of posts, you are going to have some problems with the existing topics have no value in these fields.
You MAY need to write a simple script to open the DB and place 0's in both of these fields for every record.
KC
|
|
|
|
KC
Junior Member
USA
152 Posts |
Posted - 03 March 2002 : 14:22:37
|
Yet another bug...
When clicking the UP ARROW from the Forum.asp page to stick a topic, I get the input box, select YES, make it sticky, and got:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)
/evo1/pop_stick.asp, line 79
Then I tried another topic and selected NO, and it "stuck it"!
So I have a topic that would have been the last topic stuck as the 1st.
I open the Topic OK, but you can't go to "Next Oldest" topic.
That I assume is because we don't modify the TOPIC.asp page to take this into account.
I could have lived with that but clicking Previous Topic put the server into a loop and crashed the .asp server.
Now I am a pretty good .asp and VBscript programmer, but this is a bit more trouble than it's worth so I've removed the code.
Over-and-out.
|
|
|
|
BogieMan
New Member
USA
88 Posts |
Posted - 04 April 2002 : 20:45:23
|
move to top of forum by request
|
|
|
|
SubKamran
Junior Member
101 Posts |
Posted - 04 April 2002 : 21:59:26
|
thanks!
Kamran A
14/m/mn
Minneapolis, MN
Web Dev/Flash Dev |
|
|
|
HarlekinWF
New Member
Germany
77 Posts |
Posted - 25 April 2002 : 08:01:24
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/forum.asp, line 240
i get this error, what nust i change?
http://forum.killers-in-action.com
thnx
|
|
|
|
Frostnorth
Starting Member
11 Posts |
Posted - 24 June 2002 : 17:20:31
|
The mod is not online....
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
|
|
Frostnorth
Starting Member
11 Posts |
Posted - 25 June 2002 : 07:13:32
|
it gives me this error
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/sforum/forum.asp, line 252
and these are the lines 252-258 on my forum.asp
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
i hope you can help me :(
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 June 2002 : 09:49:48
|
quote:
response.write(strSql)
response.end
rs.open strSql, my_Conn, 3
if not (rs.EOF or rs.BOF) then
rs.movefirst
rs.pagesize = strPageSize
maxpages = cint(rs.pagecount)
rs.absolutepage = mypage
end if
Add the code in red and tell post the sql string produced.
.::Hamlin::.
The Arsenal!
In the time of chimpanzees I was a monkey
I was also an insomniac |
|
|
|
Frostnorth
Starting Member
11 Posts |
Posted - 25 June 2002 : 09:55:32
|
O_o
SELECT FORUM_TOPICS.T_STATUS, FORUM_TOPICS.CAT_ID, FORUM_TOPICS.FORUM_ID, FORUM_TOPICS.TOPIC_ID, FORUM_TOPICS.T_VIEW_COUNT, FORUM_TOPICS.T_SUBJECT, FORUM_TOPICS.T_AUTHOR, FORUM_TOPICS.T_REPLIES, FORUM_TOPICS.T_LAST_POST, FORUM_TOPICS.T_LAST_POST_AUTHOR, FORUM_TOPICS.T_STICKY, FORUM_TOPICS.T_TOPSTICKY, FORUM_MEMBERS.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME FROM FORUM_MEMBERS, FORUM_TOPICS, FORUM_MEMBERS AS MEMBERS_1 WHERE FORUM_MEMBERS.MEMBER_ID = FORUM_TOPICS.T_AUTHOR AND FORUM_TOPICS.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID AND FORUM_TOPICS.FORUM_ID = 3 ORDER BY FORUM_TOPICS.T_TOPSTICKY DESC , FORUM_TOPICS.T_STICKY DESC , FORUM_TOPICS.T_LAST_POST DESC
seems to be a little weird :
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 25 June 2002 : 10:04:23
|
well with my somewhat un-trained eye  i dont think that looked wrong 
the only bit i did not get was MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME FROM FORUM_MEMBERS,, but i think thats just me.
did u add the tables to the database, that may give the error as it cant find a matching name...correct me if i wrong someone please.
maybe post a text link to the file as well, i'll have another look at the sql stuff slower this time
.::Hamlin::.
The Arsenal!
In the time of chimpanzees I was a monkey
I was also an insomniac |
|
|
|
Frostnorth
Starting Member
11 Posts |
|
|
Topic |
|
Topic Locked
