Error on homepage at Random products section when using MYSQL DB

Error on homepage at Random products section when using MYSQL DB

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.


Times Viewed:
6396
Added By:
Wilson Keneshiro
Date Created:
3/22/2013
Last Updated:
3/22/2013