| Author |
 Topic  |
|
|
Gorsar
Starting Member
1 Posts |
 Posted - 08 August 2002 : 22:59:04
|
Hey folks,
This question could have been asked 1000 times, but I looked and haven't found it.
I just installed snitz for the first time (was using iKonboard) and it went flawlessly! I tried to do the Avatar mod and changed everything, I went into MOD Setup from admin, and selected to update the Avatar Mod v2.0. When I clicked update I received the following error:
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'.
--------------------------------------------------------------------------------
Also, when I go into avatar setup and select to Review/Edit I get this error:
Review/Edit Avatars
Preview Avatar URL Avatar Name Owner
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 'FORUM_AVATAR'. Make sure it exists and that its name is spelled correctly.
/forums/admin_review_avatar.asp, line 89
I am running a fresh install of Snitz version 3.3.05 and my forum URL is http://www.ocaddiction.com/forums/
I'm using the MS Access 97 DB that was included in the forum file and the forums are working flawlessly, I just can't get this avatar mod to work. HELP!
Any help you can offer would be GREATLY appreciated.
--
Jim |
|
|
ayora
Starting Member
37 Posts |
Posted - 11 August 2002 : 07:04:51
|
| try use the MS Access 2000 db |
 |
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 11 August 2002 : 07:09:17
|
Download the database and make sure the table does indeed not exist. You could do what ayora said: upgrade your database to Access 2000 and then run the MOD setup again.
If neither helps and the table isn't created, you'll have to enter the table and fields manually. It's not a lot of work, but you'll have to pay close attention to the dbs_ file's information when you insert the fields. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
