Re: What causes this error, and how do i fix it?

#x27;mysql' by default) should have enough permissions on that dir. > > Best regards > Søren > > -Original Message- > From: Egor Egorov [mailto:[EMAIL PROTECTED] > Sent: 18. marts 2004 14:15 > To: [EMAIL PROTECTED] > Subject: Re: What causes this error, a

Re: What causes this error, and how do i fix it?

S?ren Neigaard <[EMAIL PROTECTED]> wrote: > The following SQL (bugzilla): > > SELECT = > products.product,description,disallownew,votesperuser,maxvotesperbug,vote= > stoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON = > products.product=3Dbugs.product GROUP BY products.product ORDER BY = >

RE: What causes this error, and how do i fix it?

EMAIL PROTECTED] Objet : What causes this error, and how do i fix it? The following SQL (bugzilla): SELECT products.product,description,disallownew,votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON products.product=bugs.product GROUP BY products.product ORD

What causes this error, and how do i fix it?

The following SQL (bugzilla): SELECT products.product,description,disallownew,votesperuser,maxvotesperbug,votestoconfirm,COUNT(bug_id) FROM products LEFT JOIN bugs ON products.product=bugs.product GROUP BY products.product ORDER BY products.product; Causes this error: ERROR 1: Can't create/w

RE: what causes this error

Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Pflugmann Sent: Thursday, May 30, 2002 6:19 PM To: [EMAIL PROTECTED] Cc: 'mysql'; 'Myk Melez' Subject: Re: what causes this error Hi. Okay, now the problem is clear. mysqladmin 3.23.3

Re: what causes this error

Hi. Okay, now the problem is clear. mysqladmin 3.23.37 uses backticks (`) around the database names (as you can see in the error message you quoted) to support special chars therein, but backticks for quoting column/table/database names where only intrudcued in 3.23.6, so the 3.22.32 server doesn

RE: what causes this error

o:[EMAIL PROTECTED]] On Behalf Of Benjamin Pflugmann Sent: Thursday, May 30, 2002 5:39 PM To: [EMAIL PROTECTED] Subject: Re: what causes this error Hi. You missed the output of "mysqladmin version" (that will print the server version). Could you please post it in the thread to the MySQL li

RE: what causes this error

y the lamest suggestion at this point. Thanks, Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Benjamin Pflugmann Sent: Thursday, May 30, 2002 4:52 PM To: [EMAIL PROTECTED] Cc: 'Myk Melez'; 'mysql' Subject: Re: what causes this e

Re: what causes this error

Hi. This works fine for me. What is the output of mysqladmin -V mysqladmin version ? Bye, Benjamin. On Thu, May 30, 2002 at 03:09:11PM -0700, [EMAIL PROTECTED] wrote: > mysqladmin create test2 > mysqladmin: CREATE DATABASE failed; error: 'You have an error in your > SQL syntax near

RE: what causes this error

mysqladmin create test2 mysqladmin: CREATE DATABASE failed; error: 'You have an error in your SQL syntax near '`test2`' at line 1' -Original Message- From: Myk Melez [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 30, 2002 2:59 PM To: [EMAIL PROTECTED] Cc: mysql Subj

Re: what causes this error

Justin, The error message states that you have a syntax error in the CREATE DATABASE statement. This is probably just a typo, but the only way for us to diagnose the problem is for you to post the exact statement that gives you the error. -myk justin cunningham wrote: >mysqladmin: CREATE

what causes this error

mysqladmin: CREATE DATABASE failed; error: 'You have an error in your SQL syntax near 'whateverunamethedatabase' I can complete every function with msyqladmin except create and drop. What am I doing wrong. I've read all the docs online, sent similar emails with no response. This is not an acce