I'm getting the following error message on my website when looking at the proddetails.asp page.

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'xxxxxxx' is full due to 'ACTIVE_TRANSACTION'.

/vsadmin/inc/incfunctions.asp, line 1869

*(xxxxxx = database name)

The error does not show up on any other page.
I have checked with the host and the transaction log is not full. The database is functioning properly, and it only affects the Product Details page.
Some people have been able to checkout and purchase items, but others seem to be affected, including myself on several different devices.

Any ideas or help would be appreciated.

Dean
www.stxop.com

Hi Dean
Can you ask the host to set the database recovery model to SIMPLE, which usually sorts this problem out.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

I turned on debugmode and found a little more information:

DELETE FROM recentlyviewed WHERE rvDate

Dean
www.stxop.com

Hi Dean
Did you change the recovery model to SIMPLE? Another thing to do would be to truncate the transaction log and you could ask your host to do that for you.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Asking GoDaddy to do something like that takes an act of congress.
Getting a SQL expert on the phone is just as difficult.

I was able to issue a TRUNCATE TABLE on the recentlyviewed table.
That deletes all the data in that table without using the log file.
The dates in that table were all from last November.

I have asked them to set the recovery to SIMPLE but have not heard a response.

Dean
www.stxop.com