I received two times of the following error. Do you know why this is happening? How do we address this?
MySQL Error Report
> An error was encountered during execution of the query:
> SELECT bigimage,approved,cat,title,userid,date,rating,views,user FROM rp_products WHERE id= LIMIT 1
> 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 'LIMIT 1' at line 1
> If you need assistence or feel this is a 'bug'; please report it to our support forums at: ReviewPost PHP User Reviews Engine
> To turn off these emails, set $debug=0 in your config-inc.php file.
I would suspect some type of spam bot. That query is from the revshow.php script which is only shown when you have reviews. Therefore put a robots.txt file in your reviewpost directory with the contents like this
You need to actually edit the robots text file and make it what I posted as I would suspect your robots.txt is not what I posted.
Like I said if there are NO reviews we do not show a link to revshow.php and if there are reviews you would not get that error so I can only guess you have a bot hitting that script so without you altering your robots.txt file you are allowing bots to crawl that script.
No that query is only in one spot in the program unless this is something you have altered. There is no other response I can give.
You can check your revshow.php script for that query and see what I mean. That query is only ran when visiting the script and we do not show that script unless there are comments. You would only get an error is someone was trying to run that script and there are no comments.
Please read my replies there is no revshow link showing on our program without there being actual reviews. This has to be a bot issue and if you disallow revshow.php in your actual robots.txt that should solve it.
You can try making sure line 73 of that file encapsulate the id variable