Got It; Thank You; Re: Mysql Bug 04/01/11

2011-04-02 Thread Thomas Dineen
Got It; Thank You, Thank You, Thank You On 4/1/2011 11:28 PM, Claudio Nanni wrote: Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, "Thomas Dineen" > wrote:

Re: Mysql Bug 04/01/11

2011-04-02 Thread Reindl Harald
Am 02.04.2011 13:11, schrieb Claudio Nanni: > Reindl Harald, > > I would appreciate if you could please lower your tones. > and keep this list as professional as it has always been, this is not a > nerds forum. > > *Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't > find

Re: Mysql Bug 04/01/11: http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

2011-04-02 Thread Reindl Harald
Am 02.04.2011 02:18, schrieb Thomas Dineen: > The following error occurs: > 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: > './mysql/host.frm' (errno: 13) BTW: you know google? "Can't find file: './mysql/host.frm' (errno: 13)" http://bugs.mysql.com/bug.php?id=1279

Re: Mysql Bug 04/01/11

2011-04-02 Thread Claudio Nanni
Reindl Harald, I would appreciate if you could please lower your tones. and keep this list as professional as it has always been, this is not a nerds forum. There is always someone that knows more than you but he's not "shouting" at you everytime you say something wrong. If you think that a questi

Re: Mysql Bug 04/01/11

2011-04-02 Thread Reindl Harald
Am 02.04.2011 02:18, schrieb Thomas Dineen: >> Gentlemen: >> >> - Keep in mind that I have approximately 50 hours into this Mysql server >> install and still no >> results! what have you done the whole time? have you tried RTFM? we are not here to guide a blind one trough a basic setup becaus

Re: Mysql Bug 04/01/11

2011-04-01 Thread Jigal van Hemert
Hi, On 2-4-2011 2:18, Thomas Dineen wrote: Can't find file: './mysql/host.frm' (errno: 13) http://tinyurl.com/3sc3ydx -- Kind regards / met vriendelijke groet, Jigal van Hemert. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mys

Re: Mysql Bug 04/01/11

2011-04-01 Thread Claudio Nanni
Hi Thomas, Did you run the post install script? http://kae.li/iiikj Claudio On Apr 2, 2011 2:20 AM, "Thomas Dineen" wrote:

Mysql Bug 04/01/11

2011-04-01 Thread Thomas Dineen
Gentlemen: - Keep in mind that I have approximately 50 hours into this Mysql server install and still no results! - Regarding the Sun Freeware package mysql-5.0.67-sol10-x86-local.gz - When installed and started with the following command: /usr/local/mysql/bin/mysqld_safe --user=mysql & The

Re: LIKE problem with characters 'å' (norwe gian) and 'a' (mysql bug?)

2008-02-29 Thread Kent Larsson
> I get incorrect result when searching for the norwegian character 'å' > using LIKE. I get rows with 'a' in it, and visa versa if I search for > 'a', I get results which has 'å' in it in addition to the ones with 'a'. Make sure that your table has: charset=utf8 collation=utf8_norwegian_ci A

LIKE problem with characters 'å' (norwe gian) and 'a' (mysql bug?)

2008-02-28 Thread Magne Westlie
;%ø%'; +--+ | name | +--+ | Bør | +--+ I found that I may use mysql> SELECT * FROM names WHERE LOWER(name) LIKE BINARY LOWER('%å%'); which returns correct results, but this disables me from letting the user do case sensitive searches. Am I doing something wrong o

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
AIL PROTECTED]> wrote: > Thanks; you're absolutely right - doh! It's just amazing that this ever > worked in MySQL 4.0 and below... > > Andrew > > -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED] > Sent: Mon, 19 Sep 2005 12:27 > To:

RE: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
Thanks; you're absolutely right - doh! It's just amazing that this ever worked in MySQL 4.0 and below... Andrew -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Mon, 19 Sep 2005 12:27 To: mysql@lists.mysql.com Cc: Andrew Braithwaite Subject: Re: possible

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Roger Baklund
Andrew Braithwaite wrote: Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. [...] | lon | double(7,6) | YES | MUL | NULL|

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Martijn Tonies
Hello Andrew, > I have a strange error when trying to insert into a table with 2 > 'double' fields. It inserts into the 1st field OK but fills the 2nd one > with nines. See below for a complete recreate. > > Is this a known problem? Does anyone have a solution? > > I'm running standard MySQL bi

possible MySQL bug - insert into 'double' column problem with mysql 4.1

2005-09-19 Thread Andrew Braithwaite
Hi All, I have a strange error when trying to insert into a table with 2 'double' fields. It inserts into the 1st field OK but fills the 2nd one with nines. See below for a complete recreate. Is this a known problem? Does anyone have a solution? I'm running standard MySQL binaries on redhat l

Re: mySQL Bug Report

2005-08-02 Thread Gleb Paharenko
Hello. I don't know the relationships between program articlebot and MySQL. But error message tells me to ask you to check if you have MyODBC properly configured and whether your MySQL server is running. See: http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html There is

mySQL Bug Report

2005-08-02 Thread Kari White
After installing mySQL along with a program called articlebot, I tried to run the application and I keep getting this message: "An unhandled exception has occurred in a component in your application. Click continue and application will ignore this error and attempt to continue. ERROR [HY000

Re: mysql bug 9670 OPTIMIZE TABLE crashes

2005-08-02 Thread Matthijs van der Klip
On Mon, 1 Aug 2005, Heikki Tuuri wrote: > unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and > later. Hi Heikki, Thanks for your response. The fix seems to consists only of a few lines: http://mysql.bkbits.net:8080/mysql-4.1/[EMAIL PROTECTED]|[EMAIL PROTECTED] It look

Re: mysql bug 9670 OPTIMIZE TABLE crashes

2005-08-01 Thread Heikki Tuuri
;; <[EMAIL PROTECTED]> Lähetetty: Monday, August 01, 2005 5:08 PM Aihe: mysql bug 9670 OPTIMIZE TABLE crashes Hi, I am experiencing assertion failures described in the following bugreport: http://bugs.mysql.com/bug.php?id=9670 The bug has been closed, but I'm running the most

Re: mysql bug 9670 OPTIMIZE TABLE crashes

2005-08-01 Thread Matthijs van der Klip
On Mon, 1 Aug 2005, Mikhail Entaltsev wrote: > in the bug report Heikki Tuuri wrote: > *** > [13 Apr 20:59] Heikki Tuuri > The bug was introduced in 4.0.24 and 4.1.10. The fix will be in 4.1.12 and > 5.0.5. > *** Hi Mikhail, Thank you for your quick response. I had noticed myself that the fix s

Re: mysql bug 9670 OPTIMIZE TABLE crashes

2005-08-01 Thread Mikhail Entaltsev
ot;MySQL mailing list" Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, August 01, 2005 4:08 PM Subject: mysql bug 9670 OPTIMIZE TABLE crashes > Hi, > > I am experiencing assertion failures described in the following bugreport: > > http://bugs.mysql.com/b

mysql bug 9670 OPTIMIZE TABLE crashes

2005-08-01 Thread Matthijs van der Klip
Hi, I am experiencing assertion failures described in the following bugreport: http://bugs.mysql.com/bug.php?id=9670 The bug has been closed, but I'm running the most current 4.0.25 version of MySQL. The report mentions downgrading to 4.0.23 or upgrading to 4.1. Is this really neccessary or s

Re: mysql bug

2005-07-27 Thread Gleb Paharenko
Hello. Have you been at: http://dev.mysql.com/doc/mysql/en/starting-server.html Check the error log: http://dev.mysql.com/doc/mysql/en/error-log.html Maurizio Dudine <[EMAIL PROTECTED]> wrote: > SEND-PR: -*- send-pr -*- > SEND-PR: Lines starting with `SEND-PR' will be removed

mysql bug

2005-07-21 Thread Maurizio Dudine
SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `<' and `>'). SEND-PR: From: maurizio To: mysql@lists.mysql.com Subject: [Cannot start mysql] >Description: <1. I have installed the six packages (

RE: Mysql bug

2003-09-10 Thread Dathan Vance Pattishall
Not a bug look /etc/my.cnf Your default sock file might be in /tmp and the client is configure to look at /var/lib/mysql -->-Original Message- -->From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, September 09, 2003 2:08 PM -->To: [EMAIL PROTECTED] -->Sub

Mysql bug

2003-09-10 Thread denisq
Hello, I can't connect to mysql, the message is : "can't connect problem with /var/lib/mysql.sock" or something like that (sorry i forgot to write it and actually also have problems to connect with ADSL to internet under Linux so i send you this from windows). Can you help me ? Thanks. SE

Re: mysql BUG, again ;)

2003-07-29 Thread Boyd Lynn Gerber
On Tue, 29 Jul 2003, Dyego Souza do Carmo wrote: > >I would like to know if you could fix the bug I reported to you >some days ago. > >The error is: "ERROR 1030: Got error 139 from table handler" after >running an update command using several blobs. > >Now I am using mySql 4.0.1

Re: mysql BUG, again ;)

2003-07-29 Thread Heikki Tuuri
rds, Heikki .... Subject: mysql BUG, again ;) From: Dyego Souza do Carmo Date: Tue, 29 Jul 2003 09:40:17 -0300 Hi, I would like to know if you could fix the bug I reported to you some days ago. The error is: "ERROR 1030: Got error 139 from table handler" after running a

mysql BUG, again ;)

2003-07-29 Thread Dyego Souza do Carmo
Hi, I would like to know if you could fix the bug I reported to you some days ago. The error is: "ERROR 1030: Got error 139 from table handler" after running an update command using several blobs. Now I am using mySql 4.0.15 and Linux. If you try to do the same with mySql 4.0.1

Re: The MySQL Bug ?

2003-07-21 Thread Heikki Tuuri
Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, July 21, 2003 9:14 PM Subject: The MySQL Bug ? > Hi, > >I'd found a bug when I'd tried to use blob fields and innoDb. >To see the bug, do the follow: > &g

The MySQL Bug ?

2003-07-21 Thread Dyego Souza do Carmo
Hi, I'd found a bug when I'd tried to use blob fields and innoDb. To see the bug, do the follow: *) Create a database. *) Import the dump file that is attached to this e-mail. (cfgimpressao.dump) *) Use the following commands: select Ci_Descricao from cfgimpressao;

Re: Re[2]: mySql BUG

2003-06-11 Thread Sinisa Milivojevic
Dyego Souza do Carmo writes: > Sinisa: > > Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: > > ---[inicio]-- > > > > The FileName is l5.zip > > > ---[cortar]-- > > > >

Re[2]: mySql BUG

2003-06-11 Thread Dyego Souza do Carmo
Sinisa: Wednesday, June 11, 2003, 2:16:16 PM, você escreveu: ---[inicio]-- SM> Hi! SM> Your attachment was stripped off. SM> Please upload it to: SM> ftp://support.mysql.com:/pub/mysql/secret SM> and let us know it's filename. The FileName is l5.zip -

Re: mySql BUG

2003-06-11 Thread Sinisa Milivojevic
Dyego Souza do Carmo writes: > Hi, > > > Try to do the following: > [skip] > > > - > ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento > ---

mySql BUG

2003-06-11 Thread Dyego Souza do Carmo
Hi, Try to do the following: *) Import the dump file I sent to you attached to this e-mail. There is a table called l5 and some data in the dump file. *) run the command: select conjuge.l5_nome from l5 as conjuge, l5 as parte where parte.l5_parte = 8 and parte.l5_seq = 0 and conjuge.l5_parte =

Re: mysql: bug in update (?)

2003-06-08 Thread Paul DuBois
At 14:51 +0300 6/8/03, Dmitry Kosoy wrote: Hi, I have a table with 2 fields (among others) with type timestamp ("warndate" and "date"). I run the following update: update dbowner where warndate = now(). This update affects not only on the field "warndate" but on the field "date" as well. After it

FW: MySQL: bug in update (?)

2003-06-08 Thread Dmitry Kosoy
Sorry, Now I understood that this behavior is exactly according to documentation. -Original Message- Subject: mysql: bug in update (?) Hi, I have a table with 2 fields (among others) with type timestamp ("warndate" and "date"). I run the following update: update db

Re: mysql: bug in update (?)

2003-06-08 Thread O'K Web Design
t; <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: June 8, 2003 7:51 AM Subject: mysql: bug in update (?) > > Hi, > > I have a table with 2 fields (among others) with type timestamp ("warndate" > and "date"). > I run the following update: update db

mysql: bug in update (?)

2003-06-08 Thread Dmitry Kosoy
Hi, I have a table with 2 fields (among others) with type timestamp ("warndate" and "date"). I run the following update: update dbowner where warndate = now(). This update affects not only on the field "warndate" but on the field "date" as well. After it the both fields got the current date and t

Re: Mysql Bug Database

2003-02-21 Thread Sunil Gavaskar
Mysql Bug Database. I tried a lot in google...but not yet got it. somebody send me the link plz... There is no bugs tracking database for MySQL. - Before posting, please check: http://www.mysql.com/manual.php

re: Mysql Bug Database

2003-02-21 Thread Egor Egorov
On Thursday 20 February 2003 17:39, Sunil Gavaskar wrote: > I need to know the link for Mysql Bug Database. > I tried a lot in google...but not yet got it. > somebody send me the link plz... There is no bugs tracking database for MySQL. -- For technical support contracts, g

Re: Mysql Bug Database

2003-02-20 Thread Sunil Gavaskar
hi, can u just mail me the link that i asked for... thanks regards sunil gavaskar Sunil Gavaskar wrote: Hello, I need to know the link for Mysql Bug Database. I tried a lot in google...but not yet got it. somebody send me the link plz... Thanks a lot in advance regards sunil gavaskar

Mysql Bug Database

2003-02-20 Thread Sunil Gavaskar
Hello, I need to know the link for Mysql Bug Database. I tried a lot in google...but not yet got it. somebody send me the link plz... Thanks a lot in advance regards sunil gavaskar - Before posting, please check: http

Re: [PHP] Re: PHP and MySQL bug

2003-01-08 Thread Nuno Lopes
QL List" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 4:12 PM Subject: RE: [PHP] Re: PHP and MySQL bug > Since nobody is jumping in to say it is some simple configuration/setting > personally my next step would be to shut down all services on the box that > aren't absol

Re: [PHP] Re: PHP and MySQL bug

2003-01-08 Thread Nuno Lopes
t;MySQL List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 5:06 PM Subject: Re: [PHP] Re: PHP and MySQL bug > @mysql_select_db("be"); -- this failed > do echo mysql_error(); to see what went wrong > > > > Nuno Lopes wrote: > &

RE: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Larry Brown
* Try add to /etc/hosts the name and ip of DB is located >> I'm using Windows 2000. In Windows2000 make the same changes in winnt/system32/drivers/etc/hosts. If it connects the first time and every time thereafter that you recreate the connection it should not be anything to do with resolving the

RE: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Christensen, Dave
bug I'm using Windows 2000. - Original Message - From: "Cleber" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 10:23 AM Subject: Re: [PHP] Re: PHP and MySQL bug > Try add to /etc/hosts the name and

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Nuno Lopes
I'm using Windows 2000. - Original Message - From: "Cleber" <[EMAIL PROTECTED]> To: "Nuno Lopes" <[EMAIL PROTECTED]> Sent: Tuesday, January 07, 2003 10:23 AM Subject: Re: [PHP] Re: PHP and MySQL bug > Try add to /etc/hosts the name and ip of DB

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Marek Kilimajer
'no db was selected') - Original Message - From: "David Freeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 10:29 PM Subject: RE: [PHP] Re: PHP and MySQL bug > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id=

RE: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Larry Brown
From: Nuno Lopes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 4:31 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] Re: PHP and MySQL bug I have the latest version of PHP (4.3.0) as module in apache 2.0.43 and mysql 3.23.49. Everything is working fine, except this. With pc

Re: [PHP] Re: PHP and MySQL bug

2003-01-07 Thread Nuno Lopes
ED]> Sent: Monday, January 06, 2003 6:28 PM Subject: RE: [PHP] Re: PHP and MySQL bug > This definitely sounds like a buggy installation or there may be some > problem with the communication between the web server and the mysqld. Is > the db on a different machine? Try using mysql_

RE: [PHP] Re: PHP and MySQL bug

2003-01-06 Thread Larry Brown
, 2003 1:09 PM To: MySQL List; [EMAIL PROTECTED] Subject: [PHP] Re: PHP and MySQL bug The problem is if I close the connection and reopen it the query is done, but if I remain with the same connection has the previous query, mysql returns an error. - Original Message - From: "Larry

Re: PHP and MySQL bug

2003-01-06 Thread Jennifer Goodie
: Monday, January 06, 2003 10:09 AM To: MySQL List; [EMAIL PROTECTED] Subject: Re: PHP and MySQL bug The problem is if I close the connection and reopen it the query is done, but if I remain with the same connection has the previous query, mysql returns an error. - Original Message - From

Re: PHP and MySQL bug

2003-01-06 Thread Nuno Lopes
ED]> Sent: Sunday, January 05, 2003 4:16 PM Subject: Re:PHP and MySQL bug > Try replacing the following line... > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't > work > > With... > > $query = "UPDATE

Re: [PHP] Re: PHP and MySQL bug

2003-01-06 Thread Nuno Lopes
To: <[EMAIL PROTECTED]> Sent: Sunday, January 05, 2003 10:29 PM Subject: RE: [PHP] Re: PHP and MySQL bug > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this > > query doesn't work > > Personally, I'd call it bad

Re:PHP and MySQL bug

2003-01-05 Thread Larry Brown
Try replacing the following line... @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this query doesn't work With... $query = "UPDATE d SET h='$h' WERE id='$id'"; $queryr = mysql_query($query) or die("The sql statement does not execute"); if(mysql_affected_rows() !== 1) { die("The

Re: PHP and MySQL bug

2003-01-05 Thread Nuno Lopes
Here is the source code: Seleccione a localização para o download:Localização Principal"; if ($mirrors) { echo " Mirrors"; $m=explode("»",$mirrors); foreach ($m as $v) { $m2=explode("!",$v); echo "$m2[0]"; } echo "Nota: Deve escolher o mirror mais próximo da sua localização, para acelerar o dowloa

Re: PHP and MySQL bug

2003-01-04 Thread Stefan Hinz, iConnect \(Berlin\)
Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 - Original Message - From: "Nuno Lopes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 04, 2003 11:46 AM Subject: PHP and MySQL bug > Dear Sirs, > > I&#

RE: PHP and MySQL bug

2003-01-04 Thread Larry Brown
quot;..." Larry S. Brown Dimension Networks, Inc. (727) 723-8388 -Original Message- From: Nuno Lopes [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 04, 2003 5:46 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: PHP and MySQL bug Dear Sirs, I'm using PHP and MySQL to make m

PHP and MySQL bug

2003-01-04 Thread Nuno Lopes
Dear Sirs, I'm using PHP and MySQL to make my programs. But I think I discovered a bug in PHP or in MySQL (I don't know!). In one of my files I have the following: MYSQL_CONNECT("localhost", "**user**", "**pass**"); mysql_select_db("be"); $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");

RE: MySQL BUG

2002-12-20 Thread Bill Kratochvil
pen source utility that I'm developing might pull on seasoned veterans (to improve it and my code). -Original Message- From: deep kapasi [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:51 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySQL BUG

MySQL BUG

2002-12-20 Thread deep kapasi
Hi, I am facing strange problem while accessing a LONGTEXT field. I've been using VisualBasic 6.0 & MySQL 4.0.4 via ADO 2.0 by using MyODBC 3.51.04 on WIN2k Server (SP 2). Pls follow the below steps to generate a bug --> '/' 1. Create a Tabl

Re: is this a MySQL bug?

2002-11-27 Thread Chris Barnes
I knew i was doing something stupid :p I did actually look through the documentation but i had no luck. I also have a MySQL book (Core MySQL by Leon Atkinson) but I couldn't find anything in there to help me. Thanks for your help. On Thu, 2002-11-28 at 05:06, Keith C. Ivey wrote: > On 28 Nov 2002

Re: is this a MySQL bug?

2002-11-27 Thread Keith C. Ivey
On 28 Nov 2002, at 3:24, Chris Barnes wrote: > i do > "lock tables jobs read" > > everything seemed ok so then i do > > "lock tables mechanics read" > > again no errors so i guess it worked..now i'm expecting to have my 2 > tables locked for read only. In the documentation it says (http://www

re: is this a MySQL bug?

2002-11-27 Thread Egor Egorov
Chris, Wednesday, November 27, 2002, 6:24:12 PM, you wrote: CB> I keep getting error 1100 (table [table name(s) was not locked with LOCK CB> TABLES) but I am definitely locking them with LOCK TABLES... CB> here's examples of what i'm doing... CB> i have 2 tables i'm trying to work with...jobs and

is this a MySQL bug?

2002-11-27 Thread Chris Barnes
Hi, I keep getting error 1100 (table [table name(s) was not locked with LOCK TABLES) but I am definitely locking them with LOCK TABLES... here's examples of what i'm doing... i have 2 tables i'm trying to work with...jobs and mechanics i do "lock tables jobs read" everything seemed ok so then i

How to report MySQL bug

2002-11-15 Thread Allan
How do I report bugs in MySQL CC? I have seen a consistent bug in 85 and 86. Would like to report but not sure how?? Passion and Presence Allan Hardy - Before posting, please check: http://www.mysql.com/manual.php (the ma

re: 3.23.53 can't change to user mysql bug

2002-10-15 Thread Egor Egorov
Richard, Tuesday, October 15, 2002, 4:20:20 PM, you wrote: RG> I just upgraded from 3.32.51 to 3.23.53. With MySQL 3.23.53, mysqld RG> wouldn't start. In the error log, the error was that it couldn't change to RG> the mysql user. The mysql user did indeed exist. A downgrade back to RG> 3.23.51

3.23.53 can't change to user mysql bug

2002-10-15 Thread Richard Gabriel
I just upgraded from 3.32.51 to 3.23.53. With MySQL 3.23.53, mysqld wouldn't start. In the error log, the error was that it couldn't change to the mysql user. The mysql user did indeed exist. A downgrade back to 3.23.51 fixed this problem. Any thoughts? By the way, I install via RPM packages

MySQL Bug: Outer Joins producing incorrect result on a single join referencing multiple tables

2002-09-20 Thread Jean-Pierre Pelletier
he temporary table in an outer join >Submitter-Id: Jean-Pierre Pelletier >Originator:root >Organization: Peregrine Systems, Inc. >MySQL support: [none | licence | email support | extended email support ] >Synopsis: MySQL Bug: Outer Joins producing incorrect result on a single

Re: MySQL bug?

2002-09-11 Thread Gerald Clark
Maybe a simple mysqladmin flush-logs would have done it. Mark Dieterich wrote: >Jeremy, > >What would I do without the internet??? I restarted mysql by hand and >the discrepency immediately went away. I should have thought about >that. > >Thanks! > >Mark > >On Wed, Sep 11, 2002 at 12:01:29PM -

Re: MySQL bug?

2002-09-11 Thread Mark Dieterich
Jeremy, What would I do without the internet??? I restarted mysql by hand and the discrepency immediately went away. I should have thought about that. Thanks! Mark On Wed, Sep 11, 2002 at 12:01:29PM -0500, Jeremy Tinley wrote: > Are you deleting any logs and not restarting the server after d

MySQL bug?

2002-09-11 Thread Mark Dieterich
Folks, I'm experiencing some strange behavior with our mysql server and I'm curious to see if anybody else has had this problem. Over about a 3 month period, I noticed that the /var partition of our linux server claims to fill up. The server is well into it's 3 month cycle now and I have a shor

Re: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]

2002-08-02 Thread Andis
TED]> <001001c23a13$5ba93280$[EMAIL PROTECTED]> "Victoria Reznichenko" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Subject: Re: Re: Re: MySQL bug? - problems with character-set Date: Fri, 2 Aug 2002 17:57:53 +0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary=&q

Re: Re: Re: MySQL bug? - problems with character-set

2002-08-02 Thread Victoria Reznichenko
Andis, Friday, August 02, 2002, 1:57:12 PM, you wrote: A> I created character-set myself. Here, in Latvia, we use windows-1257. A> Problem is, when I use MySQL under Linux, conversation occurs better. Under A> windows98 I have problems as I wrote before. Cheracter-set I created myself, A> because

Re: Re: MySQL bug? - problems with character-set

2002-08-02 Thread Andis
ssage - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 02, 2002 1:05 PM Subject: Re: Re: MySQL bug? - problems with character-set > Andis, > Friday, August 02, 2002, 9:07:54 AM, you wrote: > > A> It's just a si

Re: Re: MySQL bug? - problems with character-set

2002-08-02 Thread Victoria Reznichenko
Andis, Friday, August 02, 2002, 9:07:54 AM, you wrote: A> It's just a simple example, because I don't want send latvian-specific A> symbols. This problem occurs with latvian-specific symbols only. A> Configuration file I cheked some 4-5 times. I'm confused now. To convert correctly from upper ca

Re: MySQL bug? - problems with character-set

2002-08-01 Thread Andis
Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 01, 2002 4:41 PM Subject: Re: MySQL bug? - problems with character-set > Andis, > Thursday, August 01, 2002, 2:28:12 PM, you wrote: > > AG> I tested MySQL 3.23.51 under Window

Re: MySQL bug? - problems with character-set

2002-08-01 Thread Victoria Reznichenko
Andis, Thursday, August 01, 2002, 2:28:12 PM, you wrote: AG> I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with AG> such SQL: AG> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') AG> and recieved different results (of course, I used same config file with

MySQL bug? - problems with character-set

2002-08-01 Thread Andis Grasis
Hi! I tested MySQL 3.23.51 under Windows and 3.23.49 under Linux RedHat 7.3 with such SQL: select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') and recieved different results (of course, I used same config file with case-sensitive configuration). Result under Linux looks better, unde

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Roger Baklund
* Chris Beasley > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php script of mine and I think it's > because of MySQL. > I have a value I am inserting into a database and above and below > my query I > can echo out the value and it is correct, but the query k

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Gurhan Ozen
l.com/doc/C/o/Column_types.html Gurhan - Original Message - From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 10:46 AM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it.

Re: MySQL Bug - bug list rejected

2002-06-23 Thread Jocelyn Fournier
- Original Message - From: "Chris Beasley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, June 23, 2002 4:46 PM Subject: MySQL Bug - bug list rejected > I tried posting this on the bug list and it rejected it. > > I've got this bug in a php scr

MySQL Bug - bug list rejected

2002-06-23 Thread Chris Beasley
read.php?s=&postid=477502 Check out the thread, if I don't have absolute proof of a MySQL bug then I don't think such proof would be possible to get. Chris Beasley - Before posting, please check: http://www.mysq

Followup: Mysql Bug Report, Random crashes, reason unknown

2002-04-26 Thread Gavin Woodhatch
Hello All Many Thanks specialy goto Egor Egorov. We changed the RAM in the Server .. MySQL has now been Running (without Crash) for over 48 h .. Problem solved ! Thanks again for your Support ! Cheers Gavin Woodhatch NetZone Ltd. ---

Re: Mysql Bug Report, Random crashes, reason unknown

2002-04-22 Thread Egor Egorov
Gavin, Monday, April 22, 2002, 6:29:08 PM, you wrote: GW> Description: GW> MySQL Crashes often. GW> How-To-Repeat: GW> Don't know GW> Fix: GW> Don't know GW>Submitter-Id: Gavin Woodhatch GW>Originator: GW>Organization: NetZone Ltd. GW>MySQL support: [none] GW>Synopsis:

Mysql Bug Report, Random crashes, reason unknown

2002-04-22 Thread Gavin Woodhatch
Description: MySQL Crashes often. How-To-Repeat: Don't know Fix: Don't know >Submitter-Id: Gavin Woodhatch >Originator: >Organization: NetZone Ltd. >MySQL support: [none] >Synopsis: Random MySQL crashes (1-2 every 24h) >Severity: [ serious ] >Priority: [ m

Re: MySQL Bug

2002-04-12 Thread Miguel Angel Solorzano
At 21:22 11/04/02 -0500, John D Armstrong wrote: Hi! >On my computer both old 'stable' releases and new alpha downloads of >MySQL report this error: > >020411 21:21:31 Can't find messagefile >'c:\mysqin\share\english\errmsg.sys' >020411 21:21:31 Aborting > >Although I have checked several times

MySQL Bug

2002-04-11 Thread John D Armstrong
On my computer both old 'stable' releases and new alpha downloads of MySQL report this error: 020411 21:21:31 Can't find messagefile 'c:\mysqin\share\english\errmsg.sys' 020411 21:21:31 Aborting Although I have checked several times for the files existence. Any Idea? -

MySQL++ (?) bug

2002-04-08 Thread Andrius Armonas
Hi, I've built MySQL++ 1.7.9 libs on an smp machine. But every application which is built using mysql++ crashes with segfault when invoking connect() method. For example: #include #include void main() { try { Connection con( use_exceptions ); con.connect(); } c

Re: mysql bug

2002-03-22 Thread Timo Maier
Hi Sinisa! >Thank you for your bug report. Thank /you/ for MySQL (: tam -- eCS 1.00, Ducati 750SS '92 up and running http://tam.belchenstuermer.de/ - Before posting, please check: http://www.mysql.com/manual.php (the manu

Re: mysql bug

2002-03-22 Thread Sinisa Milivojevic
Thank you for your bug report. This bug is now fixed in 3.23.50, which will very soon be available. This is a patch that fixes a bug : --- 1.12/sql/item.ccWed May 23 02:32:52 2001 +++ 1.13/sql/item.ccFri Mar 22 14:03:42 2002 @@ -59,12 +59,28 @@ } } -bool Item::eq(const Item

mysql bug

2002-03-04 Thread Timo Maier
Hi! This is the test table: DROP TABLE IF EXISTS asinfo; CREATE TABLE asinfo ( asinfoID int(10) unsigned NOT NULL auto_increment, art char(1) binary NOT NULL default '', KNR char(5) NOT NULL default '', RECHNR char(6) NOT NULL default '', POSNR char(2) NOT NULL default '', ARTNR char

RE: is this a mysql Bug ?

2002-03-02 Thread Roger Baklund
* Jamil Ahmed > is this a mysql Bug ? > > curdate()-3 returns 20020299 > curdate()-2 returns 20020300 No, curdate() returns "today" as a "date string" or as a number, based on the context in which it is used. From the manual: "Returns today's date as

Re: is this a mysql Bug ?

2002-03-02 Thread Georg Richter
On Saturday, 2. March 2002 12:10, Jamil Ahmed wrote: > is this a mysql Bug ? > > curdate()-3 returns 20020299 > curdate()-2 returns 20020300 No it's not a bug! But why do you want substract numbers from a string?! In this case 2002-03-02 will be interpreted as 20020302 and from

is this a mysql Bug ?

2002-03-02 Thread Jamil Ahmed
is this a mysql Bug ? curdate()-3 returns 20020299 curdate()-2 returns 20020300 Keep smiling, ;^) ~Jamil * mysql> select curdate(); ++ | curdate() | ++ | 2002-03-02 | ++ 1 row in set (0.00 sec) my

mysql bug in TEXT type

2002-02-12 Thread Rusty Wright
Our backup software can run a shell script before it starts the backups (and another script when they're finished); I use a script that shuts mysql down and runs myisamchk. Originally it was using myisamchk --safe-recover */*.MYI Then I was eyeballing the online documentation for myisamchk an

mysql bug in TEXT type

2002-02-08 Thread Rusty Wright
Our backup software can run a shell script before it starts the backups (and another script when they're finished); I use a script that shuts mysql down and runs myisamchk. Originally it was using myisamchk --safe-recover */*.MYI Then I was eyeballing the online documentation for myisamchk an

mysql bug

2002-01-26 Thread Seva Gluschenko
Hi, guys! Sorry not to provide you with a complete bug report, but it's indeed the huge amount of time needed to provide you with a "clever" bug report and it's maybe clear enough case. This bug appeared right after 3.23.43 version, up to this all tests were passed just fine. Since 3.23.44 and u

Re: mysql bug

2001-12-27 Thread Benjamin Pflugmann
Hello. On Wed, Dec 19, 2001 at 05:13:02AM -0800, [EMAIL PROTECTED] wrote: > Dear Sir/Madam > I downloaded mysql3.23max version actaually i want to > use Innodb type for my tables in the properties its > showing Innodb is disabled to enable that i ve to give > some path in 'my.cnf' file according

  1   2   >