Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Avatar Mod - DB will not update
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

jimsau
Starting Member

3 Posts

Posted - 02 December 2003 :  17:53:35  Show Profile
The problem is that the FORUM_AVATAR is not being created and does not exist but it thinks it does or something. Any Ideas?

Output from mod update:

Avatar Mod for 3.4

Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL )
Table already exists

--------------------------------------------------------------------------------

Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
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'.

--------------------------------------------------------------------------------

Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS_PENDING'.

--------------------------------------------------------------------------------

Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intShowAvatar','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAvatarFolder','avatars/')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarWidth','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarHeight','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarBorder','1')

Value(s) updated succesfully

jimsau
Starting Member

3 Posts

Posted - 02 December 2003 :  22:45:26  Show Profile
Now no one can register either. Activation fails with...

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 'M_AVATAR_URL'. Make sure it exists and that its name is spelled correctly.

Go to Top of Page

OneWayMule
Dev. Team Member & Support Moderator

Austria
4969 Posts

Posted - 03 December 2003 :  03:50:46  Show Profile  Visit OneWayMule's Homepage  Send OneWayMule an ICQ Message
Have you tried "Alternate MOD Setup"?
Simply copy the content of the dbs_avatar.asp file to the form there and hit "Update".

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook
Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch

Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.48 seconds. Powered By: Snitz Forums 2000 Version 3.4.07