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 (Open)
 V33(all) BUG + FIX: admin_forums.asp		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

DanJP
Starting Member

USA
20 Posts
Posted - 08 June 2002 :  13:22:30  Show Profile  Visit DanJP's Homepage
When attempting to archive all topics I got the following error:
MS SQL Server 6.5
Snitz V 3.03.05

The No replies were archived was as it should be, but the ODBC error isn't. Sorry if this is a known issue, or I'm being a pest. Just a Snitz newbie trying to put things through their paces and finding a few odities. If you want me to go away, just say so

No replies were archived, none found


Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'varchar' to datatype 'int' Table: 'DANJPDB.dbo.FORUM_A_TOPICS', Column: 'T_REPLIES' Use the CONVERT function to run this query.

/admin_forums.asp, line 618


RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 08 June 2002 :  15:57:20  Show Profile
the problem is on line #612:

strsqlvalues = strsqlvalues & "', " & drs("T_AUTHOR") & ", '" & drs("T_REPLIES") & "', " & drs("T_VIEW_COUNT")


replace it with this:

strsqlvalues = strsqlvalues & "', " & drs("T_AUTHOR") & ", " & drs("T_REPLIES") & ", " & drs("T_VIEW_COUNT")
Go to Top of Page

DanJP
Starting Member

USA
20 Posts
Posted - 08 June 2002 :  16:47:10  Show Profile  Visit DanJP's Homepage
Looks likes there's more. Now I get:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

[Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'varchar' to datatype 'int' Table: 'DANJPDB.dbo.FORUM_A_TOPICS', Column: 'T_LAST_POSTER' Use the CONVERT function to run this query
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 08 June 2002 :  16:54:39  Show Profile
replace line #613 & #614:

strsqlvalues = strsqlvalues & ", '" & drs("T_LAST_POST") & "', '" & drs("T_DATE") & "', '" & drs("T_LAST_POSTER")
strsqlvalues = strsqlvalues & "', '" & drs("T_IP") & "', " & drs("T_LAST_POST_AUTHOR") & ""


with this:

strsqlvalues = strsqlvalues & ", '" & drs("T_LAST_POST") & "', '" & drs("T_DATE") & "', " & drs("T_LAST_POSTER")
strsqlvalues = strsqlvalues & ", '" & drs("T_IP") & "', " & drs("T_LAST_POST_AUTHOR") & ""
Go to Top of Page

DanJP
Starting Member

USA
20 Posts
Posted - 08 June 2002 :  17:28:14  Show Profile  Visit DanJP's Homepage
That did it Thank You!

I'll leave you alone for a while now.
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts
Posted - 08 June 2002 :  17:37:36  Show Profile
You're welcome

fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.74 seconds. Powered By: Snitz Forums 2000 Version 3.4.07