| Author |
 Topic  |
|
|
mark d
Starting Member
Australia
18 Posts |
 Posted - 01 April 2002 : 04:07:18
|
Hi Guys
Just installed the Email Validation mod and having the same problem mentioned in post:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=23759
ie: Mod setup says "table already exsists", but then when trying to register I get:
"Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_MEMBERS_PENDING'. Make sure it exists and that its name is spelled correctly.
/forum/register.asp, line 241"
I see in the post mentioned above that the solution is to check the database and manually edit, but unfortunately I don't have 'Access', so am unable to check or edit.
Database is:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=e:\InetPub\mydirectory\cgi-bin\forums\snitz_forums_2000.mdb" '## MS Access 97
Just wondering if anyone can help me out?
Thanks
mark d
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 01 April 2002 : 18:47:12
|
Try using the Access 2000 connection string instead. If this is your server you can try updating your access drivers: http://www.microsoft.com/data/
«------------------------------------------------------»
Read the Do's and Don'ts before you post for help |
 |
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 01 April 2002 : 20:26:33
|
Thanks Davio. Worked like a charm!
Is there a way of extending the delay from the 'Your Registration Is Almost Complete' page to the default page?
A lot of the people that will be using the forum are elderly and might not get the chance to read the "Please follow the instructions in the email that has been sent" message before the page refreshes.
Is the delay time set here?:
'############## Email Validation Mod - Changed 2 to 5 in next line ############# %>
<meta http-equiv="Refresh" content="5; URL=<% =Request.Form("refer")%>">
Thanks again
mark d |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
Posted - 01 April 2002 : 20:47:58
|
Yes (in seconds).
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Edited by - OneWayMule on 01 April 2002 20:51:22 |
|
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 01 April 2002 : 22:04:26
|
Thanks OneWayMule.
mark d |
|
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 02 April 2002 : 00:53:25
|
Email Validation is working fine now, but I have discovered a problem.
I previously installed the 'Hide Email' mod and it was functioning properly. But now it's not.
Now, if a member has chosen to hide email at registration, instead of showing the 'Hidden by Member' text, it shows the 'Click to Send member an E-Mail' text. Changing it in the Profile doesn't work either.
I have tried to compare all files used by both mods to spot something, but am unable to see what I've done wrong.
If anything needs to be changed in one of the files to make them compatible, would anyone know what that is?... or if there isn't any adjustments needed and I have done something wrong when putting the validation code in (most likely scenerio!), I can supply the txt files if anyone is interested in having a look.
Thanks
mark d |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 April 2002 : 03:10:38
|
I hope you didn't overwrote your files with the email validation mod files and you copy and pasted the code instead into your files. Otherwise, you would need to add the code for the hide email mod back into your files.
If the hide email mod uses a database field in the MEMBERS table, then you would also need to add that field to the MEMBERS_PENDING table. Just open the dbs file for the hide email mod and change the MEMBERS table name to MEMBERS_PENDING and run the file from the MOD Setup in your admin options.
«------------------------------------------------------»
Read the Do's and Don'ts before you post for help |
|
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 02 April 2002 : 04:45:38
|
Thanks for your reply Davio.
All files that have been modified were done so using C + P and saved as new files, with backups kept. When copying the email validation code into the files that had been modded with hide email code, I kept note of whether your code would be clashing with any of the hide email code, and didn't see that occurring anywhere. As I said, I could be wrong and maybe I did stuff up the hide email code somewhere, but I have gone back over your files and Richard's and compared them with my modified (for both mods) files and am unable to spot anything.
I don't know if the hide email mod uses a database field in the MEMBERS table, because unfortunately I don't have 'MS Access', so I am unable to check or edit any database files. The hide email mod didn't come with a dbs file.
Thanks
mark d |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 April 2002 : 14:38:08
|
Ok. Post a link to a text version of your register.asp and pop_profile.asp files.
«------------------------------------------------------»
Read the Do's and Don'ts before you post for help |
|
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 02 April 2002 : 19:22:49
|
Thanks for your help Davio.
The page with text file links is HERE (link deleted by author)
I also included inc_profile, as that is the other file that is shared by both mods (just in case).
mark d
Edited by - mark d on 03 April 2002 11:47:00 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 April 2002 : 03:15:13
|
Your files are ok.
One problem I see that might cause this is, the M_HIDE_EMAIL database field is not in the MEMBERS_PENDING table. So when users choose yes or no to hide thier emails at registration, thier option is not saved in the database. When they approve thier email, no value is transfered from the MEMBERS_PENDING table to the MEMBERS table for the M_HIDE_EMAIL field. So it is left empty.
Editing thier profile after validation should update the field with the new data. Don't see why it shouldn't.
But to add the field to the MEMBERS_PENDING table, create a new text file, save it something like dbs_hide_email.asp. Enter the following into the text file:
Update Email Validation Table
[ALTER]
MEMBERS_PENDING
ADD#M_HIDE_EMAIL#smallint#NULL#0
[END]
Upload it your forum folder. Then go to your MOD Setup in your admin options and select "Update Email Validation table" and run it.
Now you will need to add the field to the register.asp file. Line 77 in your file, add the code in red:strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_HIDE_EMAIL, M_DATE, M_COUNTRY, " & _ After line 125, add the code in red:strSql = strSql & ", M_EMAIL"
strSql = strSql & ", M_HIDE_EMAIL"
strSql = strSql & ", M_DATE" After line 162, add the code in red:strSql = strSql & ", '" & ChkString(rsKey("M_EMAIL"),"SQLString") & "'"
strSql = strSql & ", '" & ChkString(rsKey("M_HIDE_EMAIL"),"SQLString") & "'"
strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'"That should be it.
«------------------------------------------------------»
Read the Do's and Don'ts before you post for help |
|
|
|
mark d
Starting Member
Australia
18 Posts |
Posted - 03 April 2002 : 11:54:57
|
Thanks Davio, everything seems to be working fine.
I really appreciate the time and effort you have spent helping me.
Now it's on to the next MOD, the Events Calendar.
I can almost hear you saying "Phew, thank god that's not one of mine!"
Thanks again
mark d |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 April 2002 : 02:01:54
|
quote:
I can almost hear you saying "Phew, thank god that's not one of mine!"
LoL 
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
| |
Topic |
|
Topic Locked
