| Author |
 Topic  |
|
|
cls
New Member
76 Posts |
 Posted - 06 September 2002 : 17:25:27
|
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 DEFAULT 0)
Table already exists
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
Column already exists
--------------------------------------------------------------------------------
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
Column already exists
-2147467259 | The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 06 September 2002 : 17:32:58
|
I dont think they matter....as it says they already exists so it should work fine, have you run the mod setup more than once?
|
 |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 06 September 2002 : 17:33:35
|
quote:
Adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
Column already exists
Can you look at the database? Is the column already there? If so you are fine.
@tomic |
SportsBettingAcumen.com |
|
|
|
cls
New Member
76 Posts |
Posted - 06 September 2002 : 17:36:51
|
I ran it the first time, and nothing showed... got the same error message. Ran it a second time and nothing shows.
When I go into my "profile" I see the list of avatars, but when I click on them, I only see a (.) dot... they don't show. When I look at any posts, the space for the avatars are there, but no pictures..
Not sure what to do from here.. Not sure of a safe way to check the database? |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 06 September 2002 : 17:39:57
|
| If nothing is showing in the topics etc trying running check installation or going to the avatar admin panel and saving the settings, it may be that the height and width values have not been loaded, that does stop the avatars appearing. |
|
|
|
cls
New Member
76 Posts |
Posted - 06 September 2002 : 17:39:58
|
Ok... figured out the problem... very silly problem..
Because of the new install the avatar settings default to 32x32 and since all our avatars are 64x64 they would not show up for anyone. Once changed in Avatar settings, problems were solved. |
|
|
|
cls
New Member
76 Posts |
Posted - 06 September 2002 : 17:42:07
|
Hamlin is right 100% it is in the settings.. good call!
quote:
Originally posted by Hamlin
If nothing is showing in the topics etc trying running check installation or going to the avatar admin panel and saving the settings, it may be that the height and width values have not been loaded, that does stop the avatars appearing.
|
|
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 06 September 2002 : 17:42:39
|
I had the same problem. Does anyone use 32 x 32 avatars??? I think the default should be 64 x 64 but that's just my personal preference.
@tomic |
SportsBettingAcumen.com |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 06 September 2002 : 17:46:07
|
I don't know if we are talking about the same mod but it does default to 64 * 64
The code in the dbs file
(C_VARIABLE,C_VALUE)#('intAvatarWidth','64')
(C_VARIABLE,C_VALUE)#('intAvatarHeight','64')
Sets the value to use at the start.
The problem is that the numbers are not loaded unless you save the settings or run the check installation thing, that forces it to re-load all the application variables (if I understand it correctly). |
Edited by - Hamlin on 06 September 2002 17:46:53 |
|
|
| |
Topic |
|
Topic Locked
