| Author |
 Topic  |
|
|
Blue Gularis
Starting Member
Thailand
6 Posts |
 Posted - 16 May 2005 : 01:51:52
|
Hi,
I am not sure where to put this, so I'll start here in General. I am using Windows Srever 2003 and my friend is trying to help me set up my forum- we keep getting this error:
***
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/FB/Default.asp, line 91
http://www.(my site name is here).com/FB/
***
If anyone could point us in the right direction I'd really apreciate it!
Blue
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 16 May 2005 : 05:30:44
|
Have you run setup.asp?
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
 |
|
|
Blue Gularis
Starting Member
Thailand
6 Posts |
Posted - 22 May 2005 : 23:17:58
|
Hi Shaggy,
Thanks for replying! I'm sorry it took so long for me to respond, I had to make a trip to Laos.
My friend "isn't sure" if he ran setup.asp or not- we'll try it and I'll post the results!
Thanks,
Blue |
Edited by - Blue Gularis on 22 May 2005 23:18:45 |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 23 May 2005 : 05:25:38
|
You're welcome  Did it solve your problems?
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Blue Gularis
Starting Member
Thailand
6 Posts |
Posted - 23 May 2005 : 07:20:50
|
Hi again,
Unfortunately it looks like it isn't that simple...
We get the following errors when we run setup.asp, right after we type in our admin and password:
*********
Please Wait until the installation has been completed!
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_MEMBERS (M_STATUS, M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_LINK1, M_LINK2, M_PHOTO_URL, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_DEFAULT_VIEW, M_LEVEL, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_DATE, M_LASTHEREDATE, M_LASTPOSTDATE, M_TITLE, M_SUBSCRIPTION, M_HIDE_EMAIL, M_RECEIVE_EMAIL, M_LAST_IP, M_IP) VALUES(1, 'Fimbra', 'Fimbra', '1a208d4f0eb569b3d7d1d46c6ca35d32256db2edb557ac19fdb9ba64556c5123', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20050523162536', '20050523162036', '20050523162536', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_FORUM(CAT_ID, F_STATUS, F_MAIL, F_SUBJECT, F_URL, F_DESCRIPTION, F_TOPICS, F_COUNT, F_LAST_POST, F_PASSWORD_NEW, F_PRIVATEFORUMS, F_TYPE, F_IP, F_LAST_POST_AUTHOR, F_LAST_POST_TOPIC_ID, F_LAST_POST_REPLY_ID) VALUES(1, 1, 0, 'Testing Forums', '', 'This forum gives you a chance to become more familiar with how this product responds to different features and keeps testing in one place instead of posting tests all over. Happy Posting! ', 1, 1, '20050523162536', '', 0, 0, '000.000.000.000', 1, 1, 0)
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_TOPICS (CAT_ID, FORUM_ID, T_STATUS, T_MAIL, T_SUBJECT, T_MESSAGE, T_AUTHOR, T_REPLIES, T_UREPLIES, T_VIEW_COUNT, T_LAST_POST, T_DATE, T_LAST_POSTER, T_IP, T_LAST_POST_AUTHOR, T_LAST_POST_REPLY_ID, T_ARCHIVE_FLAG) VALUES(1, 1, 1, 0, 'Welcome to Snitz Forums 2000', 'Thank you for downloading Snitz Forums 2000. We hope you enjoy this great tool to support your organization! Many thanks go out to John Penfold <asp@asp-dev.com> and Tim Teal <tteal@tealnet.com> for the original source code and to all the people of Snitz Forums 2000 at http://forum.snitz.com for continued support of this product.', 1, 0, 0, 0, '20050523162536', '20050523162536', 0, '000.000.000.000', 1, 0, 1)
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_TOTALS (COUNT_ID, P_COUNT, T_COUNT, U_COUNT) VALUES(1,1,1,1)
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES (' ****',' ****')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('*****','*****')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('All Categories you have access to','All Categories you have access to')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('Default Categories','Default Categories')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)
The Installation has NOT been completed !
There were 13 Critical Errors...
Click here to retry....
Click here to check the Database....
****
First we unzipped the contents to a folder on the server with the exception of the database and shared this folder with full access permission.
Secondly we put the database in C:\(database name). We renamed the database from the default Snitz_forums_2000.mdb.
Thirdly we edited the config.asp to point to the database in C and uncommented the lines corresponding to database type and database connstring trying both Access 2000 and 97.
We are stumped. 
Thanks again,
Blue
|
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 23 May 2005 : 07:32:01
|
See here and here.
Search is your friend.
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Blue Gularis
Starting Member
Thailand
6 Posts |
Posted - 23 May 2005 : 21:48:59
|
Thanks again,
It looks like Doug might have the answers! I'm new to this so I'll try running some searches if that doesn't clear it up. We were following the instructions in the second link you provided throughout but perhaps missed something.
Cheers,
Blue |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 24 May 2005 : 04:55:12
|
Actually, what I was trying to draw your attention to with the second link was the following:quote:
Q: Why do I get an "Operation must use an updateable query" error when trying to use my forum?
A: This is a common HTTP 500 error encountered when setting up an Access Database. It means that the folder in which you have placed the database does not have proper permissions granted to the server to modify the files. Make sure that if your host provided a location specifically for databases, that you have put the database there. For more information and other possible resolution strategies, you can refer to this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Blue Gularis
Starting Member
Thailand
6 Posts |
Posted - 29 May 2005 : 04:22:05
|
Yaaayyyy!!!
Shaggy, the links and info you posted helped us find the problem, thank you. In a nutshell we hadn't thought to set permissions in the "security" tab. My friend can describe this in better detail, I will ask him to post soon.
Thanks again for all the help, much apreciated!
Blue |
|
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 30 May 2005 : 07:31:43
|
You're welcome No need to hassle your friend for details, it's something we see all the time here 
|
Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
| |
Topic |
|
|
|
Topic Locked
