Author |
Topic |
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 16:34:36
|
Everything function until now!!!
Nobody cant register, what is happening?
This:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The field 'FORUM_MEMBERS.MEMBER_RATING_TOTAL_COUNT' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/pf/register.asp, line 295
I installed user rating, but then I erased it...
Edited by - Um on 27 April 2002 16:37:17 |
|
Deleted
deleted
4116 Posts |
Posted - 27 April 2002 : 16:46:20
|
Uninstalling a mod does not only mean deleting the files installed by the mod. You also need to delete the fields and tables added by the mod.
BEFORE PLAYING WITH THE DATABASE, TAKE A BACKUP OF IT !!!!
a) If you have a "fresh" forum (no other MODs), just put the access file from the distribution onto your forum database
b) Otherwise, determine what fields/tables this particular MOD added to your database and delete them.
PS: Never try MODs etc on working/online systems. Just use a local test forum to play with them first.
Think Pink ==> Start Internationalization Here |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 16:49:55
|
Looks like you erased the code but left the database changes. If you know the fields added by the mod you can delete them from the database, but you'd better be sure about what you do.
Maybe you can post here for help on the DB changes made by the mod, so that you can undo them.
I know this may not do much now, but I'll say it nonetheless: if you just want to try a mod, maybe you should consider doing in a test forum or maybe keep an updated backup copy of the DB before installing the mod, so that you can undo the changes to the DB structure.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 16:51:15
|
Where do I have to look, please help me...
Where is this database, in admin options?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 16:51:17
|
Well, nice to see we are in sync, Bozden , although you were much faster than I did...
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 16:54:16
|
I also erased dbs_user_rating.asp, do I have to install this MOD again to see where he insert this table?
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 16:56:45
|
You don't know what the database is? I wouldn't recommended messing with it, then...
What are you using, Access?
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 16:59:01
|
yes, that what I was unziped with 3.3.03 Snitz forum..
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 17:01:19
|
quote:
I also erased dbs_user_rating.asp, do I have to install this MOD again to see where he insert this table?
That would help, yes. Can you understand the syntax. Maybe if you post the contents here we can help you determine what you need to change in your DB.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 17:05:58
|
Just a moment, I found double database on my server, one (original) is snitz_forums_2000.mdb (with exell icon, wright?) Other is snitz_forums_2000.Idb (and Icon is, you know that icon when you cant open with any program?)
Maybe is this? Do I have to erase that?
|
|
|
Deleted
deleted
4116 Posts |
|
Deleted
deleted
4116 Posts |
Posted - 27 April 2002 : 17:14:59
|
quote:
Just a moment, I found double database on my server, one (original) is snitz_forums_2000.mdb (with exell icon, wright?) Other is snitz_forums_2000.Idb (and Icon is, you know that icon when you cant open with any program?)
Maybe is this? Do I have to erase that?
No !!! The LDB file is the LOCK file for MDB file (keeps the log for the "users" connected to the database). snitz_forums_2000.mdb is your actual database file. If you have MS Access 2000 or 2002 installed on your local computer, download the database with FTP and open it with MS Access.
Think Pink ==> Start Internationalization Here |
|
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 17:17:55
|
I found it on Snitz exchange site, here : http://www.ls3k.com/snitz/mods.asp
I opened mu DB file and I found FORUM_RATINGS, is this the table?
And do i have to erase that doubled DB file?
Edited by - Um on 27 April 2002 17:18:30 |
|
|
Deleted
deleted
4116 Posts |
Posted - 27 April 2002 : 17:23:15
|
quote:
I found it on Snitz exchange site, here : http://www.ls3k.com/snitz/mods.asp
I opened mu DB file and I found FORUM_RATINGS, is this the table?
And do i have to erase that doubled DB file?
Edited by - Um on 27 April 2002 17:18:30
Let me check the file first to assist you...
Think Pink ==> Start Internationalization Here |
|
|
Deleted
deleted
4116 Posts |
|
Um
Junior Member
222 Posts |
Posted - 27 April 2002 : 17:33:09
|
member rating
|
|
|
Topic |
|