Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Avatar Problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

thezod
Starting Member

8 Posts

Posted - 04 August 2002 :  22:06:16  Show Profile
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

/forum/admin_review_avatar.asp, line 89

This is the error message I get when I try to review the avatars.

When I ran the MOD Setup option, it told me that the FORUM_AVATAR table already existed, but it didn't. So I manually added it and I get the above error. I can't add or alter the avatars..

Does anyone have any ideas..?


dayve
Forum Moderator

USA
5820 Posts

Posted - 04 August 2002 :  22:15:22  Show Profile  Visit dayve's Homepage
if you got a message stating that the table already existed, I'd be quite sure that it did. when you added the table manually, are you 100% certain you accomodated for the correct field types, sizes and names?

http://www.nineinchnailz.com

Snitz Exchange | Snitz Icons | Do's and Dont's
Go to Top of Page

thezod
Starting Member

8 Posts

Posted - 04 August 2002 :  22:27:05  Show Profile
Im pretty certain that I added the correct tables and set the primary key correctly.

I am certain that the table didn't already exist... despite sayin it did.

I had a FORUM_AVATAR2 table, but no FORUM_AVATAR table.

I've just tried removing the tables that I added and the auto added table. I also removed the new colum added to the members table and re-run the mod setup.

Same problem... Is there something I've likely to have missed.

Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 04 August 2002 :  22:29:35  Show Profile  Visit dayve's Homepage
quote:

Im pretty certain that I added the correct tables and set the primary key correctly.

I am certain that the table didn't already exist... despite sayin it did.

I had a FORUM_AVATAR2 table, but no FORUM_AVATAR table.

I've just tried removing the tables that I added and the auto added table. I also removed the new colum added to the members table and re-run the mod setup.

Same problem... Is there something I've likely to have missed.





please post your table schema (field names/types/sizes/indexes) for Forum_Avatar

http://www.nineinchnailz.com

Snitz Exchange | Snitz Icons | Do's and Dont's
Go to Top of Page

thezod
Starting Member

8 Posts

Posted - 04 August 2002 :  22:33:19  Show Profile
This is the manually created schema...

A_ID AutoNumber PrimaryKey
A_URL Text (255) Null
A_Name Text (50) Null
A_MEMBER_ID Int Default=0



Go to Top of Page

dayve
Forum Moderator

USA
5820 Posts

Posted - 04 August 2002 :  23:01:28  Show Profile  Visit dayve's Homepage
line 89 points to this select statement:

strSql = "SELECT " & strTablePrefix & "AVATAR.A_ID"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_URL"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_NAME"
strSql = strSql & ", " & strTablePrefix & "AVATAR.A_MEMBER_ID"
strSql = strSql & " FROM " & strTablePrefix & "AVATAR "
strSql = strSql & " ORDER BY " & strTablePrefix & "AVATAR.A_ID ASC;"

the error you are receiving generally means you are referencing a field that does not exist. are you sure after creating the table manually that the error that reoccurred is not a cached error message?

http://www.nineinchnailz.com

Snitz Exchange | Snitz Icons | Do's and Dont's
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07