Error with 'Update or CancelUpdate without AddNew or Edit' when editing Content (VP-ASP 6.50)

Error with 'Update or CancelUpdate without AddNew or Edit' when editing Content (VP-ASP 6.50)

This fix is only valid for VP-ASP 6.50 version.

If you are trying to edit content and after click Update record, you get this error msg :

Microsoft JET Database Engine error '80040e21'
Update or CancelUpdate without AddNew or Edit.
/shopa_editcontent.asp, line 384


Then please follow these steps below :

1. Open file shopa_editcontent.asp using notepad or any text editor.

2. Locate this code :

if fieldname = "cdateadded" then
if fieldvalue = "DONTUPDATE" then
exit sub
end if
end if

3. Directly below the code above, please insert this code :

if lcase(fieldname) = "showonbox" then
if Fieldvalue=yesnos(0) then
fieldvalue=1
else
fieldvalue=0
end if
end if

4. Save the file and upload to your site.

5. You can try to test the changes by editing a content and see if this works.


Times Viewed:
6194
Added By:
Wilson Keneshiro
Date Created:
5/10/2012
Last Updated:
5/10/2012