| Author |
 Topic  |
|
|
MJRyckman
Starting Member
7 Posts |
 Posted - 07 June 2002 : 11:12:26
|
I installed the Email Validation Mod by Davio on Snitz Forums v3.3.05
all of the modifidied pages seen to ope fine... with no visible errors, however, when I submit the 'new' user registration I get the following error...
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Number of query values and destination fields aren't the same.
/forums/register.asp, line 530
I opened the mdb file and the dbs_email_val.asp (I made no changes in either file!) the table Forum_Members_Pending is not being created.
any Ideas....
Thanks
Mike
- mjryckman |
|
|
MJRyckman
Starting Member
7 Posts |
Posted - 07 June 2002 : 13:25:35
|
Update....
in looking around on the Snitz Forum, I found this information (http://forum.snitz.com/forum/topic.asp?TOPIC_ID=28060)which enabled me to create the table. however I still have the odbc error. the line in the register.asp file is:
if strAUAnon = "1" then
strSql = strSql & ", '" & ChkString(Request.Form("AUHide"),"") & "'"
else
strSql = strSql & ", '1'"
end if
strSql = strSql & ")"
my_Conn.Execute (strSql) <---- line 530
'################### Email Validation Mod ###################
if lcase(strEmail) = "1" and strEmailVal = "1" then
'Do Nothing
else
'############################################################
thanks
Mike
- mjryckman |
 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 07 June 2002 : 16:20:25
|
It means you missed adding part of the Active Users mod code in your SQL query there. There are 2 parts you should add. The first part that tells the name of the database field, and the second part (the one you posted) that stores the value into that field.
Double check your code for the AU mod.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
MJRyckman
Starting Member
7 Posts |
Posted - 07 June 2002 : 16:50:18
|
Gottcha, working now thanks
- mjryckman |
|
|
| |
Topic |
|
Topic Locked
