- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.