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
 Avatars not appearing after upgrade to 3.4.05
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

papahemmy
Starting Member

4 Posts

Posted - 09 May 2006 :  21:58:27  Show Profile
Tonight I upgraded from 3.4.03 to 3.4.04 to 3.4.05.

Once the upgrades were completed (and all went fine), I made the changes to Avatar Mod for 3.4, which I previously had installed when still using 3.4.03.

After making all the changes and uploading them, I went to update the MOD in the admin. When I did, I got the following errors:


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


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

Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD M_AVATAR_URL nvarchar (255) NULL
ALTER TABLE FORUM_MEMBERS ADD M_AVATAR_URL nvarchar (255) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_AVATAR_URL' in table 'FORUM_MEMBERS' is specified more than once.

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

Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AVATAR_URL nvarchar (255) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD M_AVATAR_URL nvarchar (255) NULL
-2147217900 | Column names in each table must be unique. Column name 'M_AVATAR_URL' in table 'FORUM_MEMBERS_PENDING' is specified more than once.


Because I already had the installed the Avatar MOD on an earlier release, it can't finish the setup. The end result is that the avatars appear in everyone's profiles, but they do not appear under the user's names in the actual topics.

Has anyone seen this? I made all of the changes to the topic.asp file except for the changes recommended for versions 3.4.01, .02, and .03

Any idea what I should do?

Thanks in advance!

Edited by - papahemmy on 09 May 2006 21:59:38

Ranko
Junior Member

400 Posts

Posted - 10 May 2006 :  04:23:36  Show Profile
Backup your files and apply the avatar mod modifications, it should work as the upgrade didn't drop the tables for avatar mod (Table already exists) nor did it delete the columns in forum defalut tables (Column names in each table must be unique...).
Go to Top of Page

papahemmy
Starting Member

4 Posts

Posted - 10 May 2006 :  05:14:01  Show Profile
Thanks Ranko,

I guess I didn't explain that part correctly, but I actually did apply the avatar mod modifications to all files for which the readme instructed me to. But even after applying the modifications, the images did not appear in the topic.asp file.

Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 10 May 2006 :  05:21:05  Show Profile  Send ruirib a Yahoo! Message
Looks like the changes to topic.asp were not correctly applied. I'd advise you to start anew with a clean topic.asp and apply the changes. Been some time since I last applied the mod, but I don't remember any changes specific to specific Snitz versions...


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

papahemmy
Starting Member

4 Posts

Posted - 10 May 2006 :  07:50:21  Show Profile
ruirib,

I took your advice and just started from scratch and got it to work. The problem is that when I saw the instructions for a modification to Snitz 3.4.03, I didn't make the change since I'm using 3.4.05. Once I went ahead and made the 3.4.03 changes, all was well.

Thanks for your help!
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 10 May 2006 :  08:28:02  Show Profile  Send ruirib a Yahoo! Message
Glad that you got it working.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.69 seconds. Powered By: Snitz Forums 2000 Version 3.4.07