| Author |
 Topic  |
|
|
stotes
Starting Member
8 Posts |
 Posted - 23 October 2008 : 11:42:39
|
I recently tried to install the usergroups MOD v1.0 Beta Version 2 and ran into a few problems once all the code was modified. When logging in as an admin the Usergroups Manager appears but I get the following 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_USERGROUPS'. Make sure it exists and that its name is spelled correctly.
/aspforum/admin_usergroups.asp, line 520"
I went back to the Alternative Mod Setup field and reentered the original code provided in the readme but no luck. Tells me Table Forum_Usergroups primary key not null, and a bunch of other fields arent null.
Was hoping there might be some way to reset the database fields through the alternaive mod setup box--I dont have direct access to the database file but can modify the other files. Understood if I will need to modify the database file manually.
Thanks for your help.
< |
|
|
stotes
Starting Member
8 Posts |
Posted - 23 October 2008 : 12:24:20
|
I reset the database to the default a few minutes ago and tried to reinstall fresh to see where I may have made a mistake.
When copying the initial code into the Alternative MOD setup field I get the following error:
Creating table(s)...
CREATE TABLE FORUM_USERGROUPS( USERGROUP_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , USERGROUP_NAME varchar(100) NOT NULL , USERGROUP_DESC memo NULL , USERGROUP_TYPE int NOT NULL , AUTOJOIN int NOT NULL , MEM_HIDE int NOT NULL , MOD_HIDE int NOT NULL )
Table already exists
Assume I didnt catch this error when I did the original install and it is why I am having problems.
Any ideas on how I can fix this? Thanks. In the meantime I'll just work without the Usergroup Mod, but would like to use this addon eventually.< |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 23 October 2008 : 12:25:15
|
| You need to use one of the connection strings in config.asp that uses a Jet OLEDB provider. Once you change the connection string, execute the dbs file for the mod again, and the mod tables will be created. With your current connection string, no mod tables are created.< |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
stotes
Starting Member
8 Posts |
Posted - 23 October 2008 : 12:31:39
|
Thanks. My network provider set up the database for me and it looks like he used a DSN connection for the connection string. I'll try to have him use the Jet OLEDB and will see if it fixes the problem.
Appreciate the help.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
stotes
Starting Member
8 Posts |
Posted - 23 October 2008 : 13:45:51
|
| Thanks again. Worked perfectly after I adjusted the config file so the connection string uses the physical address for the database. Really appreciate the fast response.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
.<