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

2004-03-18 Thread Egor Egorov
#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?

2004-03-18 Thread Egor Egorov
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?

2004-03-18 Thread Mechain Marc
May be Unix acces permissions on /root/tmp (Errcode: 13) = EACCES Permission denied Like you are using an ORDER BY, mysql needs some temporary space to do the order. Marc. -Message d'origine- De : Søren Neigaard [mailto:[EMAIL PROTECTED] Envoyé : jeudi 18 mars 2004 13:29 À : [EMAIL PROT

RE: what causes this error

2002-05-30 Thread justin cunningham
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

2002-05-30 Thread Benjamin Pflugmann
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

2002-05-30 Thread justin cunningham
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

2002-05-30 Thread justin cunningham
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

2002-05-30 Thread Benjamin Pflugmann
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

2002-05-30 Thread justin cunningham
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

2002-05-30 Thread Myk Melez
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