Solved

Magento Error

Posted on 2012-12-20
3
467 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

777 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