If your VPASP 6.50 site or below version returns this error on the homepage and using MYSQL DB:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/shoprandomproducts.asp, line 212
That means the MYSQL db does not support the LIMIT function on the following sql statement eg.:
SELECT catalogid FROM products where hide=0 and cstock> 2 AND (highercatalogid is null) LIMIT 0,50
Please do these steps below to fix the error :
1. Login to your VPASP control panel.
2. Go to : Set-up
3. In the
Field name
, please enter : xrandomproductlimit and do a search.
4. Set this config value to empty.
5. Click Reload Shop Configuration.