Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 SETUP.ASP
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

minhluan70
Junior Member

USA
120 Posts

Posted - 07 May 2002 :  19:18:26  Show Profile  Visit minhluan70's Homepage
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.



Code : 80040E4E


Minhluan Le

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 07 May 2002 :  19:49:54  Show Profile  Send ruirib a Yahoo! Message
Read the Installation Guide by clicking the link below in my signature.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  11:22:54  Show Profile  Visit minhluan70's Homepage
quote:

Read the Installation Guide by clicking the link below in my signature.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs




Thank you, it works. But after I upgraded the database to the final version, I have this error message:

Please Wait until the upgrade has been completed !

Noncritical error: allready existed in the table
Critical error: code: 80040E09 in statement [ALTER TABLE FORUM_FORUM ADD F_A_COUNT INT NULL ; ] while trying to add F_A_COUNT to the FORUM table
Critical error: code: 80040E09 in statement [ALTER TABLE FORUM_FORUM ADD F_A_TOPICS INT NULL ; ] while trying to add F_A_TOPICS to the FORUM table
Critical error: code: 80040E09 in statement [ALTER TABLE FORUM_TOTALS ADD T_A_COUNT INT NULL ; ] while trying to add T_A_COUNT to the TOTALS table
Critical error: code: 80040E09 in statement [ALTER TABLE FORUM_TOTALS ADD P_A_COUNT INT NULL ; ] while trying to add P_A_COUNT to the TOTALS table

Microsoft JET Database Engine error '80040e09'
-------------------------------------------------------------------
Cannot modify the design of table 'FORUM_A_TOPICS'. It is in a read-only database.

/elmaforum/setup.asp, line 1705
-------------------------------------------------------------------

Minhluan Le

Edited by - minhluan70 on 08 May 2002 11:27:09
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  11:28:08  Show Profile  Send ruirib a Yahoo! Message
What were you trying to do when that happened? That table usually won't be accessed unless you want to archive topics.

Also, make sure that the database file has read/write permissions:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16559

http://www.dougscode.com/faq/default.asp?id=q1020

If that doesn't solve it, ensure that your database file hasn't the read only attribute checked.



-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  11:31:39  Show Profile  Send ruirib a Yahoo! Message
You changed your post after I posted my answer to the original version. Not a pleasant thing to do...

Aren't you setting up a new forum? If that's the case why did you try to upgrade the database? It should the last version already...

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  11:37:11  Show Profile  Visit minhluan70's Homepage
quote:

What were you trying to do when that happened? That table usually won't be accessed unless you want to archive topics.

Also, make sure that the database file has read/write permissions:

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=16559

http://www.dougscode.com/faq/default.asp?id=q1020

If that doesn't solve it, ensure that your database file hasn't the read only attribute checked.



-------------------------------------------------
Installation Guide | Do's and Dont's | MODs



I already assigned Read/Write permission to the Everyone group. But it still the same.


Every day is a nice day for me
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  11:45:28  Show Profile  Visit minhluan70's Homepage
The version I'm using is the one I downloaded yesterday and this is the latest version. I never have any problem with the previous version and I never modified the permission of the database Access file. I don't know why it happens to me this time. Also I have no experience of ASP or ACCESS. I like SnitZ Forum b/c it's easy for me to implement it to our internal network.

Every day is a nice day for me
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  11:52:21  Show Profile  Send ruirib a Yahoo! Message

Anyway you didn't answer my question regarding the database upgrade. Were you trying to upgrade your database from a previous version?

Isn't your forum working already? Have you tried to visit the default.asp page?

If your forum is not working yet, please post a link to your forum. Also make sure you have installed the latest security bug fixes.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  11:54:09  Show Profile  Send ruirib a Yahoo! Message
quote:

[I already assigned Read/Write permission to the Everyone group. But it still the same.


I had missed this one. The read/write permissions should be set to the IUSR_YOURCOMPUTERNAME user, not the Everyone group.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  12:28:14  Show Profile  Visit minhluan70's Homepage
quote:

quote:

[I already assigned Read/Write permission to the Everyone group. But it still the same.


I had missed this one. The read/write permissions should be set to the IUSR_YOURCOMPUTERNAME user, not the Everyone group.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs




I did what you told me to do but it still the same. Here is what I did:
1. I can access the setup.asp without any problem. Anh here is the result:
Forum setup has been completed.

Congratulations!!
The forum setup has been completed succesfully.
You can now start using Snitz Forums 2000.

Remember to change the default Admin password !!

If you have questions or remarks you can visit us at: http://forum.snitz.com

You can also post the address of your forum there
so others can come and visit you.

Click here to go to the forum.
Upgrade the database.
(shouldn't be needed for this database!)

2. When I click on the link "click here to go to the forum", I got this error message:

The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.

--------------------------------------------------------------------------------

Please try the following:

Click the Refresh button, or try again later.

Open the mtek home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/elmaforum/inc_functions.asp, line 717


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; NetCaptor 6.5.0PB0; Smart Explorer v5.0)

Page:
GET /elmaforum/default.asp


Every day is a nice day for me
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  12:35:26  Show Profile  Send ruirib a Yahoo! Message
That's a permissions problem. Read my 2nd post here to solve it. You should have read it by now and applied the recomendations there.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs


Edited by - ruirib on 08 May 2002 12:36:29
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  14:42:02  Show Profile  Visit minhluan70's Homepage
quote:

That's a permissions problem. Read my 2nd post here to solve it. You should have read it by now and applied the recomendations there.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs


Edited by - ruirib on 08 May 2002 12:36:29


Thanks, I downloaded the new version again and it works! I can't not show you the link to my forum because it's in an intranet network and for internal use only.

Every day is a nice day for me
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  14:45:16  Show Profile  Visit minhluan70's Homepage
quote:

That's a permissions problem. Read my 2nd post here to solve it. You should have read it by now and applied the recomendations there.

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs


Edited by - ruirib on 08 May 2002 12:36:29


There is another problem: I can't log on with username: admin, password: admin
It says incorrect username and password????

Every day is a nice day for me
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 08 May 2002 :  15:28:04  Show Profile  Send ruirib a Yahoo! Message
Are you using the same database as in your previous setup?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page

minhluan70
Junior Member

USA
120 Posts

Posted - 08 May 2002 :  18:57:55  Show Profile  Visit minhluan70's Homepage
quote:

Are you using the same database as in your previous setup?

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs




Sure this is the same database. But don't worry, it works now. You know why? I need to change the admin password first, then it works !?!?

Every day is a nice day for me
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.38 seconds. Powered By: Snitz Forums 2000 Version 3.4.07