Troubleshooting and Common Errors

Christian Party

Web Wiz Forums Documentation
Troubleshooting and Common Errors
Return to the main menu

Installing Web Wiz Forums should be relative straight forward, but due to a wide variations of web servers and configurations problems may occur.

This page tries to answer many of the questions that are asked almost everyday on Web Wiz Guide.

	Some forum files are giving errors - most common problem
	ASP Scripts won't run!
	How can I tell if my web space supports ASP?
	The page cannot be displayed. HTTP500 error - often confused with 404 page not found
	Cannot update. Database or object is read-only
	Operation must use an updateable query
	The search key was not found in any record
	CDate error

For other common FAQ's see the following articles on Web Wiz Guide; ASP Frequently Asked Questions, or for database errors see Database Errors FAQ's.

Some forum files are giving errors - most common problem

Everyday people report what they think are problems or errors in Web Wiz Forums once they have uploaded it to their web space. It seems that all to often the error has been coursed by a file or files getting corrupted in the upload process.

If you find that Web Wiz Forums is giving errors then before reporting an error try re-uploading the files to your web server again and see if that corrects the problem.

ASP Scripts won't run! - most common problem

This seems to be the most common problem that people have.

ASP need's to be run through a web server, hence the name Active Server Pages, no Server, no Active Pages. If you are not familiar with ASP please read through the article on Web Wiz Guide on, What is Active Server Pages (ASP)?

If you are finding that you can't get an ASP script to run on your web space provided by your web space provider then check with them that they fully support ASP.

ASP is completely different to CGI and Pearl, so having support for CGI does not mean that you have support on your web space for ASP.

How can I tell if my web space supports ASP?

To be able to tell if your web space provider supports ASP, the easiest way is to look at any FAQ or support pages that the provider may have, or contact them by e-mail or phone and ask them.

The page cannot be displayed. HTTP 500 - Internal server error (often confused with 404 page not found)

This is a very general error. Many people often say, when I click on a link in the forum I get a page can not be found error, 99.99% of the time this is actually incorrect, if you look closer at the error message it will be a 500 Internal server error.

If you receive this error when trying to run an ASP script with no error message or line number then you need to turn off Friendly HTTP Error Massages in Internet Explorer so you can get details on what is coursing the error.

If you are not sure how then read article on Web Wiz Guide on how to Turn Off Friendly HTTP Error Messages in IE.

Cannot update. Database or object is read-only.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

This is the most common error that I'm asked about. This error usually happens when you try to insert data into or update data in an Access database. It means that you don't have sufficient permissions to write to the database.

If you are running the web server yourself then read the article on Web Wiz Guide, Checking and Setting up the Correct Permissions on the Server.

If you are not running the server yourself you will need to contact your web space provider and ask them how to sort the problem out. You may need to use a special folder or they may have to setup a system DSN for you or change the permissions on the directory containing the database.

Operation must use an updateable query
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

This error usually happens when you try to insert data into or update data in an Access database. It means that you don't have sufficient permissions to write to the database.

If you are running the web server yourself then read the article on Web Wiz Guide, Checking and Setting up the Correct Permissions on the Server.

If you are not running the server yourself you will need to contact your web space provider and ask them how to sort the problem out. You may need to use a special folder or they may have to setup a system DSN for you or change the permissions on the directory containing the database.

The search key was not found in any record.
Microsoft JET Database Engine (0x80004005)
The search key was not found in any record.

This error often means that the database has become corrupted.

To correct the error the database needs to be repaired. If the database is on a remote server download the database and follow the instructions below to repair the database.

Open the database in Microsoft Access, click on the 'Tools' menu and select 'Database Utilities -> Compact and Repair Database'.

CDate Error

This error happens when the locale settings on the web server you are using are incorrectly set up or another ASP application on the server has changed the locale settings. You can over come this problem by following the instructions below: -

Open the file common.asp and find the line near the top that reads: -
'Session.LCID = 1033
Remove the single ' quote mark from in front of this line.
Then replace the number 1033 with your local ID number a full list can be found at: -
Changing Date, Time, and Currency Format
Clean out your cookie cache on your web browser.

For other common FAQ's see the following articles on Web Wiz Guide: -
ASP Frequently Asked Questions, or for database errors see Database Errors FAQ's.

Modified Tuesday, November 02, 2010