| Author |
 Topic  |
|
tekgirl
Starting Member
USA
40 Posts |
 Posted - 30 January 2005 : 23:00:52
|
I thought I did, but that seems to have been one of my mistakes. So...I went back, started all over again and now get this error message:
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE nvarchar(1) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE nvarchar(1) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_AUHIDE' in table 'FORUM_MEMBERS' is specified more than once.
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE nvarchar(1) NULL
Column altered successfully
Adding Column M_AUHIDE...
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AUHIDE nvarchar(1) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AUHIDE nvarchar(1) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_AUHIDE' in table 'FORUM_MEMBERS_PENDING' is specified more than once.
Would it be better to just remove Active Users and reinstall the mod? |
--tekgirl |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 31 January 2005 : 09:26:40
|
| It appears as though the mod is working, but the admin aspect of the mod is nowhere to be found in Admin Option. It was there prior to the upgrade. I guess it's really no big deal, although I'm wondering what happened ;) |
--tekgirl |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 01 February 2005 : 22:14:38
|
quote:
Originally posted by ruirib
Did you also upgrade the code or just the database? Was the code changed in any way?
Didn't change the code at all - just the database. I'll check the code again and see if something has changed by chance - one never knows ;) Thanks! |
--tekgirl |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 February 2005 : 05:17:25
|
| If you didn't change the code, I would say it's because something was not properly moved from the Access DB to the SQL Server DB, quite likely because you didn't run mod setup before transferring the DB data. What to do now? I'm afraid I can advise much, since I can't really remember how the mod works. I'll try to have a look and let you know when I do. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
tekgirl
Starting Member
USA
40 Posts |
Posted - 03 February 2005 : 19:56:26
|
| Thanks, ruirib. No rush - the mod is working and I agree, it probably has to do with perhaps a table missing? I'll see if I can figure out a way to fix it and whatever you come up with, whenever you do is greatly appreciated. |
--tekgirl |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 February 2005 : 19:27:46
|
Can you check your server variables to check whether the Active Users variables exist? Some of the names to look for are:
STRAUANON
STRAUANONOVERRIDE
STRAUIP
STRAURECORDDATE
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Topic Locked
