cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Error after patch

SQL Error after patch

After installing several patches to 1.8.1, I receive this message on the homepage:

 

SQLSTATE[42000]: Syntax error or access violation: 1064 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 '.`value)` = '0') AND (`start_time` <= '2016-03-25') AND (`end_time` >= '2016-03-' at line 2

 Any ideas?

4 REPLIES

Re: SQL Error after patch

Hi @SonshineTN

 

Can you post the detailed error message for better clarity, I think the message you posted is truncated.

Please see

'2016-03-'

Did you apply SUPEE-6788 patch?

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: SQL Error after patch

Yes. I did apply 6788. In addition, I applied 6285 and 6482. The site is: http://silversalesusa.com    You can view the full error there. Thanks!

Re: SQL Error after patch

Hi @SonshineTN

 

I think your site is working fine now after visiting the link.


If you can answer your own question with the solution, it will be helpful for others also.

---
Problem Solved Click Accept as Solution!:Magento Community India Forum

Re: SQL Error after patch

I replaced the app/design/frontend/base directory with a fresh copy. Fixed the SQL errors but then had to fix some more extension issues that arose with bannerslider, PureChat, and credit card processing. Thank for your willingness to help with this issue.