| Author |
 Topic  |
|
|
taskhill
Starting Member
USA
7 Posts |
 Posted - 27 April 2007 : 19:20:45
|
Hello all,
I have recently downloaded and tried to install Snitz on my site. When I enter the setup page and enter my new admin user name and password the following errors get returned:
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, 'taskhill', 'taskhill', 'b5fdb42842b6aa0ef6c3fd9642841c6efde218c6978c05a9a7f0d16a6589aa73', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20070427162004', '20070427161504', '20070427162004', '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, '20070427162004', '', 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, '20070427162004', '20070427162004', 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)
I obviously have no asp knowledge. Has anyone experenced this before? What am I doing wrong now?
Thanks,
Task |
I'll just set that down right there. |
|
|
taskhill
Starting Member
USA
7 Posts |
Posted - 27 April 2007 : 19:54:45
|
| By the way, I have searched the forum and found peices on it but none of them tell how to fix it. Are they talking about CHMOD? How do I set the permissions on the DB, etc.? |
I'll just set that down right there. |
 |
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 27 April 2007 : 20:19:36
|
This can happen if the instructions haven't been followed in order - search for '13 errors', I hope that'll help you, let us know how you get on!
Paddy :) |
|
|
|
pdrg
Support Moderator
United Kingdom
2897 Posts |
Posted - 27 April 2007 : 20:22:16
|
quote:
Originally posted by taskhill
By the way, I have searched the forum and found peices on it but none of them tell how to fix it. Are they talking about CHMOD? How do I set the permissions on the DB, etc.?
CHMOD is a unix thing, you're more likely on a Windows box if you can run ASP. Hope this helps |
|
|
|
crossfire
Starting Member
Philippines
2 Posts |
Posted - 28 April 2007 : 16:19:36
|
| I just installed "snitz". When I enter the setup page and enter my new admin user name and password I am getting the same "error message" posted by "taskhill". I have followed the installation instruction religiously. Can anyone help me? |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 28 April 2007 : 16:51:58
|
| This is a permissions problem. The anonymous internet user requires read/write access to the DB file and folder. Hope This Helps |
|
|
| |
Topic |
|
|
|
Topic Locked
