| Author |
 Topic  |
|
|
Kal Corp
Average Member
USA
878 Posts |
 Posted - 04 February 2001 : 22:31:03
|
Just tried to use the Allowed Member Listing in DB mode.
Getting File in use with any of the 3 of them 
Can not use , Any help?
Edited by - huwr on 07 February 2001 16:58:33 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 04 February 2001 : 23:09:25
|
the "file in use" error is usually attributed to the setup on the server and not a bug in snitz code itself.
Usually this means that there's two open method called against the same database on the same page. Or it could be that your server was not configured correctly.
I also ran into that error on your site from "show off your forum" category on other parts of your site as well.
- Alan
"True knowledge is knowing how little you really know" |
 |
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 05 February 2001 : 11:40:27
|
I get it once in a while. on my server.
But this Happens evertime I use Allowed member Listing. on two servers.
Ill try again. Worked before the code change
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 05 February 2001 : 16:03:06
|
in inc_functions.asp, change this function to the one below
function getNewMemberNumber()
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & strDBNTUserName & "'"
set rsGetMemberID = my_Conn.Execute(strSql)
if rsGetMemberID.EOF or rsGetMemberID.BOF then
getNewMemberNumber = -1
exit function
end if
getNewMemberNumber = rsGetMemberID("MEMBER_ID")
end function
It was opening an extra db connection.
'Resistance is futile' |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 05 February 2001 : 21:28:10
|
looks like it, testing now, thanks
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 05 February 2001 : 21:45:41
|
Nope.
Fixed that problem, but now cant open Topics
??
lol
|
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 05 February 2001 : 21:57:42
|
Think i found it :-)
your settings, and in the topic.asp
Need to have GetNewmemberNumber() function after INC_TOP.asp
This is why I have had that problem
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 February 2001 : 05:05:25
|
sounds good to me.
'Resistance is futile' |
|
|
|
Kal Corp
Average Member
USA
878 Posts |
Posted - 07 February 2001 : 16:51:55
|
Should that be updated in the download?
|
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 07 February 2001 : 16:57:53
|
quote:
Should that be updated in the download?
I'll cahnge the title to with fix, it should get included in the next release
'Resistance is futile' |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 17 February 2001 : 22:29:23
|
quote:
Think i found it :-)
your settings, and in the topic.asp
Need to have GetNewmemberNumber() function after INC_TOP.asp
This is why I have had that problem
ok... I realize your talking about "Member_ID = getNewMemberNumber()" on or about line 63 in topic.asp... but does just that line need to be moved? or does that line plus the following "if then" statement need to be moved as well after the "<!--#INCLUDE FILE="inc_top.asp" -->" on or about line 73
Thanks
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 18 February 2001 : 06:30:15
|
just the
Member_ID = getNewMemberNumber()
needs to be moved to after the inc_top include, the if then stuff can stay there.
|
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 19 February 2001 : 11:56:11
|
kewl
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
|
Reinsnitz
Snitz Forums Admin
USA
3545 Posts |
Posted - 19 February 2001 : 20:58:43
|
fixed in the source of sf2k_31sr5a6.zip
fixed in the source of sf2k_31sr5a7.zip
Reinsnitz (Mike)
><)))'>
"Therefore go and make disciples of all nations,..." Matthew 28:19a |
|
|
| |
Topic |
|
Forum Locked
Topic Locked
