| Author |
 Topic  |
|
|
bescher
Starting Member
USA
4 Posts |
 Posted - 04 December 2004 : 09:34:22
|
I am running forum 3.4.05 with MY SQL ver 4.1
with the newest version of ODBC on a windows 2003 server standard
running IIS 6.0.
No matter what I do meaning change databases, create new databases,
install another copy of Snitz's forums, rename and reinstall the database, rename the folder which snitz's is in, change permissions on the forum folder whatever I keep on getting the
Microsoft VBScript runtime error '800a000d'
Type mismatch
/forums/default.asp, line 923
The only difference is that the page and line number will change depending upon which page I go in the forum.
This is really getting to me
any suggestions
to see please go to
http://www.62ndmpco.org/forums/default.asp
Thanks
Bob Escher
|
|
|
bescher
Starting Member
USA
4 Posts |
Posted - 04 December 2004 : 13:47:18
|
Additional Information on this issue
I was running all of my forums (4 different ones under 4 different domains) was running fine under MYSQL version 3.?? and it all stopped
working after I upgraded to MYSQL 4.??
I also had to upgrade the ODBC driver as well to the current version.
Bob |
 |
|
|
bescher
Starting Member
USA
4 Posts |
Posted - 04 December 2004 : 13:55:21
|
It Looks like my problem was fixed
using the below that I found under MYSQL information
Thanks
I think I’ve discovered the solution to this problem. The quick answer:
Go to config.asp and edit the MySQL connection string. Change OPTION=4 to OPTION=16387.
For a detailed explanation, which should be of interest to the developers and moderators, read on. Sorry this is so long, but I wanted to be sure to explain myself thoroughly. Keep in mind that this worked for me, your mileage may vary.
I just installed Snitz Forums version 3.4.05. I’m using it with MySQL 4.1, and MyODBC 3.51, all on a Windows 2000 server, running IIS5. I followed the setup instructions and everything went fine. When I went to view the forum page for the first time, I got the following error in the statistics section:
Type mismatch
/snitz/default.asp, line 923
I looked at the code, and noticed that the error was occurring during a comparison of integer values. I added the ‘cint’ function, and it fixed the problem. But, I then encountered the error again, and again and again at other points in the code on other pages. I looked deeper and found that the variable that was causing the error in the first instance (default.asp, line 923), ‘Member_Count’, was derived from a SELECT COUNT statement. A little more research revealed this:
http://dev.mysql.com/doc/mysql/en/count-error.html
The COUNT aggregate function in MySQL returns a BIGINT value. ADO doesn’t like BIGINTs, which I knew, so it converts the data to a string, which ultimately resulted in the ‘Type Mismatch’ error. Once I realized this, I examined the connection string used in config.asp. Sure enough, the OPTION= value wasn’t set correctly (based on my past experience). It came shipped set at ‘4’. I changed it to 16387 and all the ‘type mismatch’ errors went away! The values for the OPTION command can be found here:
http://www.dwam.net/mysql/asp_myodbc.asp
You’ll notice that option 16384 says “Change LONGLONG columns to INT columns, as some applications can't handle LONGLONG or BIGINT.” Add option 16384 with options 1 and 2 from the same list, (1+2+16384 = 16387) and you’ve specified to MyODBC the exceptions that it needs to consider when ADO is the client. If you read the page above carefully, the author states that as of MyODBC 3.51 you can use OPTION=3. I’ve found this to NOT be true, and that OPTION=16387 is still necessary, and works in EVERY case. It may be true that MyODBC now supports BIGINT, but ADO still does not.
I think this may solve a lot of problems people were having with Snitz Forums when using it with MySQL.
Thanks for reading, and good luck to all!
|
|
|
| |
Topic |
|
|
|
Topic Locked
