Unknown column 'myprod'

[Tom1234]

Can I get some help with this error? RP 2.8d.

An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (myprod,1,23,35) ORDER BY rand_col DESC

The query returned with an errorcode of:

Unknown column 'myprod' in 'where clause'

[Michael P]

Was this sent via an email or on a page you encountered?

[Tom1234]

Email. I have the errors emailed to me. This was generated by a visitor. I am getting regular errors of this type. Any idea on what the problem is?

[Michael P]

I'll post a fix for the next update.

[Tom1234]

Thanks.

Without knowing what the fix is, I can't tell if you'll be fixing similar errors I am seeing, so here are a few more:

=============
An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (all,1,23,35) ORDER BY rand_col DESC

The query returned with an errorcode of:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'all,1,23,35) ORDER BY rand_col DESC' at line 1

==========

An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (last14,1,23,35) ORDER BY rand_col DESC

The query returned with an errorcode of:

Unknown column 'last14' in 'where clause'

===============

An error was encountered during execution of the query:

SELECT id,user,userid,cat,title,manu,bigimage,views, id*0+RAND() as rand_col FROM rp_products WHERE bigimage !='' AND approved='1' AND cat in (fav,1,23,35) ORDER BY rand_col DESC

The query returned with an errorcode of:

Unknown column 'fav' in 'where clause'

[Tom1234]

Michael,

Did you mean that this is fixed in RP 2.8.1 or the next release after that?

I am still seeing the problem in 2.8.1:

Tom

[hoonz]

i have this problem as well... as a temporary fix, or to hide it at least, you can turn off the side column, since that is where the error is being displayed.

[Michael P]

Try changing line 422 in pp-inc.php from:

if ( !empty($cat) ) {

to:

if ( is_numeric($cat) ) {

[JRKy]

That fixed it for me. Didn't post the issue since Tom hit it first. But eitherway, that fixed all the errors that...

"My Products", "Watchlist", and "Recent Reviews: last day last 7 days last 14 days all products"

...links would produce.