Forum Moderators: open

Message Too Old, No Replies

Help - error message

E commerce web site - can't diagnose problem.

         

rickcasta

4:25 pm on Nov 19, 2007 (gmt 0)

10+ Year Member



I have a small e commerce web site and have a problem I can't diagnose. Occasionally users cannot get on the site, and I have the problem myself sometimes.

I'm actually getting it right now. In firefox, I get this message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

/ahle.asp, line 28

If I clear cookies I can usually get in, but I can't count on my customers to do that...

In IE, I get this message:

The website cannot display the page
HTTP 500
Most likely causes:
The website is under maintenance.
The website has a programming error.

What you can try:
Refresh the page.

Go back to the previous page.

More information

This error (HTTP 500 Internal Server Error) means that the website you are visiting had a server problem which prevented the webpage from displaying.

For more information about HTTP errors, see Help.

I HAVE NO IDEA WHAT IS CAUSING THIS - ANY HELP WOULD BE APPRECIATED!

defanjos

5:33 pm on Nov 19, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



What is the code on ahle.asp, line 28?
You have to start there.

mattur

6:17 pm on Nov 19, 2007 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



The error message means your code is trying to run a query that attempts to update a field in your database with a value that is too big for the field size.

eg: attempting to insert a 10 character long string into a field that has a max length of 8 characters.

BTW you see a different error message in IE because you have "Show friendly HTTP error messages" enabled in options HTH.