Author |
Topic  |
|
papahemmy
Starting Member
4 Posts |
Posted - 09 May 2006 : 21:58:27
|
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
|
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...). |
 |
|
papahemmy
Starting Member
4 Posts |
Posted - 10 May 2006 : 05:14:01
|
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.
|
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 10 May 2006 : 05:21:05
|
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 |
 |
|
papahemmy
Starting Member
4 Posts |
Posted - 10 May 2006 : 07:50:21
|
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! |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
|
Topic  |
|