| Author |
 Topic  |
|
|
jettas
Starting Member
19 Posts |
|
|
jettas
Starting Member
19 Posts |
 Posted - 24 October 2003 : 14:52:04
|
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.
/jettas/test2/forum/admin_review_avatar.asp, line 84
when i go to review and edit avatars i get this message.
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.
/jettas/test2/forum/admin_review_avatar.asp, line 84
|
 |
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 13:42:06
|
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_AVATAR'.
/jettas/test2/forum/admin_add_avatar.asp, line 100
when i try to add them |
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 25 October 2003 : 14:03:07
|
| look in your database and see if the table FORUM_AVATAR is physically there. |
 |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 14:49:03
|
| i've downloaded it, can't find it :S |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 14:50:24
|
| its not in the database, so how do i add it? |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 14:58:24
|
The UK MkIVs Forum wicked, i'm from club gti mate. my forums about vw's and alike.
when i go to mod setup, it doesn't have a drop down box, so i add it manualy and it says its already there :S |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 15:00:09
|
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
--------------------------------------------------------------------------------
adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_AVATAR_URL text (255) NULL
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'.
--------------------------------------------------------------------------------
adding Column M_AVATAR_URL...
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
ALTER TABLE FORUM_MEMBERS_PENDING ADD COLUMN M_AVATAR_URL text (255) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'M_AVATAR_URL' already exists in table 'FORUM_MEMBERS_PENDING'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intShowAvatar','1')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('strAvatarFolder','avatars/')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarWidth','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarHeight','64')
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('intAvatarBorder','1')
Value(s) updated succesfully
--------------------------------------------------------------------------------
|
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 25 October 2003 : 15:12:46
|
| Strange, it sounds permission based but I didn't think there were permissions on objects in Access, may be wrong though. Is the rest of the forum working okay? What's your name on CGTI? |
The UK MkIVs Forum |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 15:16:13
|
| jettasrfab, i'm also on The UK MkIVs Forum, the rest of the forum works fine, just when i want to add any avatars :S |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 25 October 2003 : 15:40:06
|
Ah, the infamous jettasrfab 
Some weird going's on there, I presume you have FTP access, I would try the following.
Download the database
Also, after downloading the database, check to see if the FORUM_AVATARS table is there again, if it isn't then open the table FORUM_CONFIG and see if the values 'intShowAvatar', 'strAvatarFolder', 'intAvatarWidth', 'intAvatarHeight' and 'intAvatarBorder' are in there. Delete all these, they may be duplicated as you have ran the dbs twice, delete all duplicates also.
Delete the database via FTP
Try any page on the forum, it should fail because the database is not there
Re-upload the database
|
The UK MkIVs Forum |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 15:43:07
|
ta dude, i did that and it was missing FORUM_AVATAR so i got a DB from some one who did have it and imported it blank.
dunno what you mean by Ah, the infamous jettasrfab ;) :P |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 25 October 2003 : 15:51:05
|
| got it working now. |
|
|
|
jettas
Starting Member
19 Posts |
Posted - 26 October 2003 : 07:26:28
|
| only thing not working now is mass add. it won't work. |
|
|
| |
Topic |
|
Topic Locked
