| Author |
 Topic  |
|
|
TheGamingWorld
Starting Member
18 Posts |
 Posted - 04 April 2001 : 12:17:55
|
Okay I'm using Huwr's forum and I have hosting with 7host.com. Got everything uploaded and finally I got the success screen and went to go to the board and found this error -
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'FORUM_ONLINE'. Make sure it exists and that its name is spelled correctly.
/tgwforum/forum/inc_active_users.asp, line 107
Can anyone help?
|
|
|
TheGamingWorld
Starting Member
18 Posts |
Posted - 04 April 2001 : 12:29:20
|
Just to let you know I ran the mod_dbsetup.asp okay my stupid but I got a bunch of errors when I ran that came up -
Creating table(s)...
CREATE TABLE FORUM_BOOKMARKS( BOOKMARK_ID int COUNTER NOT NULL , B_MEMBERID int NOT NULL , B_TOPICID int NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_VOTELOG( ID int COUNTER NOT NULL , poll_id int NOT NULL , ip varchar(20) NULL , datum date NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_POLL( ID int COUNTER NOT NULL , question varchar(255) NULL , answer1 varchar(50) NULL , count1 int NULL DEFAULT 0, answer2 varchar(50) NULL , count2 int NULL DEFAULT 0, answer3 varchar(50) NULL , count3 int NULL DEFAULT 0, answer4 varchar(50) NULL , count4 int NULL DEFAULT 0, answer5 varchar(50) NULL , count5 int NULL DEFAULT 0, answer6 varchar(50) NULL , count6 int NULL , answer7 varchar(50) NULL , count7 int NULL DEFAULT 0, answer8 varchar(50) NOT NULL , count8 int NULL DEFAULT 0, createdwhen date NOT NULL , active int NOT NULL DEFAULT 1)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_MODS( M_NAME varchar(50) NOT NULL , M_CODE varchar(50) NOT NULL , M_VALUE memo NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MODS' already exists.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MODS ALTER COLUMN M_VALUE memo NOT NULL
Column altered successfully
Table(s) updated
--------------------------------------------------------------------------------
Updating Forum Values..
DELETE FROM FORUM_MODS WHERE (M_NAME = 'Attachment' OR M_NAME = 'HModEnable')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faMaxSize','512')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('Attachment','faExtensions','.zip:.mdb:.txt:.asp')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Pmessages','1')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','UserFields','1')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','PollMentor','0')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','SideMenu','0')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','Attachment','0')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','NewMemberPM','1')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('HModEnable','imageURLPath','images/')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','Subject','Enter your subject line here')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','Message','Enter your message here')
INSERT INTO FORUM_MODS (M_NAME,M_CODE,M_VALUE) VALUES ('NewMemPM','Admin','admin')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_SMILE_CAT( CAT_ID int COUNTER NOT NULL , CAT_NAME text (40) NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_SMILE_CAT (CAT_NAME) VALUES ('Snitz')
INSERT INTO FORUM_SMILE_CAT (CAT_NAME) VALUES ('Other')
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_SMILE_CAT'.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_SMILES( ID int COUNTER NOT NULL , SMILE_URL text (40) NOT NULL , SMILE_CODE text (10) NOT NULL , SMILE_NAME text (20) NOT NULL , CAT_ID int NOT NULL DEFAULT 1)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_angry.gif',':(!','Angry',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_blackeye.gif', 'B)', 'Black Eye',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_dissapprove.gif', 'V', 'Dissapprove',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_dead.gif', 'XX(', 'Dead',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_shock.gif', ':O', 'Shocked',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_approve.gif', '^', 'Approve',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_question.gif', '?', 'Question?',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_blush.gif', ':I', 'Blushing',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_sad.gif', ':(', 'Sad',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_shy.gif', '8)', 'Shy',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile.gif', ':)', 'Smile:)',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_evil.gif', '}:)', 'Evil',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_big.gif', ':D', 'Big Smile',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_cool.gif', '8D', 'Cool Guy',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_sleepy.gif', '|)', 'Sleepy/Tired',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_clown.gif', ':o)', 'Clown',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_kisses.gif', ':X', 'Kisses',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_tongue.gif', ':p', 'Tongue :P',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_wink.gif', ';)', 'Wink',1)
INSERT INTO FORUM_SMILES (SMILE_URL,SMILE_CODE,SMILE_NAME,CAT_ID) VALUES ('icon_smile_8ball.gif', '8', '8 Ball',1)
-2147217865 | [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'FORUM_SMILES'.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_USERFILES( F_FILEID int COUNTER NOT NULL , MEMBER_ID int NOT NULL , F_FILENAME text (255) NOT NULL , F_FILESIZE int NULL , F_REPLY_ID int NULL , F_TOPIC_ID int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_EMAIL_CONFIG( M_TYPE text (15) NULL , M_SUBJECT text (100) NULL , M_MESSAGE memo NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_EMAIL_CONFIG' already exists.
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_EMAIL_CONFIG (M_TYPE,M_SUBJECT,M_MESSAGE) VALUES ('newreply','[forum_title] - Reply to your posting','Hello [user_name]')
INSERT INTO FORUM_EMAIL_CONFIG (M_TYPE,M_SUBJECT,M_MESSAGE) VALUES ('replynot','[forum_title] - Reply to a posting','Hello [user_name]')
Value(s) updated succesfully
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_PM( M_ID int COUNTER NOT NULL , M_SUBJECT text (50) NULL , M_FROM int NULL , M_TO int NULL , M_SENT text (50) NULL , M_MESSAGE memo NULL , M_PMCOUNT text (50) NULL , M_READ int NULL DEFAULT 0, M_MAIL text (50) NULL , M_OUTBOX smallint NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_USERFIELDS( USR_FIELD_ID int COUNTER NOT NULL , USR_LABEL text (40) NULL , USR_FIELDTYPE text (1) NULL , USR_SHORTNAME text (10) NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_MEMBERFIELDS( MEMBER_ID int NOT NULL , USR_FIELD_ID smallint NOT NULL , USR_VALUE text (50) NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_MEMBERFIELDS' already exists.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ONLINE( UserID text (100) NOT NULL , UserIP text (40) NULL , LastChecked text (100) NULL , DateCreated text (100) NOT NULL , CheckedIn text (100) NOT NULL , M_BROWSE memo NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Table 'FORUM_ONLINE' already exists.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMEMAIL int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_PMRECEIVE int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWDOWNLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_MEMBERS ADD COLUMN M_ALLOWUPLOADS int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Dropping Column...
ALTER TABLE FORUM_MEMBERS DROP COLUMN M_DOWNLOADS
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] There is no field named 'M_DOWNLOADS' in table 'FORUM_MEMBERS'.
Table(s) updated
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_CREATED text (40) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'F_CREATED' already exists in table 'FORUM_FORUM'.
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN FORUM_ORDER int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_HIDDEN smallint NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_FORUM ADD COLUMN F_URLIMAGE text(100) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'F_URLIMAGE' already exists in table 'FORUM_FORUM'.
Table(s) updated
--------------------------------------------------------------------------------
Updating Forum Values..
UPDATE FORUM_FORUM SET F_HIDDEN = 1 WHERE F_PRIVATEFORUMS IN (5,6,8)
-2147217904 | [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_CATEGORY ADD COLUMN CAT_ORDER int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ANNOUNCE( A_ID int COUNTER NOT NULL , A_AUTHOR varchar(50) NOT NULL , A_SUBJECT varchar(50) NOT NULL , A_MESSAGE text NOT NULL , A_START_DATE varchar(50) NOT NULL , A_END_DATE varchar(50) NOT NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_EVENTS( EVENT_ID int COUNTER NOT NULL , DATE_ADDED varchar(20) NULL , START_DATE varchar(20) NULL , END_DATE varchar(20) NULL , EVENT_TITLE varchar(50) NULL , EVENT_DETAILS memo NULL , ADDED_BY int NULL , PRIVATE int NULL DEFAULT 0)
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_INPLACE int NULL DEFAULT 0
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Adding Column...
ALTER TABLE FORUM_TOPICS ADD COLUMN T_MSGICON int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_REPLY ADD COLUMN R_MSGICON int NULL DEFAULT 1
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
Table(s) updated
--------------------------------------------------------------------------------
Adding Column...
ALTER TABLE FORUM_CONFIG ADD COLUMN C_STRPAGEBGIMAGE text(50) NULL
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Field 'C_STRPAGEBGIMAGE' already exists in table 'FORUM_CONFIG'.
Table(s) updated
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ARCHIVE_TOPICS( ID int COUNTER NOT NULL , TOPIC_ID int NULL , CAT_ID int NULL , T_STATUS int NULL , FORUM_ID int NULL , T_MAIL int NULL , T_SUBJECT text (50) NULL , T_MESSAGE memo NULL , T_AUTHOR int NULL , T_REPLIES int NULL , T_VIEW_COUNT int NULL , T_LAST_POST varchar(20) NULL , T_DATE varchar(20) NULL , T_LAST_POSTER int NULL , T_IP varchar(20) NULL , T_LAST_POST_AUTHOR int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
--------------------------------------------------------------------------------
Creating table(s)...
CREATE TABLE FORUM_ARCHIVE_REPLY( ID int COUNTER NOT NULL , CAT_ID int NULL , FORUM_ID int NULL , TOPIC_ID int NULL , REPLY_ID int NULL , R_AUTHOR int NULL , R_MESSAGE memo NULL , R_DATE varchar(20) NULL , R_IP varchar(20) NULL , R_MAIL int NULL )
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Any help?
|
 |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 April 2001 : 12:31:00
|
try changing your connectionString so it uses the Jet4 driver instead of the older access 97 driver
|
|
|
|
TheGamingWorld
Starting Member
18 Posts |
Posted - 04 April 2001 : 21:35:35
|
I did that and got the board to come up and you can check it out here -
http://www2.7host.com/tgwforum/forum/default.asp
but when I am logged in as admin and try to access admin functions it gives me a HTTP 500 Internal Server Error.
I'm stuck to why I would be getting this problem, should I try a new .mdb file or try a different mod_dbsetup.asp file?
If you check out the board and want to try to get into the admin functions I haven't changed the default admin login (because I can't) so login - admin and pass - admin will work.
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 April 2001 : 22:00:14
|
in your internet explorer,
Select Tools|Internet Options from the menu then select the Advanced tab.
scroll down the list untill you find this option
Show freindly Http errors
remove the tick from the box and save the settings.
Now try logging back onto your forum, you will hopefully get a different error
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 April 2001 : 22:01:29
|
This is the error you will get
Active Server Pages error 'ASP 0126'
Include file not found
/tgwforum/forum/admin_home.asp, line 96
The include file 'mods/modCMD.asp' was not found.
it can not find modcmd.asp
|
|
|
|
TheGamingWorld
Starting Member
18 Posts |
Posted - 04 April 2001 : 22:46:18
|
THANK YOU!!!! You are a life saver!
Anyways I went back and checked out the files and I found some other mod files missing and I uploaded them. I figure there must have been a bad connection when I uploaded the files and some files didn't get uploaded.
But once again thank you for everything!
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 April 2001 : 22:55:18
|
It's no problem, just shout if you encounter any more problems
|
|
|
| |
Topic |
|
|
|
Topic Locked
