Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1")

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.stack.nl!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<python@mrabarnett.plus.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.028
X-Spam-Evidence	'H': 0.94; 'S': 0.00; 'subject:error': 0.03; 'syntax': 0.04; 'subject:version': 0.09; 'throws': 0.09; 'corresponds': 0.16; 'from:addr:mrabarnett.plus.com': 0.16; 'from:addr:python': 0.16; 'from:name:mrab': 0.16; 'message- id:@mrabarnett.plus.com': 0.16; 'received:192.168.1.4': 0.16; 'subject: \n ': 0.16; 'wrote:': 0.18; 'manual': 0.22; 'header :User-Agent:1': 0.23; 'error': 0.23; 'fine': 0.24; "haven't": 0.24; 'performing': 0.26; 'header:In-Reply-To:1': 0.27; 'function': 0.29; "i'm": 0.30; 'getting': 0.31; 'subject:that': 0.31; 'running': 0.33; 'guess': 0.33; 'subject:the': 0.34; 'but': 0.35; 'version': 0.36; 'hi,': 0.36; 'error.': 0.37; 'server': 0.38; 'to:addr:python-list': 0.38; 'delete': 0.39; 'to:addr:python.org': 0.39; 'email addr:gmail.com': 0.63; 'show': 0.63; 'kind': 0.63; 'more': 0.64; 'subject:your': 0.76; 'subject:have': 0.80; 'subject:SQL': 0.84; 'subject:check': 0.84; 'cause,': 0.91; 'subject:NEW': 0.91
X-CM-Score	0.00
X-CNFS-Analysis	v=2.1 cv=eZmzft0H c=1 sm=1 tr=0 a=0nF1XD0wxitMEM03M9B4ZQ==:117 a=0nF1XD0wxitMEM03M9B4ZQ==:17 a=0Bzu9jTXAAAA:8 a=sASEtNAQL0YA:10 a=uSAaYV4nxT4A:10 a=ihvODaAuJD4A:10 a=IkcTkHD0fZMA:10 a=EBOSESyhAAAA:8 a=VUHZfU-Y8wIA:10 a=pGLkceISAAAA:8 a=MiRwCdLlAAAA:8 a=oHq73YnqWjir1SY-OZsA:9 a=QEXdDO2ut3YA:10 a=oWbdKwIwHEsA:10 a=MSl-tDqOz04A:10
X-AUTH	mrabarnett:2500
Date	Tue, 25 Feb 2014 18:10:47 +0000
From	MRAB <python@mrabarnett.plus.com>
User-Agent	Mozilla/5.0 (Windows NT 6.3; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.3.0
MIME-Version	1.0
To	python-list@python.org
Subject	Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1")
References	<6b73a879-b490-48cb-a896-4d4abee90bf5@googlegroups.com> <84e95932-524c-474e-8a9d-052b08611bc5@googlegroups.com>
In-Reply-To	<84e95932-524c-474e-8a9d-052b08611bc5@googlegroups.com>
Content-Type	text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding	7bit
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.7357.1393351858.18130.python-list@python.org> (permalink)
Lines	13
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1393351858 news.xs4all.nl 2920 [2001:888:2000:d::a6]:53471
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:67047

Show key headers only | View raw

On 2014-02-25 17:37, nowebdevmyrrh@gmail.com wrote:
> HI, I'm also getting this kind of error.
>
> This will show when I do the edit function
> http://screencast.com/t/hGSbe1vt
>
> and this when performing the delete
> "Error: 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 '' at line 1"
>
> What confused me more is that my website works fine on my live server and will only throws error when running on my wampserver.
>
It might have the same cause, but that's just a guess because you
haven't provided much information.

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Jai <jaiprakashsingh213@gmail.com> - 2013-12-09 00:41 -0800
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Daniel Watkins <daniel@daniel-watkins.co.uk> - 2013-12-09 09:32 +0000
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Chris Angelico <rosuav@gmail.com> - 2013-12-09 20:36 +1100
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") MRAB <python@mrabarnett.plus.com> - 2013-12-09 18:06 +0000
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Dan Stromberg <drsalists@gmail.com> - 2013-12-10 08:23 -0800
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") Chris Angelico <rosuav@gmail.com> - 2013-12-11 03:28 +1100
  Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") nowebdevmyrrh@gmail.com - 2014-02-25 09:37 -0800
    Re: ProgrammingError: (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 'S SIZE 11.5 NEW IN BOX', '$49.99')' at line 1") MRAB <python@mrabarnett.plus.com> - 2014-02-25 18:10 +0000

csiph-web