|
cibili
Starting Member
1 Posts |
 Posted - 21 December 2002 : 06:04:17
|
1. Hi, I'm new and I tried to install the latest version of SF2000.
2. When I go to setup.asp, Im getting the message "The database needs to be installed !!"
3. so I click the "Click here to create the tables in the database."
4. In the next screen I choose the Admin UserName & Password
5. In the next screen It says that "Please Wait until the installation has been completed !" and I get the errors below;
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_CATEGORY(CAT_STATUS,
CAT_NAME) VALUES(1, 'Snitz Forums 2000')
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, 'moderatortr', 'moderatortr', '232e1f785b17262e06d95afacb24f9d4d708011769367d587450531e33bae3e0', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20021219151339', '20021219150839', '20021219151339', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000')
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, '20021219151339', '', 0, 0, '000.000.000.000', 1, 1, 0)
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, '20021219151339', '20021219151339', 0, '000.000.000.000', 1, 0, 1)
strSql: INSERT INTO FORUM_TOTALS (COUNT_ID, P_COUNT, T_COUNT, U_COUNT) VALUES(1,1,1,1)
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES (' ****',' ****')
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('*****','*****')
strSql: INSERT INTO FORUM_BADWORDS (B_BADWORD, B_REPLACE) VALUES ('****','****')
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('All Categories you have access to','All Categories you have access to')
strSql: INSERT INTO FORUM_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('Default Categories','Default Categories')
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....
I dont know what to do, pls help!  |
|
Topic Locked
