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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 Another type mismatch for mySql 5
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

cripto9t
Average Member

USA
881 Posts

Posted - 16 December 2006 :  19:12:18  Show Profile
This ones in "admin_count,asp". Its the same as before sum() not being returned as an integer.

Around line 407

			'## Forum_SQL - Count total number of Replies
			strSql = "SELECT Sum(" & strTablePrefix & "TOPICS.T_REPLIES) AS SumOfT_REPLIES, Count(" & strTablePrefix & "TOPICS.T_REPLIES) AS cnt "
			strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
			strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.FORUM_ID = " & ForumID
			strSql = strSql & " AND " & strTablePrefix & "TOPICS.T_STATUS <= 1"

			set rs1 = my_Conn.Execute(strSql)

			if rs1.EOF or rs1.BOF then
			        intF_COUNT = 0
				intF_TOPICS = 0
			else
				intF_COUNT = cLng(rs1("cnt")) + cLng(rs1("SumOfT_REPLIES"))
				intF_TOPICS = cLng(rs1("cnt")) 
			end if
			if IsNull(intF_COUNT) then intF_COUNT = 0 
			if IsNull(intF_TOPICS) then intF_TOPICS = 0 

			set rs1 = nothing

Also the sql after right after this counts the Archived topic_replies and needs the same changes<

    _-/Cripto9t\-_

Edited by - AnonJr on 17 March 2009 19:11:52

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 16 December 2006 :  20:08:33  Show Profile
I have always gotten an exception occurred error on admin_count.asp page, never a type mismatch. This was using MySQL 5.0.15-nt
I just downloaded MySQL 5.0.27-nt and will try again.

What options are you using in your connection string? I am using option=16387.
What version of MySQL 5 are you using?<

Support Snitz Forums
Go to Top of Page

cripto9t
Average Member

USA
881 Posts

Posted - 18 December 2006 :  19:52:46  Show Profile
Davio the version is 5.0.24a-community-nt. I'm using the same option as you in the connection string.<

    _-/Cripto9t\-_
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 07 January 2008 :  21:02:57  Show Profile
The same code used for the admin_forums.asp type mismatch was used for this fix as well. See the fix here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=63480

Fixed in version 3.4.07.<

Support Snitz Forums
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.07 seconds. Powered By: Snitz Forums 2000 Version 3.4.07