quote:

---

Snitz already allows you to share a single database between multiple forums

---

Error: -2147217865	Could not find output table 'PHOTO_CATEGORY'.
strSql: 	INSERT INTO PHOTO_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147217865	Could not find output table 'PHOTO_MEMBERS'.
strSql: 	INSERT INTO PHOTO_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, 'admin2', 'admin2', '864c90ccb7177f26742fce2bc70cb0259d5dee15d9dc68e141136baae758825c', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20090328161836', '20090328161336', '20090328161836', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000')
Error: -2147217865	Could not find output table 'PHOTO_FORUM'.
strSql: 	INSERT INTO PHOTO_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, '20090328161836', '', 0, 0, '000.000.000.000', 1, 1, 0)
Error: -2147217865	Could not find output table 'PHOTO_TOPICS'.
strSql: 	INSERT INTO PHOTO_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, '20090328161836', '20090328161836', 0, '000.000.000.000', 1, 0, 1)
Error: -2147217865	Could not find output table 'PHOTO_TOTALS'.
strSql: 	INSERT INTO PHOTO_TOTALS (COUNT_ID, P_COUNT, T_COUNT, U_COUNT) VALUES(1,1,1,1)
Error: -2147217865	Could not find output table 'PHOTO_GROUP_NAMES'.
strSql: 	INSERT INTO PHOTO_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('All Categories you have access to','All Categories you have access to')
Error: -2147217865	Could not find output table 'PHOTO_GROUP_NAMES'.
strSql: 	INSERT INTO PHOTO_GROUP_NAMES (GROUP_NAME,GROUP_DESCRIPTION) VALUES ('Default Categories','Default Categories')
Error: -2147217865	Could not find output table 'PHOTO_GROUPS'.
strSql: 	INSERT INTO PHOTO_GROUPS (GROUP_ID, GROUP_CATID) VALUES (2,1)

Error Type:
Microsoft JET Database Engine (0x80040E37)
The Microsoft Jet database engine cannot find the input table or query 'PHOTO_ACTIVE_USERS'. Make sure it exists and that its name is spelled correctly.
/cast/inc_header.asp, line 229

function chkAURecord(intTotalActiveUsers)
  if cInt(intTotalActiveUsers) > cInt(intAURecord) then 'We have a new record!!! :)
    'Check to see if it *Really* is a record, or if Application varaibles just got reset
	strSql = "SELECT C_VALUE FROM " & strTablePrefix & "CONFIG_NEW WHERE C_VARIABLE = 'intAURecord'"
	set rs = my_conn.execute (strSql)
	intOldRecord = cint(rs("C_VALUE")) '## this is LINE 218
	rs.close
	set rs = nothing

quote:

---

would it be simplier if i just add this code "AND NOT CAT_ID = 5" in the default.asp file?....

---