| Author |
 Topic  |
|
spottedgalway
Junior Member
Canada
181 Posts |
 Posted - 24 April 2002 : 22:56:41
|
Hi guys:
I'm having trouble now implementing the Email Validation Mod.
I have reinstalled all the files, and have made the appropriate changes.
When a user clicks in agreement to register this is the error:
Microsoft VBScript compilation error '800a0400'
Expected statement
/register.asp, line 577
<% end if
^
When I tried to setup the MOD, it installed and I got this message:
Snitz Forum Modifications
Email Validation Mod Adding Column M_KEY... Column added successfully Adding Column M_NEWEMAIL... Column added successfully Adding new records.. INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STREMAILVAL','0') -2147467259 | The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again. Creating table(s)... CREATE TABLE FORUM_MEMBERS_PENDING( MEMBER_ID int IDENTITY (1, 1) NOT NULL , M_STATUS smallint NULL DEFAULT 0, M_NAME varchar(75) NULL , M_USERNAME varchar(150) NULL , M_PASSWORD varchar(25) NULL , M_EMAIL varchar(50) NULL , M_COUNTRY varchar(50) NULL , M_HOMEPAGE varchar(50) NULL , M_SIG varchar(255) NULL , M_DEFAULT_VIEW int NULL DEFAULT 1, M_LEVEL smallint NULL DEFAULT 1, M_AIM varchar(150) NULL , M_ICQ varchar(150) NULL , M_YAHOO varchar(150) NULL , M_POSTS int NULL DEFAULT 0, M_DATE varchar(50) NULL , M_LASTHEREDATE varchar(50) NULL , M_LASTPOSTDATE varchar(50) NULL , M_TITLE varchar(50) NULL , M_SUBSCRIPTION smallint NULL DEFAULT 0, M_HIDE_EMAIL smallint NULL DEFAULT 0, M_RECEIVE_EMAIL smallint NULL DEFAULT 0, M_LAST_IP varchar(50) NULL DEFAULT '000.000.000.000', M_IP varchar(50) NULL DEFAULT '000.000.000.000', M_FIRSTNAME varchar(100) NULL , M_LASTNAME varchar(100) NULL , M_OCCUPATION varchar(255) NULL , M_SEX varchar(50) NULL , M_AGE varchar(10) NULL , M_HOBBIES memo NULL , M_LNEWS memo NULL , M_QUOTE memo NULL , M_BIO memo NULL , M_MARSTATUS varchar(100) NULL , M_LINK1 varchar(255) NULL , M_LINK2 varchar(255) NULL , M_CITY varchar(100) NULL , M_STATE varchar(100) NULL , M_PHOTO_URL varchar(255) NULL , M_KEY varchar(16) NULL , M_NEWEMAIL varchar(50) NULL ) Table created succesfully Unable to remove dbs file
Permission denied If there were errors please post a question in the MOD Implementation Forum at Snitz Forums <http://forum.snitz.com/forum/forum.asp?FORUM_ID=94&CAT_ID=10> Top of Form 1 Bottom of Form 1
Your help is super appreciated!
Thanks,
Dave
Edited by - Davio on 25 April 2002 00:02:54 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 April 2002 : 23:59:08
|
quote:
Microsoft VBScript compilation error '800a0400'
Expected statement
/register.asp, line 577
<% end if
^
Post a link to a txt version of your register.asp file.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
 |
|
|
spottedgalway
Junior Member
Canada
181 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 25 April 2002 : 07:46:40
|
On line 577 remove the code in red:<% end if %>
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 25 April 2002 : 09:04:51
|
Thanks man. I've made the changes and now have:
Microsoft VBScript compilation error '800a03f8'
Expected 'Sub'
/inc_profile.asp, line 194
end if 'extended profile
----^
Here's a link to the inc_profile.asp
http://spottted.brinkster.net/inc_profile.doc
Thanks again for your help.
Dave
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 April 2002 : 01:27:20
|
quote:
Here's a link to the inc_profile.asp
http://spottted.brinkster.net/inc_profile.doc
That's a doc file. It needs to be a .txt file.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 26 April 2002 : 10:17:43
|
You have more problems with just these errors with your file. But on line 89, remove the code in red:<% end if
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 26 April 2002 : 11:07:46
|
Ok moving right along...
I made the changes.
And now see this when I hit REGISTER:
http://spottted.brinkster.net/error.bmp
Aghhh!!
I don't understand what went so wrong???
Dave
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 27 April 2002 : 00:09:32
|
I don't see anything in that image.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 27 April 2002 : 09:14:22
|
That's strange it works for me.
Well it doesn't go into a white page now, the error is in the site.
ALL FIELDS MARKED WITH * ARE REQUIRED
(then the box reads: "<font face=
(below the box:
Microsoft VBScript runtime
error '800a000d'
Type mismatch: 'rs'
/inc_profile.asp, line 76
Any ideas?
Thanks,
Dave
PS:
Is there a time we could do a live chat and work on this?
I've really got to get it back up and running badly!
Thanks again.
|
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 28 April 2002 : 15:36:24
|
Davio where are ya man?
Please help.
Thanks
Dave
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 29 April 2002 : 01:20:25
|
You're on Brinkster. Why didn't you use the Brinkster files when you setup your forum?
Uncomment the on error resume next code at the top of inc_profile.asp, then at the very bottom of it put on error goto 0.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 29 April 2002 : 08:35:18
|
Okay.
Let's pretend none of this has happened. 
You say I should use the Brinkster files. Which brinkster files?
Thanks,
Dave
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 29 April 2002 : 13:30:06
|
Brinkster requires that if you use the on error resume next statement you must have the on error goto 0 statement also. And that the Server.ScriptTimeout must not be higher than 90 in any of the files.
So I made those changes in the Snitz Files and offered it for download for users using Brinkster. It's at the Snitz Exchange: http://www.ls3k.com/snitz/mods.asp
Now you can't overwrite your files since you have already started adding mods. But I don't understand how you reach this far in adding mods, and you haven't used the Brinkster files yet.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
spottedgalway
Junior Member
Canada
181 Posts |
Posted - 29 April 2002 : 14:16:07
|
When I am comparing the two files (the current one) and the MOD one, and I'm making the changes....
Let's say the MOD file is on the left and the old one is on the right.
I realize that I am adding any new (red) stuff on the left to the right.
But what if there's red stuff on both sides? DO I overwrite the previous stuff on the right?
Thanks,
Dave
|
|
|
|
Topic |
|
Topic Locked
