| Author |
 Topic  |
|
|
ChrisM
Starting Member
4 Posts |
 Posted - 24 November 2004 : 17:19:22
|
Hi,
I've tried searching for this, and I'm sure it must be there somewhere, but I can't find anything!
I'm upgrading from Windows 2000 Server to Windows 2003 Server, both running MySql (the 2003 server has the latest MySql stable release)
When I've installed Snitz and imported the database into mysql, i get the following error in the statistics section at the bottom:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/Default.asp, line 923
If I click to open a forum I get:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forum.asp, line 296
For the first one, I've played about a bit and discovered that if I change line 923 from:
if Member_Count = 1 and User_Count = 1 then
to:
if CInt(Member_Count) = 1 and CInt(User_Count) = 1 then
it solves that problem, but i then get:
Microsoft VBScript runtime error '800a000d'
Type mismatch
/Default.asp, line 973
I assume this is something to do with IIS6 - any help would be gratefully received!
Cheers
Chris |
|
|
ChrisM
Starting Member
4 Posts |
Posted - 24 November 2004 : 17:27:41
|
| Sorry - missed some info which would probably help - I'm running the current version of snitz, and everything appears correctly on the front page of the forum except for the stats at the bottom. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
ChrisM
Starting Member
4 Posts |
Posted - 24 November 2004 : 17:52:44
|
quote:
Originally posted by ruirib
Yeah, that is a known problem and it seems to result from the fact that you're using the latest MySQL version. Looks like the drivers used do not fully support the latest version of MySQL.
What can you do? You can apply fixes similar to those shown here: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55525
Alternatively, you can remove your current MySQL installation and install an older version.
Thanks for that - I have to admit I'm completely confused - it is returning the data so I'm not sure its the driver - especially given the CInt() function sorts it out. Unless its returning numerics as strings i guess.
Either way - I'm glad to know it's not just me - thanks muchly.
Chris |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 November 2004 : 17:58:15
|
Well I'm not very knowledgeable about MySQL, but another moderator who is suggested that as a possibility. It's clear to me that methods that were returning correct values with previous MySQL versions do not return them with this one. I'm inclined to the possibility that you just suggested, that strings are being returned instead of numbers, because I printed the strings using Response.Write and a "correct" value was shown.
This is annoying, because it happens in a big number of Snitz files, so it is rather boring to have to add the change to those files... and it's quite likely the issue will be fixed in a new release of MyODBC. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
ChrisM
Starting Member
4 Posts |
Posted - 24 November 2004 : 18:07:11
|
Yeah - I've just run some test and I think your theory holds more water.
It appears to be related to the SELECT COUNT X AS Y queries, which (i think) would be driver related as these would be returning values which are dynamically generated and therefore won't have any type declaration other than count should return an integer.
Or I might be barking up the wrong tree. Either way I think I'll revert to an earlier mySQL release as I'm not too keen on that number of changes!
Cheers again! |
|
|
| |
Topic |
|
Topic Locked
