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
 Messege Icon Mod		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

texanman
Junior Member

United States
410 Posts
Posted - 06 February 2009 :  12:13:20  Show Profile
Implementing this mod. Everything seems to be fine except the changes in active.asp. It is pointing to a syntax error in this line:

rs.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText

What could cause this? Thanks<

Podge
Support Moderator

Ireland
3775 Posts
Posted - 06 February 2009 :  12:19:32  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Can you post a txt version of your active.asp ?

The exact error would also be helpful. Can you copy the text of it here? or provide a link to your forum ?<
Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 06 February 2009 :  12:28:28  Show Profile
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near '.'.
/active.asp, line 328

Here<
Edited by - texanman on 06 February 2009 15:43:19
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 06 February 2009 :  12:56:27  Show Profile
Line 278 is missing a comma after "message".<
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 06 February 2009 :  13:05:26  Show Profile
quote:
Originally posted by Carefree

Line 278 is missing a comma after "message".

Thanks that did it. <
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 09 February 2009 :  11:18:39  Show Profile
I encountered another error in this Mod.

Microsoft OLE DB Provider for SQL Server error '80040e14'
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
/post_info.asp, line 1584

Here<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 09 February 2009 :  13:49:36  Show Profile
Between lines 1558 and 1559 

      strSql = strSql & ", R_MESSAGE"
      strSql = strSql & ") VALUES ("

Insert the following line:

      strSql = strSql & ", R_MSGICON"
<
Edited by - Carefree on 09 February 2009 13:51:07
Go to Top of Page

texanman
Junior Member

United States
410 Posts
Posted - 09 February 2009 :  14:12:42  Show Profile
Geniussssssssssssssssssssssssss
Thanksssssssss Carefree :-))
Very much appreciated.<
Go to Top of Page

Carefree
Advanced Member

Philippines
4207 Posts
Posted - 09 February 2009 :  14:50:41  Show Profile
That's why we come here.<
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.45 seconds. Powered By: Snitz Forums 2000 Version 3.4.07