| Author |
 Topic  |
|
|
nyks
Starting Member
6 Posts |
 Posted - 05 March 2004 : 04:29:11
|
Greetings,
I need some help with Hamlin's Avatar Mod for 3.4
I'm using snitz v3.4.04
I followed all tutorial and edited all codes according to tutorial.
For topic.asp, at the end;
For snitz 3.4.0.3 follow this step
Look for this code arond line 584
and
For snitz 3.4.0.3 follow this step
Look for this code arond line 796
I applied these steps. Uploaded my files to my server.
When I try to use MOD Setup,
I ended up with these warning; (on first step)
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
Other steps updated with success.
Now
1) when I try to Review/Add Avatars, I'm getting this error;
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.
/hydra/admin_review_avatar.asp, line 84
2) when I try to Upload Avatars , getting this error;
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/hydra/avatar_upload.asp, line 198
3) when I try to use mass add tool getting this error;
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/hydra/admin_avatar_mass_add.asp, line 111
My topic.asp is here as txt file; http://nyks.net/hydra/topic.txt
If you need to see any other files I can upload them too.
Really need help. 
Thank you.
|
|
|
nyks
Starting Member
6 Posts |
Posted - 05 March 2004 : 17:51:23
|
| No idea? I really need HELP about this. :/ |
 |
|
|
Trekker
Starting Member
United Kingdom
3 Posts |
Posted - 06 March 2004 : 06:56:11
|
How confusing! First it complains the table exists, then it complains it can't find the table...
If you have Microsoft Access, I'd recommened downloading the database, open it, and check to see if the table does exist (FORUM_AVATAR). If it does, backup the file (just in case!), delete the table FORUM_AVATAR, upload the file back to the server, and try MOD Setup again. That should correctly recreate the table.
It's a pretty baffling error you have there... |
|
|
|
nyks
Starting Member
6 Posts |
Posted - 10 March 2004 : 02:24:51
|
Altough it says table exists, there was no FORUM_AVATAR table in database file. Creating FORUM_AVATAR table manually in database file worked.
Code is working now, and avatars UP.
And I have no idea why MOD could not create table and why informed me table already exists.
Anyway, it is working now.
Thank you.
|
|
|
|
Trekker
Starting Member
United Kingdom
3 Posts |
Posted - 13 March 2004 : 05:25:34
|
Great news! Glad it's working now.
I went to have a look at your site, but (Sorry!) quickly left - I was going blind from all that blinking! |
|
|
| |
Topic |
|
|
|
Topic Locked
