| Author |
 Topic  |
|
Gizmo3
Junior Member
130 Posts |
 Posted - 09 February 2006 : 19:50:07
|
I have installed Ben upload file Mod. I am now getting this error.
Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'FORUM_ATTACHMENTS'. Make sure it exists and that its name is spelled correctly.
/snitzforum/forum.asp, line 349
I need some help on MS Query Anylizer and how do I get it and how do i use it to make a Forum_attachments table.
I am running win server 2003 with an access data base |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 10:09:42
|
| I have downloaded that mod file. And have upated it in the forum admin and I am still getting that error |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
 |
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 11:37:33
|
I have downloaded that mod file. And have upated file (( There's a db setup file available)) I have uploaded it in the forum admin and I am still getting that error.
You can get to the forum at www.ontbus.com.
right now i cant register new users. it goes to the (( Registration Rules and Policies Agreement )) and then i click agree and it woint go any farther just stays on that page.
Second problem. I try to post with out a pic and it seems to work fine
I post with a pic and i get the following error
There has been a problem!
Could not find output table 'FORUM_ATTACHMENTS'.
Go back to correct the problem.
But it isurts the post any way but with out the pic
I realy this that it ios just an 'FORUM_ATTACHMENTS'.
problem.
But i have done the up dates with the update file
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 11:53:32
|
When I open the Attachment file with MS Query this is what it says. Is this correct or do I have to change some thing.
CREATE TABLE [dbo].[FORUM_ATTACHMENTS] (
[FORUM_ID] [int] NOT NULL ,
[TOPIC_ID] [int] NOT NULL ,
[REPLY_ID] [int] NULL ,
[FILENAME] [varchar] (216) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 12:33:45
|
| REGERTERING PROBLEM FIXED |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 12:35:58
|
problem
I try to post with out a pic and it seems to work fine
I post with a pic and i get the following error
There has been a problem!
Could not find output table 'FORUM_ATTACHMENTS'.
Go back to correct the problem.
But it isurts the post any way but with out the pic
I realy this that it ios just an 'FORUM_ATTACHMENTS'.
problem.
I have downloaded that mod file. And have upated file (( There's a db setup file available)) I have uploaded it in the forum admin and I am still getting that error.
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 10 February 2006 : 15:50:31
|
Gizmo3,
As OnlyWayMule said, you need to update your DB for it to be able to run. To do this, you need to do the following:
1. Go to Admin Options and logon
2. Click on "Alternative Mod Setup"
3. Paste the following code in to the Code box on the page:
[DROP]
ATTACHMENTS
[END]
[CREATE]
ATTACHMENTS
FORUM_ID#int#null#
TOPIC_ID#int#null#
REPLY_ID#int#null#
FILENAME#varchar (216)#not null#
[END]
4. Click the "Submit" button
5. Make sure that your host/server has ASPSmartUpload installed or it will not work.
If you do not have the ASPSmartUpload installed, then maybe try: Mikes File Attachment as it doesnt require the component to be there. It uses Windows Scripting to do the uploads.
I hope that helps..
|
Cheers,
David Greening |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 17:29:42
|
Ok I did what you said This is what it said
Database Update
Dropping Table..
DROP TABLE FORUM_ATTACHMENTS
Table does not exist
Creating table(s)...
CREATE TABLE FORUM_ATTACHMENTS( FORUM_ID#INT#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL , TOPIC_ID int NULL , REPLY_ID int NULL , FILENAME text (216) NOT NULL )
Table already exists
Database setup finished
|
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 17:32:11
|
Then I tried to to post the pic and I syill got this
There has been a problem!
Could not find output table 'FORUM_ATTACHMENTS'.
Go back to correct the problem.
Thanks for all your patients everyone |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 10 February 2006 : 20:32:07
|
| Going to try MS SQL instead of access |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 11 February 2006 : 06:42:28
|
| There must be something wrong with the SQL statement you're executing. |
|
|
|
Classicmotorcycling
Development Team Leader
Australia
2084 Posts |
Posted - 11 February 2006 : 16:59:44
|
Try the table creation with-out the space in the varchar statement:
1. Go to Admin Options and logon
2. Click on "Alternative Mod Setup"
3. Paste the following red code in to the Code box on the page:
[DROP]
ATTACHMENTS
[END]
[CREATE]
ATTACHMENTS
FORUM_ID#int#NULL#
TOPIC_ID#int#NULL#
REPLY_ID#int#NULL#
FILENAME#varchar(216)#NOT NULL#
[END]
4. Click the "Submit" button
See how that goes.
|
Cheers,
David Greening |
|
|
|
Gizmo3
Junior Member
130 Posts |
Posted - 12 February 2006 : 08:32:50
|
I tryed that way to Got this meesage
Database Update
Dropping Table..
DROP TABLE FORUM_ATTACHMENTS
Table does not exist
Creating table(s)...
CREATE TABLE FORUM_ATTACHMENTS( FORUM_ID#INT#NULL# int IDENTITY (1, 1) PRIMARY KEY NOT NULL , TOPIC_ID int NULL , REPLY_ID int NULL , FILENAME varchar(216) NOT NULL )
Table already exists
Database setup finished |
This account was hacked into by Image, a very honest guy as you all can see! Stealing people's passwords is his pasttime. Beware of this, before you register at his forums! |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 12 February 2006 : 10:52:01
|
quote:
Originally posted by Gizmo3
Going to try MS SQL instead of access
Did you move to MS SQL or are you still using Access? |
|
|
|
Topic |
|
Topic Locked
