Solved

Magento Error

Posted on 2012-12-20
3
461 Views
Last Modified: 2012-12-26
I have a 1.6 install of Magento and I don't recall doing anything that would have broken it (I may have by mistake)

I get this error when logging in as a customer

exception printing is disabled by default for security reasons

In the log file I see this

a:5:{i:0;s:236:"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 'AND customer_id = 39 AND qty <= 1)' at line 1";i:1;s:7721:"#0

Can anyone help?
0
Comment
Question by:Gerhardpet
  • 2
3 Comments
 
LVL 12

Expert Comment

by:sivagnanam chandrakanth
ID: 38712038
0
 
LVL 1

Accepted Solution

by:
Gerhardpet earned 0 total points
ID: 38712467
We just found the problem. It was an extension that we install coursing the issue
0
 
LVL 1

Author Closing Comment

by:Gerhardpet
ID: 38720874
Found the solution myself
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
This article discusses four methods for overlaying images in a container on a web page
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now