Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #2275 > unrolled thread

insert query error

Back to article view | Back to comp.lang.php

Contents

  insert query error anu <anucherkuri@gmail.com> - 2011-06-21 07:43 -0700
    Re: insert query error Luuk <Luuk@invalid.lan> - 2011-06-21 16:49 +0200
    Re: insert query error "Álvaro G. Vicario" <alvaro.NOSPAMTHANX@demogracia.com.invalid> - 2011-06-21 18:54 +0200
    Re: insert query error Bill B <me@privacy.net> - 2011-06-21 13:19 -0400
    Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-21 15:48 -0400
      Re: insert query error Bill B <me@privacy.net> - 2011-06-21 15:58 -0400
        Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-21 22:15 -0400
      Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 12:04 +0200
        Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 06:38 -0400
          Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 17:03 +0200
            Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 15:34 +0000
              Re: insert query error Jonathan Stein <jstein@image.dk> - 2011-06-22 21:54 +0200
                Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 21:44 +0000
            Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 12:08 -0400
              Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-22 21:46 +0000
                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-22 23:23 -0400
                  Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 11:38 +0000
                    Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 08:41 -0400
                      Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 13:34 +0000
                        Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 12:45 -0400
                          Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 17:51 +0000
                            Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 15:04 -0400
                              Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 20:32 +0000
                                Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 19:23 -0400
                                  Re: insert query error dougatmilmacdotcom@example.com (Doug Miller) - 2011-06-23 23:33 +0000
                                    Re: insert query error Jerry Stuckle <jstucklex@attglobal.net> - 2011-06-23 22:23 -0400
                  Re: insert query error Luuk <Luuk@invalid.lan> - 2011-06-23 20:39 +0200

Page 1 of 2  [1] 2  Next page →

#2275 — insert query error

I have a simple insert query in PHP wherein I am trying to write a
record to a MySql database. This is giving me the following Mysql
error. Can you tell me what could  be the cause for  this error and
how I can rectify it.

Could not successfully run insert query :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 2

Anu

[toc] | [next] | [standalone]

#2276

On 21-06-2011 16:43, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could  be the cause for  this error and
> how I can rectify it.
> 
> Could not successfully run insert query :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 2
> 
> Anu

my crystal ball says:
wrong (too manu, or too few) quotes

But too few info to know for sure.......

-- 
Luuk

[toc] | [prev] | [next] | [standalone]

#2278

El 21/06/2011 16:43, anu escribió/wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could  be the cause for  this error and
> how I can rectify it.
>
> Could not successfully run insert query :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 2

The cause of this error message is a syntax error in your SQL code. You 
can rectify it by fixing the wrong syntax in your query.


-- 
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

[toc] | [prev] | [next] | [standalone]

#2279

On 6/21/2011 10:43 AM, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could  be the cause for  this error and
> how I can rectify it.
>
> Could not successfully run insert query :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 2
>
> Anu

What is the syntax of the actual INSERT query?

[toc] | [prev] | [next] | [standalone]

#2280

On 6/21/2011 10:43 AM, anu wrote:
> I have a simple insert query in PHP wherein I am trying to write a
> record to a MySql database. This is giving me the following Mysql
> error. Can you tell me what could  be the cause for  this error and
> how I can rectify it.
>
> Could not successfully run insert query :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 2
>
> Anu

You have a MySQL message - ask in a MySQL newsgroup, such as 
comp.databases.mysql.

This isn't a PHP problem.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2281

On 6/21/2011 3:48 PM, Jerry Stuckle wrote:
> On 6/21/2011 10:43 AM, anu wrote:
>> I have a simple insert query in PHP wherein I am trying to write a
>> record to a MySql database. This is giving me the following Mysql
>> error. Can you tell me what could be the cause for this error and
>> how I can rectify it.
>>
>> Could not successfully run insert query :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 2
>>
>> Anu
>
> You have a MySQL message - ask in a MySQL newsgroup, such as
> comp.databases.mysql.
>
> This isn't a PHP problem.

Even if it shows up in a PHP error log? If I correctly recall, some time 
ago you admonished me (correctly I think) to search Google using "PHP 
[error message]."

Bill B

[toc] | [prev] | [next] | [standalone]

#2283

On 6/21/2011 3:58 PM, Bill B wrote:
> On 6/21/2011 3:48 PM, Jerry Stuckle wrote:
>> On 6/21/2011 10:43 AM, anu wrote:
>>> I have a simple insert query in PHP wherein I am trying to write a
>>> record to a MySql database. This is giving me the following Mysql
>>> error. Can you tell me what could be the cause for this error and
>>> how I can rectify it.
>>>
>>> Could not successfully run insert query :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 2
>>>
>>> Anu
>>
>> You have a MySQL message - ask in a MySQL newsgroup, such as
>> comp.databases.mysql.
>>
>> This isn't a PHP problem.
>
> Even if it shows up in a PHP error log? If I correctly recall, some time
> ago you admonished me (correctly I think) to search Google using "PHP
> [error message]."
>
> Bill B

It's a MySQL message.  PHP knows nothing about SQL.

Just because some application error shows up in the Windows log, should 
you ask in a Windows newsgroup?

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2287

Den 21-06-2011 21:48, Jerry Stuckle skrev:

>> Could not successfully run insert query :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 2
>
> You have a MySQL message - ask in a MySQL newsgroup, such as
> comp.databases.mysql.

Why bother a MySQL group? - They won't be able to help from the message.

The solution is to:

1. Add PHP code to print the SQL statement. (PHP task)

2. Realize where the missing or extra ' is. (SQL task - but after step 
1, the poster probably won't need help for this step)

3. Fix the PHP code to generate a valid statement. (PHP task)

> This isn't a PHP problem.

We could discuss this, but the solution involves more PHP than SQL, so 
this group is fine for the question. The poster should just have 
included the code generating the SQL query.

   Regards

     Jonathan

[toc] | [prev] | [next] | [standalone]

#2289

On 6/22/2011 6:04 AM, Jonathan Stein wrote:
> Den 21-06-2011 21:48, Jerry Stuckle skrev:
>
>>> Could not successfully run insert query :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 2
>>
>> You have a MySQL message - ask in a MySQL newsgroup, such as
>> comp.databases.mysql.
>
> Why bother a MySQL group? - They won't be able to help from the message.
>

Because they will be able to help from the message.  And they will give 
a GOOD answer.

> The solution is to:
>
> 1. Add PHP code to print the SQL statement. (PHP task)
>
> 2. Realize where the missing or extra ' is. (SQL task - but after step
> 1, the poster probably won't need help for this step)
>
> 3. Fix the PHP code to generate a valid statement. (PHP task)
>
>> This isn't a PHP problem.
>
> We could discuss this, but the solution involves more PHP than SQL, so
> this group is fine for the question. The poster should just have
> included the code generating the SQL query.
>
> Regards
>
> Jonathan

The problem is MySQL.  Ask in the correct newsgroup, and you'll get a 
good answer.  Ask in the wrong newsgroup and you'll get a crap answer - 
like the above.


-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2293

Den 22-06-2011 12:38, Jerry Stuckle skrev:

>> Why bother a MySQL group? - They won't be able to help from the message.
>
> Because they will be able to help from the message.

Do they have better crystal balls than we have?

If you insist, that the question belongs to a MySQL group, at least 
guide the user to post the entire SQL statement causing the error. (But 
then we are back to a PHP question).
Having the user asking the same question in another group is just a 
waste of everybody's time.

   Regards

     Jonathan

[toc] | [prev] | [next] | [standalone]

#2294

In article <4e0203bd$0$315$14726298@news.sunsite.dk>, jstein@image.dk wrote:
>Den 22-06-2011 12:38, Jerry Stuckle skrev:
>
>>> Why bother a MySQL group? - They won't be able to help from the message.
>>
>> Because they will be able to help from the message.
>
>Do they have better crystal balls than we have?
>
>If you insist, that the question belongs to a MySQL group, at least 
>guide the user to post the entire SQL statement causing the error. (But 
>then we are back to a PHP question).
>Having the user asking the same question in another group is just a 
>waste of everybody's time.

It seems to me that the best answer is

"Modify your PHP script so that it displays the entire SQL command. If, after 
looking at that, you still don't understand what's wrong with it, ask in 
comp.databases.mysql, not here."

[toc] | [prev] | [next] | [standalone]

#2300

Den 22-06-2011 17:34, Doug Miller skrev:

> It seems to me that the best answer is
>
> "Modify your PHP script so that it displays the entire SQL command. If, after
> looking at that, you still don't understand what's wrong with it, ask in
> comp.databases.mysql, not here."

That would be a brilliant answer. I might add: "If your SQL statement 
does not look as you expect it to, try posting the code that generates it".

   Regards

     Jonathan

[toc] | [prev] | [next] | [standalone]

#2301

In article <4e0247dc$0$305$14726298@news.sunsite.dk>, jstein@image.dk wrote:
>Den 22-06-2011 17:34, Doug Miller skrev:
>
>> It seems to me that the best answer is
>>
>> "Modify your PHP script so that it displays the entire SQL command. If, after
>> looking at that, you still don't understand what's wrong with it, ask in
>> comp.databases.mysql, not here."
>
>That would be a brilliant answer. I might add: "If your SQL statement 
>does not look as you expect it to, try posting the code that generates it".

And: "If you don't know how to modify your PHP script so that it displays the 
entire SQL command, *that* question is on-topic here."

[toc] | [prev] | [next] | [standalone]

#2296

On 6/22/2011 11:03 AM, Jonathan Stein wrote:
> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>
>>> Why bother a MySQL group? - They won't be able to help from the message.
>>
>> Because they will be able to help from the message.
>
> Do they have better crystal balls than we have?
>

No, but then they know SQL and will be able to spot the error.

> If you insist, that the question belongs to a MySQL group, at least
> guide the user to post the entire SQL statement causing the error. (But
> then we are back to a PHP question).
> Having the user asking the same question in another group is just a
> waste of everybody's time.
>
> Regards
>
> Jonathan



-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2302

In article <itt42d$pfe$1@dont-email.me>, Jerry Stuckle <jstucklex@attglobal.net> wrote:
>On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>
>>>> Why bother a MySQL group? - They won't be able to help from the message.
>>>
>>> Because they will be able to help from the message.
>>
>> Do they have better crystal balls than we have?
>>
>
>No, but then they know SQL and will be able to spot the error.

Not from the fragment of query that the OP posted, they won't.

[toc] | [prev] | [next] | [standalone]

#2303

On 6/22/2011 5:46 PM, Doug Miller wrote:
> In article<itt42d$pfe$1@dont-email.me>, Jerry Stuckle<jstucklex@attglobal.net>  wrote:
>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>
>>>>> Why bother a MySQL group? - They won't be able to help from the message.
>>>>
>>>> Because they will be able to help from the message.
>>>
>>> Do they have better crystal balls than we have?
>>>
>>
>> No, but then they know SQL and will be able to spot the error.
>
> Not from the fragment of query that the OP posted, they won't.

You'd be surprised how much a *competent* MySQL programmer knows!

Unlike most of the MySQL hackers in this newsgroup....

Ask in the right place, you get a good answer.  Ask in the wrong place 
and you get a crap answer, as is shown here (over and over).

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2309

In article <itubj7$rdl$1@dont-email.me>, Jerry Stuckle <jstucklex@attglobal.net> wrote:
>On 6/22/2011 5:46 PM, Doug Miller wrote:
>> In article<itt42d$pfe$1@dont-email.me>, Jerry
> Stuckle<jstucklex@attglobal.net>  wrote:
>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>>
>>>>>> Why bother a MySQL group? - They won't be able to help from the message.
>>>>>
>>>>> Because they will be able to help from the message.
>>>>
>>>> Do they have better crystal balls than we have?
>>>>
>>>
>>> No, but then they know SQL and will be able to spot the error.
>>
>> Not from the fragment of query that the OP posted, they won't.
>
>You'd be surprised how much a *competent* MySQL programmer knows!

Enough to pinpoint the cause of the problem, from the small fragment posted by 
the OP? Yeah, riiiiiight. 

[toc] | [prev] | [next] | [standalone]

#2310

On 6/23/2011 7:38 AM, Doug Miller wrote:
> In article<itubj7$rdl$1@dont-email.me>, Jerry Stuckle<jstucklex@attglobal.net>  wrote:
>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>> In article<itt42d$pfe$1@dont-email.me>, Jerry
>> Stuckle<jstucklex@attglobal.net>   wrote:
>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>>>
>>>>>>> Why bother a MySQL group? - They won't be able to help from the message.
>>>>>>
>>>>>> Because they will be able to help from the message.
>>>>>
>>>>> Do they have better crystal balls than we have?
>>>>>
>>>>
>>>> No, but then they know SQL and will be able to spot the error.
>>>
>>> Not from the fragment of query that the OP posted, they won't.
>>
>> You'd be surprised how much a *competent* MySQL programmer knows!
>
> Enough to pinpoint the cause of the problem, from the small fragment posted by
> the OP? Yeah, riiiiiight.

Better able to pinpoint the problem than you are, obviously.  And if 
they know more information, they should ask for what they need.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

#2311

In article <itvc98$d2b$1@dont-email.me>, Jerry Stuckle <jstucklex@attglobal.net> wrote:
>On 6/23/2011 7:38 AM, Doug Miller wrote:
>> In article<itubj7$rdl$1@dont-email.me>, Jerry
> Stuckle<jstucklex@attglobal.net>  wrote:
>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>> In article<itt42d$pfe$1@dont-email.me>, Jerry
>>> Stuckle<jstucklex@attglobal.net>   wrote:
>>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>>>>
>>>>>>>> Why bother a MySQL group? - They won't be able to help from the
> message.
>>>>>>>
>>>>>>> Because they will be able to help from the message.
>>>>>>
>>>>>> Do they have better crystal balls than we have?
>>>>>>
>>>>>
>>>>> No, but then they know SQL and will be able to spot the error.
>>>>
>>>> Not from the fragment of query that the OP posted, they won't.
>>>
>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>
>> Enough to pinpoint the cause of the problem, from the small fragment posted
> by
>> the OP? Yeah, riiiiiight.
>
>Better able to pinpoint the problem than you are, obviously.  And if 
>they know more information, they should ask for what they need.
>
Since you're so smart, then, why don't you tell us exactly where the problem 
is?

[toc] | [prev] | [next] | [standalone]

#2318

On 6/23/2011 9:34 AM, Doug Miller wrote:
> In article<itvc98$d2b$1@dont-email.me>, Jerry Stuckle<jstucklex@attglobal.net>  wrote:
>> On 6/23/2011 7:38 AM, Doug Miller wrote:
>>> In article<itubj7$rdl$1@dont-email.me>, Jerry
>> Stuckle<jstucklex@attglobal.net>   wrote:
>>>> On 6/22/2011 5:46 PM, Doug Miller wrote:
>>>>> In article<itt42d$pfe$1@dont-email.me>, Jerry
>>>> Stuckle<jstucklex@attglobal.net>    wrote:
>>>>>> On 6/22/2011 11:03 AM, Jonathan Stein wrote:
>>>>>>> Den 22-06-2011 12:38, Jerry Stuckle skrev:
>>>>>>>
>>>>>>>>> Why bother a MySQL group? - They won't be able to help from the
>> message.
>>>>>>>>
>>>>>>>> Because they will be able to help from the message.
>>>>>>>
>>>>>>> Do they have better crystal balls than we have?
>>>>>>>
>>>>>>
>>>>>> No, but then they know SQL and will be able to spot the error.
>>>>>
>>>>> Not from the fragment of query that the OP posted, they won't.
>>>>
>>>> You'd be surprised how much a *competent* MySQL programmer knows!
>>>
>>> Enough to pinpoint the cause of the problem, from the small fragment posted
>> by
>>> the OP? Yeah, riiiiiight.
>>
>> Better able to pinpoint the problem than you are, obviously.  And if
>> they know more information, they should ask for what they need.
>>
> Since you're so smart, then, why don't you tell us exactly where the problem
> is?

As I've said.  It's off-topic in this newsgroup.

-- 
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[toc] | [prev] | [next] | [standalone]

Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.php

csiph-web