Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Error unsuppored lock type w/mysql
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 3

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 19 August 2002 :  23:27:34  Show Profile
Can you try removing line #1 in the config.asp file?
Go to Top of Page

bobbart
Junior Member

USA
163 Posts

Posted - 19 August 2002 :  23:41:07  Show Profile  Send bobbart an ICQ Message
quote:
Originally posted by RichardKinser

can you try changing that to:

allCategoryData = rs.GetRows



Ok it went to 2 more lines and I changed them and the default page came up.

Now there are other pages that still come up with this error. Do I have to adjust them to? Or do we have an idea what is the cause so I can fix that instead?
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 19 August 2002 :  23:43:47  Show Profile
first try removing line #1 in config.asp and see if that fixes it. If not, then you'll need to fix the other files just like you did with default.asp.
Go to Top of Page

bobbart
Junior Member

USA
163 Posts

Posted - 20 August 2002 :  00:05:23  Show Profile  Send bobbart an ICQ Message
You just want me to remove this line?
<!--METADATA TYPE="typelib" UUID="00000205-0000-0010-8000-00AA006D2EA4" NAME="ADODB Type Library" -->

If it is then it makes no change. I still get the error on other pages. Such as when I go to members.asp

Edited by - bobbart on 20 August 2002 00:08:04
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 August 2002 :  00:07:07  Show Profile
yes
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 August 2002 :  00:10:56  Show Profile
you can leave that line out, I don't think it's supported on unix/linux server anyways. Unfortunately it looks like the only thing to do to the other files what you did to default.asp.

I can suggest a good Search and Replace tool, if you don't have one.

www.funduc.com (their's is pretty good, and you can use it as a trial version for a certain amount of days)
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 August 2002 :  00:13:30  Show Profile
the guy (Davio) who works with MySQL for us is on vacation right now. He did most of the testing with MySQL on a Linux server. During testing, everything worked like it should.
Go to Top of Page

bobbart
Junior Member

USA
163 Posts

Posted - 20 August 2002 :  00:50:04  Show Profile  Send bobbart an ICQ Message
Ok I replaced what we talked about and all seems to be working. I hope that I dont run into a problem with that missing code.

Thanks alot for your help
Go to Top of Page

bobbart
Junior Member

USA
163 Posts

Posted - 20 August 2002 :  00:57:51  Show Profile  Send bobbart an ICQ Message
I tried to create a new catigory and I got this error.

Microsoft VBScript runtime error '800a000d'
Type mismatch: 'recForumCount'

/forum/default.asp, line 383


chkDisplayHeader = true

bContainsForum = False
for iForumCheck = 0 to recForumCount
if CatID = allForumData(fCAT_ID, iForumCheck) then bContainsForum = True
next
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 20 August 2002 :  01:38:00  Show Profile
find the following on line #383 of default.asp:

		for iForumCheck = 0 to recForumCount
if CatID = allForumData(fCAT_ID, iForumCheck) then bContainsForum = True
next



and change it to this:

		if recForumCount <> "" then
for iForumCheck = 0 to recForumCount
if CatID = allForumData(fCAT_ID, iForumCheck) then bContainsForum = True
next
end if
Go to Top of Page

bobbart
Junior Member

USA
163 Posts

Posted - 20 August 2002 :  05:00:14  Show Profile  Send bobbart an ICQ Message
Ok we seem to be good now.
Go to Top of Page

mfury88
Starting Member

2 Posts

Posted - 20 August 2002 :  22:11:04  Show Profile
I'm running into the same problem. I went through, search and replaced all the connection strings and getRow methods and I got it to work. But the only problem is NO replies are showing up now when you get into each topic. Seems like some problems with Chilisoft. The odd thing is, it works fine with 3.3.03 (or whatever version is a little earlier)
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 August 2002 :  22:16:34  Show Profile  Send ruirib a Yahoo! Message
Hmmm... that sounds familiar. See if any info here is of help: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=32014


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

marcus_giles
Starting Member

United Kingdom
4 Posts

Posted - 23 August 2002 :  22:50:55  Show Profile  Visit marcus_giles's Homepage
Got the same issue - has anyone got a patched version with all the security fixes?

Marcus
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 23 August 2002 :  22:53:38  Show Profile  Send ruirib a Yahoo! Message
A new version with many bug fixes isn't out yet, but should be in just a few hours.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 3 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07