| Author |
 Topic  |
|
|
aishah
Starting Member
Egypt
27 Posts |
 Posted - 10 April 2009 : 07:29:25
|
Ciao gurus!
http://www.cameldive.com/forum
Running version 3.4.06
I am a typical webmaster with no developer skills who has been running a forum since 2002 which somebody helped me set up. This forum has become an enormously popular meeting place for old and new clients and a very valuable asset in the company.
Now I am beginning to worry about having problems with the forum as it grows larger by the day and I lack the skills to look after it properly. We nowadays frequently have members reporting various errors which normally go away after a refresh or two. After having read old posts here I realise our database might be corrupted. Some errors would happen, say, at somebody's office but not at home. Other times members in certain time zones have more errors than others. These are the errors that have been reported recently:
'Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/forum/inc_header.asp, line 111
As far as I know, this happens when more than 1 person tries to post at the same time.
------------------------------------------------
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forum/topic.asp, line 356
--------------------------------------------------
Microsoft JET Database
Engine error 80040e57
to small a field
/forum/post-infoasp,line 1044
------------------------------------------------------
Microsoft JET Database Engine error '80004005'
Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
/forum/inc_header.asp, line 111
We are on a shared IP. Could that be the cause of trouble? How can I prevent the above errors from happening?
Many thanks in advance and have a fab day.
Susanne |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 10 April 2009 : 07:33:30
|
| Not sure about some of the problems, but you should have an "enormously popular" website running off of MS SQL Server or MySQL (I personally tend to recommend the former, but both are fine). A proper database for high-end usage will alleviate some of your problems. |
 |
|
|
aishah
Starting Member
Egypt
27 Posts |
Posted - 10 April 2009 : 08:08:51
|
Thanks AnonJr,
"...and the Universe trying to produce bigger and better idiots"
Okay I belong in that category. 
Another question related to databases: in the root of the folder on the server that stores our forum there is a file called "nameofdatabase_2007.mdb". Then, there is a sub folder called "something_mb". Within this folder I find another database, named "nameofdatabase_2003.mdb". This is apparently the database being used (because I can see the date of last modified being today), NOT the one from 2007 in which year I think I did an upgrade. Have I messed things up here? Are we supposed to be using the 2007 database? |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 April 2009 : 09:30:26
|
| the database you are using will be listed in your forums config.asp file, what it is called is irrelevent, I would hazard a gues that one was probably a backup. ( you definately shouldn't be using a database that is in the root of your site, and preferably shouldn't use one that is in a subdirectory either, it is best to have your db in a directory that is not accesible by a browser at all. |
|
|
|
aishah
Starting Member
Egypt
27 Posts |
Posted - 10 April 2009 : 10:07:00
|
HuwR, thanks for your clarification.
I think you are right. The file in my config is the one from 2003. I archived the forum sometime around 2007, maybe that is why I have 2 DB.
Not quite sure I understand your comment about where to store the database. It is not stored in the root of the site itself but inside the "forum" Like this: www.cameldive.com/forum/folder/database.mdb
The "folder" isn't accessible.
Correct? |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 April 2009 : 10:25:14
|
quote:
The "folder" isn't accessible.
Correct?
no, not correct, the folder is accessible, it is possible that someone could guess the name of your database and download it. It is better to have your database folder outside of your webroot (not just the forum root) then your connection string would point to the database but nobody could gain access to it.
for example if your website is say
c:\webfolder\mywebsite\www you would put your database in c:\webfolder\mywebsite\database (I know this is not allways possible using shared hosting, but in a lot of cases it is and is much more preferable to having your database in a subfolder of c:\webfolder\mywebsite\www |
|
|
|
aishah
Starting Member
Egypt
27 Posts |
Posted - 10 April 2009 : 12:26:28
|
I see! Excellent advice, learned something new today. Lucky for us we are about to go for a virtual dedicated server so hopefully we can follow your advice there.
(Nobody could ever guess the name we chose for the database )
Thanks SO much both of you. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 10 April 2009 : 12:37:46
|
| if you are going for a dedicated server, I would go for either MySQL or if you prefer an MS solution, try installing SQLExpress it is also free and works very well (and easier to migrate an existing your access database to). |
|
|
| |
Topic |
|
Topic Locked
