help pls....
i changed the strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_" to strTablePrefix = "PHOTO_" strMemberTablePrefix = "PHOTO_"
and i get this error:
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)
i ignored the error above and went to the forum...
and then i encountered another error:
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
what i did is, i made a copy of the FORUM_ACTIVE_USERS and renamed it PHOTO_ACTIVE_USERS and erased or deleted its content, and the error above goes on and on, and i just did the same process as i did with PHOTO_ACTIVE_USERS...
after i got done with the tables,
another error occured:
Error Type:
(0x80020009)
Exception occurred.
/cast/inc_func_common.asp, line 218
my inc_func_common.asp file:
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
how can i fix this?... am i missing or forgetting something?.... :(