Author |
Topic |
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 16:00:48
|
I Installed Avatar everything seemed to go ok, the board came up and I mosted a test message to see if it all work and this is the error I received.
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/krazyivan/forum/topic.asp, line 483
this is the code from that line and severl following lines.
<br><% if Trim(rs("M_AVATAR_URL")) <> "" and lcase(rs("M_AVATAR_URL")) <> "noavatar.gif" and (IsNull(rs("M_AVATAR_URL")) = false) then %> <% '## Forum_SQL - Get Avatar Settings from DB strSql = "SELECT " & strTablePrefix & "AVATAR2.A_WSIZE" strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_HSIZE" strSql = strSql & ", " & strTablePrefix & "AVATAR2.A_BORDER" strSql = strSql & " FROM " & strTablePrefix & "AVATAR2" set rsav = my_Conn.Execute (strSql) %> <img src="<% =rs("M_AVATAR_URL") %>" align="absmiddle" width=<% =rsav("A_WSIZE") %> height=<% =rsav("A_HSIZE") %> border=<% =rsav("A_BORDER") %> hspace="0" ><% set rsav = nothing %><% end if %> <br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_COUNTRY") %></small></font> <br><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>"><small><% =rs("M_POSTS") %> Posts</small></font></td> <td bgcolor="<% =strForumFirstCellColor %>" <% if (AdminAllowed = 1) then %>colspan="3"<% else %>colspan="2"<% end if %> valign="top"><img src="icon_posticon.gif" border="0" hspace="3"><font color="<% =strForumFontColor %>" face="<% =strDefaultFontFace %>" size="<% =strFooterFontSize %>">Posted - <% =ChkDate(rs("T_DATE")) %> : <% =ChkTime(rs("T_DATE")) %></font>
thanks in advance for all your help
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 16:25:27
|
Did you run the database setup to add the Avatar Tables to the database? |
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 16:31:23
|
quote:
Did you run the database setup to add the Avatar Tables to the database?
Yes Sir I did...it gave me a syntax error on the first line....I believe i had the wrong type of data base selected in my config...i changed it and the setup ran fine....but then I receive the error listed in the first post.
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 16:54:49
|
Do you get any errors when you goto the Admin functions for the Avatars? Like the Avatar Settings? |
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 16:57:37
|
quote:
Do you get any errors when you goto the Admin functions for the Avatars? Like the Avatar Settings?
No Errors at all....Only the above one when a message is posted. One thing I have just noticed is that in the profile section, there is no option there for the person to pick a avatar....dont kno if that helps or not.
|
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 17:02:32
|
quote:
quote:
Do you get any errors when you goto the Admin functions for the Avatars? Like the Avatar Settings?
ok I found I forgot to turn on that option in the profile section....but I just tried to post a message and received the same error message
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/krazyivan/forum/topic.asp, line 483 kinda strange thou....no text appears on the message at all just a blank screen No Errors at all....Only the above one when a message is posted. One thing I have just noticed is that in the profile section, there is no option there for the person to pick a avatar....dont kno if that helps or not.
|
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 17:22:57
|
ok I started from the begining...fresh install....I ran the mod_dbsetup.asp and received this message CREATE TABLE FORUM_AVATAR( A_ID int COUNTER NOT NULL , A_URL text (255) NULL , A_NAME text (50) NULL , A_MEMBER_ID int NULL DEFAULT 0) -2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
i'll wait for a reply before I do anything else
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 17:43:41
|
in your config.asp file, change the strConnString line that you are using to one that is labeled for use with Access 2000 |
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 18:35:12
|
quote:
in your config.asp file, change the strConnString line that you are using to one that is labeled for use with Access 2000
Same Problem
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/krazyivan/forum/topic.asp, line 483 this is my Cong that I'm using
'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\www\digitalrice\members\krazyivan\cgi-bin\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\www\digitalrice\members\krazyivan\cgi-bin\snitz_forums_2000.mdb" '## MS Access 2000 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7 'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_"
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 19:16:35
|
When you ran the database setup after changing the strConnString line, did you get any errors? |
|
|
Krazyivan
Starting Member
USA
7 Posts |
Posted - 27 May 2001 : 20:13:14
|
quote:
When you ran the database setup after changing the strConnString line, did you get any errors?
yep same one
|
|
|
DraX3D
Starting Member
4 Posts |
Posted - 05 June 2001 : 01:18:15
|
I got the same error when trying to update the database. Can you just explain what those values mean and I'll add the tables myself?
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Topic |
|