| Author |
 Topic  |
|
|
Plextor
Starting Member
1 Posts |
 Posted - 28 March 2002 : 13:22:12
|
This is probably a stupid question but how do i make moderators for my forums?
And aslo, is there an avatar add on possibly for Snitz?
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 28 March 2002 : 13:27:31
|
Go to Members as Admin and click the Pencil next to the person you want to change to Moderator.
Then go to Moderator Setup in the Admin Menu to attach that person to a forum.
The Avatar MOD can be found at:
http://www.ls3k.com/snitz/mods.asp?action=details&ID=97
 |
 |
|
|
sideout
Starting Member
7 Posts |
Posted - 08 April 2002 : 02:48:05
|
I installed the Avatar MOD and updated and now when I add an avatar, I got a 505 error....Anybody had a problem with this?
|
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 08 April 2002 : 03:13:13
|
go to tools in the menu bar of your browser, and click internet options. click the tab advanced and scroll to Show Friendly HTTP Error Messages. uncheck the checkbox and hit F5 in your browser when you get the 505 error. post the real error here
Crash's Site | Crash is from 
|
|
|
|
sideout
Starting Member
7 Posts |
Posted - 09 April 2002 : 04:04:23
|
Ok, I was wrong, it is a Page Can't be found error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/forums/admin_add_avatar.asp, line 90
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Page:
POST 157 bytes to /forums/admin_add_avatar.asp
POST Data:
Method_Type=Write_Configuration&AvatarURL=http%3A%2F%2Fwww.myalphastation.com%2Fimages%2Fspidey2.jpg&AvatarName=spidey&AvatarMemberID=0&submit1=Submit+Avatar
Also, when I log in after installing the Avatar mod, my server CPU hitss 100% and DLLHOST.exe takes up about 175MB of RAM before the request times out.
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 09 April 2002 : 08:11:53
|
What kind of server do you have your forums on? I've heard a lot about the avatar mod, but not that it gives those kinds of problems.
The error you get is because of a missing table. Make sure you've installed the dbs_ files that belong to the MOD by going to the Admin Options > MOD Setup
http://www.frutzle.com
Snitz Exchange | Do's and Dont's |
|
|
|
Um
Junior Member
222 Posts |
Posted - 09 April 2002 : 08:27:00
|
FrutZle, did you mean this? :
Avatar Mod v2.0
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID COUNTER CONSTRAINT PrimaryKey PRIMARY KEY , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
Table already exists
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table already exists
--------------------------------------------------------------------------------
Adding new records..
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS'.
--------------------------------------------------------------------------------
I cant enter at members profile and registration, and when I try (as admin) to enter avatar, this massage cames to screen:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/pf/admin_add_avatar.asp, line 90
|
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 09 April 2002 : 08:51:52
|
That answered my second question. It looks as if for some reason the table can't be found even though it's there. If you're using an Access database and have Microsoft Access, I'd suggest you open the forums' database on your computer and take a look at the table and its properties.
Also, what kind of server do you have your forums on?
http://www.frutzle.com
Snitz Exchange | Do's and Dont's |
|
|
|
Um
Junior Member
222 Posts |
Posted - 09 April 2002 : 09:47:48
|
About server, I dont know, where can I read what kind of server is?
About table, I DON'T HAVE "FORUM_AVATAR" table in acess tables...
Where can I download this acess document with forum_avatar in it?
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 09 April 2002 : 21:30:54
|
There should have been a file in the avatar mod that will build the table in your database for you. Go to admin options > mod setup and see if Avatar is on the list.
 Nathan Bales
Snitz Exchange | Do's and Dont's |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 09 April 2002 : 21:48:29
|
The problem is that the Database driver that is used when you use the strConnString that is labeled for use with Access 97, does not support specifying default values for new fields when using T-SQL. You have 2 options...
download an updated version of MOD Setup that takes care of the shortcomings of the Access97 driver here:
http://kinser.121hosts.net/link-it/default.asp?catid=3&cattitle=FILES
or change the strConnString you are using to one of the ones labeled for use with Access2000.
This is not a problem specific to the Avatar MOD, you will have problems with ANY Mod that specifies DEFAULT values for new fields.
It is recommended to always use the Access2000 strConnString unless the drivers aren't installed on the server. |
|
|
|
sideout
Starting Member
7 Posts |
Posted - 10 April 2002 : 02:32:42
|
I am running Windows 2k advance server with IIS 5, PIII 666mhz. Access is not installed on the server, but my regular compter I do my configuring with has access 2000. I just realized that! Would it work better with Office on my server?
Ijust noticed that the avatar.dbs file wassnt in my zip file. hmmmm
Edited by - sideout on 10 April 2002 02:59:45 |
|
|
|
sideout
Starting Member
7 Posts |
Posted - 10 April 2002 : 03:32:06
|
This is the greatest program!!! I checked my zip file and the missing file is the dbs_avatar.asp file. I copied it to the forum directory, deleted the avatar table (kept avatar2 table) and hit MOD SETUP and poof!!! it worked like a charm! Thanks for all the help!!
|
|
|
| |
Topic |
|
Topic Locked
