| Author |
 Topic  |
|
Daut
Starting Member
Yugoslavia
5 Posts |
 Posted - 07 March 2003 : 01:23:17
|
Hi!
Yesterday, I installed Active Users 4.0 in my forum, but...today, new members can't register.
This is error:
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/register.asp, line 576
Line 576 is:
--------------------------------------------------------------------------------
if strQuote = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'"
else
strSql = strSql & ", ''"
end if
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ", 1"
strSql = strSql & ")"
my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords
if strEmail = "1" and strEmailVal = "1" then
'Do Nothing
else
Call DoCount
end if
regHomepage = ""
--------------------------------------------------------------------------------
Help me, please? |
D. |
Edited by - Daut on 07 March 2003 01:55:04 |
 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 07 March 2003 : 16:18:36
|
I would guess that you missed adding some code into register.asp or possibly added it in the wrong place.
Could you provide a link to a text-version of your register.asp? |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Daut
Starting Member
Yugoslavia
5 Posts |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 08 March 2003 : 06:20:21
|
I've checked your register.asp and I found that you had missed to one line of code which should have been entered twice.
Look for the following on line 434 in your register.asp.
strSql = strSql & ", M_QUOTE"
Add strSql = strSql & ", M_AUHIDE" directly beneath it, and it should work for you again. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Daut
Starting Member
Yugoslavia
5 Posts |
Posted - 08 March 2003 : 12:28:59
|
quote:
Originally posted by masterao
I've checked your register.asp and I found that you had missed to one line of code which should have been entered twice.
Look for the following on line 434 in your register.asp.
strSql = strSql & ", M_QUOTE"
Add strSql = strSql & ", M_AUHIDE" directly beneath it, and it should work for you again.
Yes! That's it!
I didn't see "Find BOTH instances of this: (about line 141 & 436)" in my instactions!
Now, is working!
Thanks masterao! :) |
D. |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
Bendro
Starting Member
Sweden
7 Posts |
Posted - 13 March 2003 : 18:38:58
|
Looked through this thread and I am sorry if I have missed it...but was this ever solved?
I have exactly the same problem...!
quote:
Originally posted by philgsy
Can onyone help me out here.
I'm kinda new to all of this stuff, and am trying to implement this mod onto my forum.
When anyone goes to default.asp, the following error comes up at the end of the page.
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[undefined]'
inc_activeusers.asp, line 141
The forum does not show number of users/posts, or who new members are etc...
Also if I go to Admin Options, i am getting the following error message:
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[undefined]'
/forum/admin_home.asp, line 131
Admin_hope.asp will only show Main Forum COnfig, and Feature Config, and then stops with this message. I have lost all other admin functions.
It's probably a really dubm question, but I cant seem to figure out where I've gone wrong. I followed the readme file, and have re-checked, and cannot find anything wrong.
Can anyone help me please.
Thank you guys!
|
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 March 2003 : 08:42:44
|
| Make sure that you added the AU code into inc_func_common.asp and in config.asp, and that you uploaded all the new files for AU. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
ROB
Junior Member
USA
347 Posts |
Posted - 16 March 2003 : 18:01:37
|
I'm still getting the error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Line 1: Incorrect syntax near ','.
/forums/active_users.asp, line 411
I quickly checked the database and discovered what I think is causing the problem. One of the records contained the value TOPIC_ID=204, (with the comma) in the AU_QUERYSTRING column. Does this seem like it would cause the problem? Any ideas why it's getting in there?
|
Jeff (ROB) Hester
BigBlueNetwork | BigBlueBall | Christian Church Today |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 March 2003 : 19:55:32
|
That could be the reason, Rob. The comma could be there because someone wrote the url in a post and instead for encasing it with the #91;url#93;#91;/url#93;-tag, they typed the url and put a , directly after it, or they typed the url directly and included a , in it.
Open active_users.asp, in the function WhatPage(fScript, fQuery). Look for the following:
case "topic.asp"
strQuery = fQuery
fTopic_ID = analyzeQuery(strQuery, "TOPIC_ID")
Add the following directly below that:
fTopic_ID = Replace(fTopic_ID,",","")
Now, this is a quick-fix, and I have only tested this on an access database where I was able to create the error and remove it.
You would need to to the same for forum.asp in the same function, making it look like:
case "/forum/forum.asp"
strQuery = fQuery
fForum_ID = analyzeQuery(strQuery, "FORUM_ID")
fForum_ID = Replace(fForum_ID,",","")
There is probably a better way to solve this, but I don't have the time to look deeper into it know. Let me know if it works or not.  |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
phikap
New Member
USA
92 Posts |
Posted - 21 March 2003 : 20:00:00
|
hey. i get this.
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_ACTIVE_USERS'.
/forum/inc_func_common.asp, line 150
someone explained ot me that i need to make a table for active users. how the heck do i do this? i am very frustrated. So i used to have the run of the mill forum and now im trying to install server hackers mod version because i know im dumb and would screw up manually installing all of the mods manually.
thanks |
mario
college humor at
humpingchickens.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 21 March 2003 : 21:52:52
|
Quoting from the readme-file in the AU-zip:
quote:
AFTER you have uploaded all the files from your 34 directory and BEFORE you make any changes to existing files, you need to update the database.
Log in as the original admin account. That is the one created during installation (of the forum).
Navigate you to your administration panel. http://your-forum/admin_home.asp
Second from the bottom in the "Other Configuration Options and Features" column is the MOD Setup panel, open that.
NOTE: If this page does not load correctly then you can use the "(Alternative Mod Setup)" link, which is directly following the Mod Setup link
There should be a select form object in the center of the file. Select "Active Users 4.0.1 for Snitz 3.4 compatable"
Make sure the checkbox is checked.
Click Update!
From your browser run the audbsetup.asp file. http://your-forum/audbsetup.asp When is says "Update Complete" then proceed onto modifying files.
|
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
phikap
New Member
USA
92 Posts |
Posted - 21 March 2003 : 23:52:45
|
look im having all these issues with active users. so i just want to get rid of it. it came installed on server hackers mod forum but i dont want it. Its creating a headache. How can i get rid of it
this is what im getting
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_ACTIVE_USERS'.
/forum/inc_func_common.asp, line 150
i know i have to make a table. however i have not been told how. everyone keeps saying look at the instructions. there are no instructions. i tried to download the latest version of active users. and i have to be able to access the forum (which i cant do) to update the database. any help is appreciated
if you can help me fix it good.
if you can help me get rid of it just as good
thank you
very frustrated |
mario
college humor at
humpingchickens.com |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 22 March 2003 : 08:52:51
|
| Im not familiar with SH version of the forum, so I cannot help you with removing AU from it. You will probably get a direct answer if you asked this at his forum instead. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
scds2003
Starting Member
United Kingdom
34 Posts |
|
|
Topic |
|
Topic Locked
