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: Database: MySql
 help on new installation
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

xanderx
Starting Member

Italy
5 Posts

Posted - 21 January 2010 :  16:01:29  Show Profile  Visit xanderx's Homepage
Hi guys :)

I have installed a new snitz...

I m using mysql.

I receive the following error on me forum home page

Microsoft VBScript runtime error '800a000d'

Type mismatch

/forum/inc_header.asp, line 486

Can you help me ?

Thanks

xanderx
Starting Member

Italy
5 Posts

Posted - 21 January 2010 :  16:25:42  Show Profile  Visit xanderx's Homepage
i suppose something related to this code...
' DEM --> Start of code added to show subscriptions if they exist
if (strSubscription > 0) then
if mlev = 4 and SubCount > 0 then
Response.Write " |" & vbNewline & _
" <a href=""subscription_list.asp?MODE=all""" & dWStatus("See all current subscriptions") & " tabindex=""-1""><acronym title=""See all current subscriptions"">All Subscriptions</acronym></a>" & vbNewline
end if
if MySubCount > 0 then
Response.Write " |" & vbNewline & _
" <a href=""subscription_list.asp""" & dWStatus("See all of your subscriptions") & " tabindex=""-1""><acronym title=""See all of your subscriptions"">My Subscriptions</acronym></a>" & vbNewline
end if
end if
' DEM --> End of Code added to show subscriptions if they exist

Edited by - AnonJr on 21 January 2010 16:40:29
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 21 January 2010 :  16:42:43  Show Profile  Visit AnonJr's Homepage
Its probably got more to do with SubCount not being numeric.

I suspect the culprit is line 448:
strSql = "SELECT COUNT(*) AS SubCount FROM " & strTablePrefix & "SUBSCRIPTIONS"


Its being used on line 456, and for reasons I can't think of off the cuff the count isn't being returned properly:
SubCount = rsCount("SubCount")


I seem to recall MySQL always being a little funny about COUNTs...
Go to Top of Page

xanderx
Starting Member

Italy
5 Posts

Posted - 21 January 2010 :  16:50:40  Show Profile  Visit xanderx's Homepage
mmmmmm..... what db do you think is better for snitz ?
sqlserver ?
how is it possible that a forum like snitz have problems with a new installation ? do you think problem related to the provider ?
THX :)

Edited by - xanderx on 21 January 2010 16:52:06
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 21 January 2010 :  17:04:14  Show Profile  Visit HuwR's Homepage
maybe if you could tell us more about your setup we can work out why it isn't working. Snitz does not normally have problems on a new install unless it is not setup correctly or there are server issues. many many users have it installed and working on mysql without any problems.

what version of MySQL is your db ?
what connection string are you using ?
have you set the correct dbtype in config.asp ?
Go to Top of Page

xanderx
Starting Member

Italy
5 Posts

Posted - 21 January 2010 :  17:12:19  Show Profile  Visit xanderx's Homepage
here the requested data:

MySQL Server: XXXXXXXXX via TCP/IP
Versione MySQL: 5.0.82sp1-log
Set di caratteri MySQL: UTF-8 Unicode (utf8)

Motore di Memorizzazione Descrizione
MyISAM Default engine as of MySQL 3.23 with great performance
MEMORY Hash based, stored in memory, useful for temporary tables
InnoDB Supports transactions, row-level locking, and foreign keys
BerkeleyDB Supports transactions and page-level locking
BLACKHOLE /dev/null storage engine (anything you write to it disappears)
EXAMPLE Example storage engine
ARCHIVE Archive storage engine
CSV CSV storage engine
ndbcluster Clustered, fault-tolerant, memory-based tables
FEDERATED Federated MySQL storage engine
MRG_MYISAM Collection of identical MyISAM tables
ISAM Obsolete storage engine


Provider: aruba.it

config.asp:

strDBType = "mysql"
strConnString = "driver=MySQL;server=XXXX;uid=XXXXXX;pwd=XXXXXX;database=XXXXXX" '## MySQL w/ MyODBC v2.50


I have setuped from zero using an empty db and the software downloaded from here :)

thanks
Go to Top of Page

xanderx
Starting Member

Italy
5 Posts

Posted - 21 January 2010 :  17:20:51  Show Profile  Visit xanderx's Homepage
i receive the same error everywhere :(

Microsoft VBScript runtime error '800a000d'

Type mismatch

/forum/default.asp, line 926



Microsoft VBScript runtime error '800a000d'

Type mismatch

/forum/forum.asp, line 297
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 21 January 2010 :  17:55:49  Show Profile
You're using the older connection string.
Use the connection string marked with "'## MySQL w/ MyODBC v3.51".
It should be the one above the existing connection you are using.

Support Snitz Forums
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 23 January 2010 :  09:48:40  Show Profile  Send ruirib a Yahoo! Message
Have you read this: http://forum.snitz.com/forum/topic.asp?TOPIC_ID=55925.

We do have a lot of useful posts, in the proper forums.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.11 seconds. Powered By: Snitz Forums 2000 Version 3.4.07