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: MOD Implementation
 Custom Policy Problems
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Beaudoin
New Member

Canada
75 Posts

Posted - 01 February 2005 :  10:20:13  Show Profile  Visit Beaudoin's Homepage
I'm getting this error:

Microsoft OLE DB Provider for SQL Server error '80040e07'

Syntax error converting the varchar value '0, 0' to a column of data type int.

/Army/forum/forum/admin_policy.asp, line 62

Can anyone tell me how to fix this problem?

I'm using an SQLserver database.

Jason Beaudoin
Army Web Designer
Canadian Army


Edited by - Beaudoin on 01 February 2005 11:59:33

Beaudoin
New Member

Canada
75 Posts

Posted - 01 February 2005 :  14:03:08  Show Profile  Visit Beaudoin's Homepage
Nevermind everyone... I had to revert to our Access database.

Jason Beaudoin
Army Web Designer
Canadian Army

Go to Top of Page

hawkdrean
New Member

73 Posts

Posted - 29 March 2005 :  02:49:21  Show Profile  Visit hawkdrean's Homepage
I'm getting this error went I try to make a custom Policy

Microsoft JET Database Engine error '80040e07'

Data type mismatch in criteria expression.

/admin_policy.asp, line 62

This is what on line 62: my_conn.execute(strsql),,adCmdText + adExecuteNoRecords

Can anyone help me with this?

Thanks
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 29 March 2005 :  04:08:48  Show Profile
Hawkdrean,

That normally means that it can not find a table/field in your database. Did you run the dbs file via the admin area? You need to follow all the steps when installing mods.

Cheers,

David Greening
Go to Top of Page

hawkdrean
New Member

73 Posts

Posted - 29 March 2005 :  04:34:06  Show Profile  Visit hawkdrean's Homepage
Yes I ran the datebase file went I first installed the forum and all the tables/fields are showing up. I ever run Check Installation and I still get the error
Go to Top of Page

Classicmotorcycling
Development Team Leader

Australia
2084 Posts

Posted - 29 March 2005 :  04:48:56  Show Profile
Where abouts are you running this, as everytime I go to your homepage, I get: HTTP/1.1 New Session Failed

The admin_policy.asp file I have, at line 62, I have:
Response.Write  "      <p align=""center""><font face=""" & strDefaultFontFace & """ size=""" & strHeaderFontSize & """>Configuration Posted!</font></p>" & vbNewLine & _
So what changes have you made changes to the original admin_policy.asp file. Re-download it from OneWayMule's site and re-upload the admin_policy.asp as there seems to be something wrong with your copy. It is the best advice I could give you, to start with an un-edited version of the mod.

Cheers,

David Greening
Go to Top of Page

hawkdrean
New Member

73 Posts

Posted - 29 March 2005 :  05:15:23  Show Profile  Visit hawkdrean's Homepage
I went and download the Policy.asp from here http://www.snitzbitz.com/mods/details.asp?Version=All&mid=134
And ran the database file and then uploaded the Policy.asp to overwrite the one in my forum folder. Then I try again to make my own policy and it worked. I think the one I had was bad and it was causing the error.
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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07