| Author |
 Topic  |
|
|
Wyrlin
Starting Member
USA
13 Posts |
 Posted - 18 July 2002 : 21:21:40
|
| Does anyone have the Sticky Topic_1_0 mod working with ver 3.3.05 ? I have a problem in the last bit of code in the post_info.asp. I had to do the db updates to access 2000 manually. Thanks. |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 18 July 2002 : 22:02:46
|
I just installed it now, does not seem to be giving me any errors..I will have a play with it and see.
What errors are you getting?
Installation Guide | MODS
Standard trying to be helpful signature above
http://www.ian-hamlin.co.uk
Edited by - Hamlin on 18 July 2002 22:31:33 |
 |
|
|
Wyrlin
Starting Member
USA
13 Posts |
Posted - 19 July 2002 : 06:33:15
|
I get the following error when trying to make a sticky the top sticky.
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57)
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)
/forums/post_info.asp, line 684
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461; .NET CLR 1.0.3705)
Page:
POST 335 bytes to /forums/post_info.asp
POST Data:
ARCHIVE=&Method_Type=Topic&Type=&REPLY_ID=&TOPIC_ID=&FORUM_ID=2&CAT_ID=2&Author=&Mod_ID=&Cat_Title=+&FORUM_Title=Odds-n-Ends&Topic_Title=+&M=&Refer=http%3A%2F%2Flocalhost%2Fforums%2Fforum.asp%3FFORUM_ . . .
and this is line 684...
'################ Sticky Topic MOD ######################
if Request.Form("sticky") = 1 then
strSql = strSql & ", 1 "
strSql = strSql & ", 0 "
elseif Request.Form("sticky") = 2 then
strSql = strSql & ", 1 "
strSql = strSql & ", 999999 "
else
strSql = strSql & ", 0 "
strSql = strSql & ", 0 "
end if
'########################################################
'## strSql = strSql & ", 1 "
strSql = strSql & ")"
my_Conn.Execute (strSql)
Thanks for the help!
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 19 July 2002 : 07:20:56
|
Did you remember to add this part of the code?
'################ Sticky Topic MOD ######################
strSql = strSql & ", T_STICKY"
strSql = strSql & ", T_TOPSTICKY"
'########################################################
Also I think you using an Access 97 database, I had problems when I tried it on access 97, try upgrading the database to access 2000 use one of the access 2000 connection strings, if you can.
EDIT - with access 97 the dbs_mod setup thing does not seem to work, if you change the connection string to an access 2000 one it seems to allow the changes even if its still a access 97 database...I dont know why but it may help, as you said you added the fields by hand.
Installation Guide | MODS
Standard trying to be helpful signature above
http://www.ian-hamlin.co.uk
Edited by - Hamlin on 19 July 2002 07:25:10 |
|
|
|
Wyrlin
Starting Member
USA
13 Posts |
Posted - 19 July 2002 : 07:34:30
|
It is the standard snitz access 2000 db using a dsn connection as that is all my host allows. I added all the code bits. Making a topic sticky seems to work just fine in all aspects, its just making a topic the top sticky that fails.
Thanks.
|
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 19 July 2002 : 07:44:07
|
quote:
It is the standard snitz access 2000 db using a dsn connection as that is all my host allows. I added all the code bits. Making a topic sticky seems to work just fine in all aspects, its just making a topic the top sticky that fails.
Thanks.
If its the database that came with snitz its an access 97 one.
Installation Guide | MODS
Standard trying to be helpful signature above
http://www.ian-hamlin.co.uk |
|
|
|
Wyrlin
Starting Member
USA
13 Posts |
Posted - 19 July 2002 : 08:02:54
|
Its been converted, access 2000 is what I use to make changes to it on my system.
|
|
|
| |
Topic |
|
Topic Locked
