| Author |
 Topic  |
|
|
Razta
Starting Member
USA
6 Posts |
 Posted - 14 May 2002 : 14:20:12
|
I have 3.3.03 version of Snitz.
I keep getting the error
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.
/forums/register.asp, line 241
Is Forum_members_pending suppose to be a table in the access database?
Any clue on where to start for this?
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 14 May 2002 : 14:34:10
|
quote:
Is Forum_members_pending suppose to be a table in the access database?
Yes.
Did you not install the database fields for the mod?
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
 |
|
|
Razta
Starting Member
USA
6 Posts |
Posted - 14 May 2002 : 23:04:48
|
I ran the mod installer, yes.
Im thinking its failing to update the database.
Can anyone send thier database that is unpopulated?
Or how to add the fields myself?
Edited by - razta on 15 May 2002 00:18:58 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 May 2002 : 00:47:40
|
I am not sure why it fails to do that. Other users have had the same problem with other mods as well. They run the database update, it says everything went ok, but the forum says the table is missing. If you run the database update again it says the table is already there.
What I would like you to do is, download this mod from this topic: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=17934
Then I would like you to send me a username and password of an admin account. I will see what I can do to fix it for you.
Also, if you are using the Access 97 connection string, use the Access 2000 one instead.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Razta
Starting Member
USA
6 Posts |
Posted - 15 May 2002 : 01:16:34
|
Thanks for the reply, im using the access 97 string.
I switched to access 2000 string and it didnt change.
Edited by - razta on 15 May 2002 02:06:21 |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 May 2002 : 02:14:07
|
quote:
I switched to access 2000 string and it didnt change.
It wasn't supposed to fix your problem. I am going tp fix it. Have you emailed me a username and password of an admin account to your forum yet? Remember to give me the url to your forum.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 May 2002 : 02:21:52
|
Ok i got your email.
When i try to go to your admin_mod_dbsetup2.asp file it says it cannot find it. Are you sure you uploaded it? You didn't rename it or anything? Try uploading it again to your forum folder.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Razta
Starting Member
USA
6 Posts |
Posted - 15 May 2002 : 02:24:03
|
Sorry,
i have a directory call forums and forum....uploaded to the wrong one.
Sorry to waste your time.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 May 2002 : 02:27:49
|
I'm done. Your forum should be working now.
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Razta
Starting Member
USA
6 Posts |
Posted - 15 May 2002 : 11:27:56
|
Cool thanks. Now, can you tell me what you did so I can reproduce this forum on another site?
Thanks,
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 15 May 2002 : 23:06:54
|
I removed the MEMBERS_TABLE with this code:[DROP]
MEMBERS_PENDING
[END] And I then re-installed it with this code:[CREATE]
MEMBERS_PENDING
MEMBER_ID
M_STATUS#smallint#NULL#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#1
M_LEVEL#smallint#NULL#1
M_AIM#varchar(150)#NULL#
M_ICQ#varchar(150)#NULL#
M_YAHOO#varchar(150)#NULL#
M_POSTS#int#NULL#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#0
M_HIDE_EMAIL#smallint#NULL#0
M_RECEIVE_EMAIL#smallint#NULL#0
M_LAST_IP#varchar(50)#NULL#'000.000.000.000'
M_IP#varchar(50)#NULL#'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#
[END]
«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists ! |
|
|
|
Razta
Starting Member
USA
6 Posts |
Posted - 17 May 2002 : 00:32:58
|
Oh ok....
I tryed the second set of code, but didnt remove that table first.
Thanks,
|
|
|
| |
Topic |
|
Topic Locked
