Forum Moderators: open
I run an online store and getting the follow error when you connect to it. If you refresh it, you are able to go into my online store.
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/inc/globals.asp, line 409
I went to globals.asp line 409 and this is what it says
'ensure not search engine before logging visitor
if isSearchEngine() = false then
' Log user info to DB
SQLQuery = "INSERT INTO tblVisitors (sessionID, visitorIP, visitorBrowser, visitorDateTime, referrer, entryPage, searchCount, abandonedCart) VALUES ('" & session("eCartsessionID") & "','" & request.servervariables("REMOTE_ADDR") & "','" & prepString(request.serverVariables("HTTP_USER_AGENT")) & "'," & prepDate(now()) & ",'" & prepString(left(session("referrer"), 255)) & "','" & prepString(request.serverVariables("SCRIPT_NAME")) & "', 0, " & prepBoolean("false") & ");"
objConn.Execute(SQLQuery)
end if
objConn.close
set objConn = nothing
' Number of checkout customer lookups
session("lookupCount") = 0
' Number of items in cart
session("noItemsInCart") = 0
end if
end sub
How do i fix this problem?
