| Author |
 Topic  |
|
bart
Starting Member
5 Posts |
 Posted - 08 July 2001 : 16:49:33
|
I receive this message in the forum
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/topic.asp, line 484
In the profile pages and the avatar admin setup, everything seems to be normal.
My forum URL is http://www.games.be/forum/
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 08 July 2001 : 17:24:01
|
| Did you run the database setup? Did it complete with no errors? |
|
|
|
bart
Starting Member
5 Posts |
Posted - 09 July 2001 : 11:27:22
|
quote:
Did you run the database setup? Did it complete with no errors?
First I had a error, because I used Access 97.
After changing the settings to Access 2000, the setup ran without any problems.
|
|
|
|
IceStorm
Starting Member
18 Posts |
Posted - 09 July 2001 : 19:53:41
|
Well, this is what I get.
Creating table(s)...
CREATE TABLE FORUM_AVATAR( A_ID int IDENTITY (1, 1) NOT NULL , A_URL nvarchar (255) NULL , A_NAME nvarchar (50) NULL , A_MEMBER_ID int NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied, database 'IceTerminal', owner 'dbo'.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
-2147217900 | [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE TABLE permission denied, database 'IceTerminal', owner 'dbo'.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
-2147217865 | [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_AVATAR2'.
Probably has something to do with not putting in my sql login and password. But I was never prompted to do so.
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 09 July 2001 : 20:06:26
|
| does the user that you have entered on the strConnString line in your config.asp file have create table permissions on your SQL Database? |
|
|
|
IceStorm
Starting Member
18 Posts |
Posted - 09 July 2001 : 20:23:01
|
Ok, who gets to be the first to kick me dead in the ass?
|
|
|
|
maggiau
New Member
96 Posts |
Posted - 10 July 2001 : 06:21:12
|
Richard,
May that be the read-only status on a directory ??? I will check tonight what is on the line 109 ...
Alex
|
|
|
|
[DISA]Jumpman
Junior Member
Denmark
137 Posts |
Posted - 11 July 2001 : 06:06:16
|
Hey
Can you please help me i get this error when i update my Avatar Mod v2.0
Creating table(s)...
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.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_AVATAR2( A_HSIZE int NULL , A_WSIZE int NULL , A_BORDER int NULL )
Table created succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_AVATAR2 (A_HSIZE, A_WSIZE, A_BORDER) VALUES (64, 64, 0)
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding Column...
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'.
Table(s) updated
--------------------------------------------------------------------------------
There were errors please post a question in the MOD Implementation Forum at
From a newbird from Denmark
Per Christiansen
quote:
Title: Avatar Add-on
Version: 2.0
Download: Download
Alternate Download: Alt Download
Installation: read the included avatar_readme.txt file for installation instructions.
Description: For all of the user's who have wanted to add Avatars in the author box on Topic.asp.
Demo: No Demo available as most functions are on the Admin side.
Support: Please post questions and problems with this MOD in the Help: MOD Implementation Forum.
Features:
Admin interface for:
Adding Avatars
Reviewing current Avatars
Editing of current Avatar locations
Deleting of current Avatars
Instant preview of currently selected Avatar in dropdown list for user's selection
You can assign reserve an Avatar to for a specific Member (New in Version 2.0)
Height and Width can now be specified separately (New in Version 2.0)
Other Changes:
This MOD no longer uses the Dynamic Image selector from www.dynamicdrive.com
Includes Upgrade instructions for those who have v1.0 or v1.5 of this MOD installed.
Make sure that you use the mod_dbsetup.asp file that comes with this MOD, especially if you are using MySQL.
Per Christiansen - Denmark |
|
|
|
thaksis
Starting Member
29 Posts |
Posted - 11 July 2001 : 15:08:11
|
disregard, I'm a duh.
Edited by - thaksis on 11 July 2001 15:18:26 |
|
|
|
maggiau
New Member
96 Posts |
Posted - 11 July 2001 : 17:32:11
|
Richard,
my line 109 is :
fso.movefile objFile, server.MapPath("avatars/" & objFile.name)
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 July 2001 : 18:55:15
|
so you are using Alan's add-on.
Looks like your host has either disabled some parts of the FileSystemObject, or you need to adjust the permissions on the directory you are trying to move the Avatars to. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 July 2001 : 19:43:37
|
[DISA]Jumpman,
try changing the strConnString that you are using in config.asp to one of the ones that is labeled for use with Access 2000. They use MS JET Drivers instead of the Microsoft ODBC Microsoft Access Driver. The Microsoft ODBC Microsoft Access Driver doesn't seem to support specifying a DEFAULT value in the T-SQL script. |
|
|
|
Memorom
Starting Member
24 Posts |
Posted - 11 July 2001 : 20:48:12
|
OK...I'm just new at this...what is an Avatar?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 11 July 2001 : 23:36:30
|
| It's just a small picture that is shown underneath a user's name on each post. |
|
|
|
[DISA]Jumpman
Junior Member
Denmark
137 Posts |
Posted - 12 July 2001 : 10:16:13
|
Thank now it's working no errors but no pictures hmmm
Per Christiansen - Denmark |
|
|
|
Topic |
|
Topic Locked
