| Author |
 Topic  |
|
Bjarke
Starting Member
Denmark
34 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
 Posted - 24 July 2002 : 09:59:57
|
quote:
I am trying to install the email val mod the international version of snitz and get a server error everytime i try to register, is there anyone that can help me???
First, your return to Snitz link states that you're still using Snitz version 3.1SR4
Second, I tried to register as user test (delete it, please) but I could not figure out what the error message was. Can you please let me know what is it?
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
Bjarke
Starting Member
Denmark
34 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 10:58:16
|
That's a syntax error in register.asp that's causing the problem. However I cannot download your register.txt file, because the links to your files are not specified correctly. Go to your first post and specify the complete URL to your files. Make sure you test them and ensure they are working as expected.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 24 July 2002 : 11:04:23
|
****, im not thinking straight today 
The links have been corrected
Bjarke Sørensen
nospam@virringby.dk |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 11:20:39
|
In line 593, register.asp, remove the <%:
<% if strAuthType="db" then
response.write fLang(strLangRegister00310)
else
response.write fLang(strLangRegister00300)
end if %>.</font></p>
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 24 July 2002 : 11:27:38
|
It now gives another error when you have completede the registration, and clicks save (gem)
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'M_AVATAR_URL'. Make sure you have typed the name correctly, and try the operation again.
/forum/register.asp, line 505
This is the error
Regards
Bjarke Sørensen
nospam@virringby.dk
Edited by - Bjarke on 24 July 2002 11:38:50 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 July 2002 : 11:40:18
|
This is the error,
Microsoft JET Database Engine error '80040e14'
The INSERT INTO statement contains the following unknown field name: 'M_AVATAR_URL'. Make sure you have typed the name correctly, and try the operation again.
/forum/register.asp, line 505
I think this is because you need to add this field to the pending members table. I don't know this mod, so I'm just saying this based on the knowledge gained from seeing the posts here. Probably you need to verify the characteristics of that field in the forum members table and create a similar one in the pending members table.
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 24 July 2002 : 11:57:29
|
I have solved som of the problems, seems to be som mistakes i have made when i intergratede the email val with the avantar mod, will try to fix it as soon as i have finisehed my dinner
Thank you wery much for helping
Regards
Bjarke Sørensen
nospam@virringby.dk |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 24 July 2002 : 14:02:41
|
To install the M_AVATAR_URL field to the the MEMBERS_PENDING table, open up your dbs file that came with the avatar mod, change MEMBERS to MEMBERS_PENDING in the file, save it. Then run the mod setup file for the avatar mod again and it will install it in the MEMBERS_PENDING table.
«------------------------------------------------------»
What new features are going to be in the 3.4
version? See the 3.4 UnOfficial Features List ! |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 24 July 2002 : 18:09:51
|
Thank you Davio, that was probably one of the problems that i wouldt not have figured out for my self
Still having a little problems with it, but i think it is getting better, have fixed a lot of the problems my self, and also learned a lot.
Regards
Bjarke Sørensen
nospam@virringby.dk |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 27 July 2002 : 09:56:35
|
When i click on the activation link in the mail i now get the following error, anyone that can help???
Microsoft JET Database Engine error '80040e14'
Number of query values and destination fields are not the same.
/forum/register.asp, line 193
The register fil is updated and working at the above link as a txt fil, if you need to look at it.
Regards
Bjarke Sørensen
nospam@virringby.dk |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 27 July 2002 : 10:17:16
|
I think it is beacuse you have added the M_AVATAR bit here, line 141 to 146
strsql = strsql & ", M_PHOTO_URL"
strsql = strsql & ", M_AVATAR_URL"
strsql = strsql & ", M_LINK1"
strSql = strSql & ", M_LINK2"
strSql = strsql & ", M_AGE"
But dont seem to have added a value here
strsql = strsql & ", '" & ChkString(rsKey("M_PHOTO_URL"),"") & "'"
value here
strsql = strsql & ", '" & ChkString(rsKey("M_LINK1"),"") & "'"
strSql = strSql & ", '" & ChkString(rsKey("M_LINK2"),"") & "'"
strSql = strsql & ", '" & ChkString(rsKey("M_AGE"),"") & "'"
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk ™ |
|
|
|
Bjarke
Starting Member
Denmark
34 Posts |
Posted - 27 July 2002 : 12:30:11
|
In the installe notes for the avantar mod there is no addition on that line, but i tryed to insert the folowing:
strsql = strsql & ", '" & ChkString(rsKey("M_PHOTO_URL"),"") & "'"
strsql = strsql & ", '" & ChkString(rsKey("M_AVATAR_URL"),"") & "'"
strsql = strsql & ", '" & ChkString(rsKey("M_LINK1"),"") & "'"
and now i get this error:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/register.asp, line 181
Regards
Bjarke Sørensen
nospam@virringby.dk |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 27 July 2002 : 13:18:40
|
Ok, there is a block of code around line 76-84
'###Forum_SQL
strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_DATE, M_COUNTRY, " & _
"M_AIM, M_ICQ, M_YAHOO, M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_LAST_IP, M_IP, " & _
"M_SIG, M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_AVATAR_URL, M_LINK1, M_LINK2, M_AGE, " & _
"M_MARSTATUS, M_SEX, M_OCCUPATION, M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE " & _
" FROM " & strMemberTablePrefix & "MEMBERS_PENDING " & _
" WHERE M_KEY = '" & key & "'"
set rsKey = my_Conn.Execute (strSql)
Try adding the part in red, that should get rid of the error you are having...
No matter how fast light travels it finds the darkness has always got there first, and is waiting for it.
http://www.ian-hamlin.co.uk ™
Edited by - Hamlin on 27 July 2002 13:19:46 |
|
|
|
Topic |
|
Topic Locked
