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: General / Classic ASP versions(v3.4.XX)
 13 errors when creating database
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

arcos
Starting Member

Spain
23 Posts

Posted - 17 April 2006 :  14:59:48  Show Profile  Visit arcos's Homepage
At - You need to create all the tables in the database before you can start using the forum.

I get the following errors -

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, 'Administrator', 'Administrator', '63b28ac014b925d5fae2e268c44f180c7eca1158867cb9abf1ee946baa4f52ed', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20060417210312', '20060417205812', '20060417210312', '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, '20060417210312', '', 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, '20060417210312', '20060417210312', 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)

Can anyone help?

Thanks

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 17 April 2006 :  15:06:10  Show Profile  Visit HuwR's Homepage
Error: -2147467259 Operation must use an updateable query


means yo do not have the correct permissions set on your database
Go to Top of Page

arcos
Starting Member

Spain
23 Posts

Posted - 17 April 2006 :  15:09:07  Show Profile  Visit arcos's Homepage
Problem is that I dont even have the database created yet.

This error occurs when I am first setting the database up
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 April 2006 :  16:43:25  Show Profile  Send ruirib a Yahoo! Message
Your host will need to assign read / write permissions on the database file and folder to anonymous internet user.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

arcos
Starting Member

Spain
23 Posts

Posted - 17 April 2006 :  18:04:08  Show Profile  Visit arcos's Homepage
Thanks for all your help.

I now have the forum installed and ready to use (except for the detailed bits!! )

Will look tomorrow at how to get the forums up and running.

Thanks again
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 17 April 2006 :  18:21:45  Show Profile  Send ruirib a Yahoo! Message
You're welcome.


Snitz 3.4 Readme | Like the support? Support Snitz too
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.35 seconds. Powered By: Snitz Forums 2000 Version 3.4.07