Hi Thomas,
Did you run the post install script?
http://kae.li/iiikj
Claudio
On Apr 2, 2011 2:20 AM, Thomas Dineen tdin...@ix.netcom.com wrote:
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:
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
because at the
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
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
so
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 file:
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 tdin...@ix.netcom.com
mailto:tdin...@ix.netcom.com wrote:
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
And
('%å%');
which returns correct results, but this disables me from letting the
user do case sensitive searches.
Am I doing something wrong or stupid? Could this be a MySQL bug?
How do I know this isn't a problem with other utf-8 characters in other
languages?
I've searched in bug reports
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
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 binaries
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|
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 MySQL bug
- 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 MySQL bug - insert into 'double
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 looks
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
@lists.mysql.com
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/bug.php?id=9670
The bug has been closed, but I'm
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
seemed
]
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 current 4.0.25 version
of MySQL
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
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]
--Subject: Mysql bug
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 an update command using several
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.15 and
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;
[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:
*) Create a database.
*) Import the dump file that is attached
Dyego Souza do Carmo writes:
Hi,
Try to do the following:
[skip]
-
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-
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
Dyego Souza do Carmo writes:
Sinisa:
Wednesday, June 11, 2003, 2:16:16 PM, você escreveu:
---[inicio]--
The FileName is l5.zip
---[cortar]--
-
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 dbowner where warndate = now().
This update affects not only on the field
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 dbowner where warndate
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 the
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, goto https
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.
-
Before posting, please check:
http://www.mysql.com/manual.php
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
, 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:
I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'
(I have the mysql server
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 absolutely necessary and stop everything in the registry under run
and stop anything
: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_pconnect instead of
connect
just to see what result you
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 pconnect
')
- 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='$id'); // this
query doesn't work
Personally, I'd call it bad programming
* 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
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 is located
- Original Message -
From
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 ip of DB is located
- Original Message
, 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 Brown [EMAIL
, 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 programming practice to do a database update
and not check to see if it worked or not. In this case, how are you
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 d SET h='$h' WERE id='$id';
$queryr = mysql_query($query) or die(The sql statement does not
execute
: 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
Here is the source code:
?
@MYSQL_CONNECT(localhost, nlopes, testing) or die(Erro 1);
@mysql_select_db(be);
$r=MYSQL_QUERY(SELECT n,u,m,h FROM d WHERE id='$id');
if (mysql_num_rows($r)==0) {
die (Erro);
} else {
$re=mysql_fetch_array($r, MYSQL_NUM);
$nome=$re[0];
$url=$re[1];
$mirrors=$re[2];
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 sql
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');
/* Some
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 my programs. But I think I discovered a bug
04, 2003 11:46 AM
Subject: PHP and MySQL bug
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
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
Hi,
I am facing strange problem while accessing a LONGTEXT
field.
I've been using
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
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
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
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
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
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
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
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
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 -0500,
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 case
-
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 simple example, because I don't want send latvian-specific
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
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==_NextPart_000_002C_01C23A4E.20042D80
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express
[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 Windows and 3.23.49 under Linux RedHat
7.3 with
AG such SQL:
AG
- 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 script of mine and I think it's because of
MySQL
/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.
I've got this bug in a php script of mine
* 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 keeps
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.
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
GWSubmitter-Id: Gavin Woodhatch
GWOriginator:
GWOrganization: NetZone Ltd.
GWMySQL support: [none]
GWSynopsis:
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 for the
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
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
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)
mysql
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 this number
you
* 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 a
value in '-MM-DD' or MMDD format, depending
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 to
Eric,
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT? Then the problem
might be the consistent read. I have copied below a segment
from the InnoDB manual at www.innodb.com :
When you issue a consistent
On Fri, 17 Aug 2001, Heikki Tuuri wrote:
Problem resolved, thank you very much. It was indeed my missing a
concept, description below:
it was not immediately clear to me what your application
does. Does one connection update the table and
another connection do the SELECT?
Yes, as it's two
Arturs Aboltins writes:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MYSQL bug with if and datetime fields
Description:
In queries where datetime field is in WHERE condition, the same
field
in IF statement causes incorrect query result.
How-To-Repeat
Hi!
Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes:
Sinisa Arturs Aboltins writes:
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: MYSQL bug with if and datetime fields
Description:
In queries where datetime field is in WHERE condition, the same
field
in IF statement
On Mon, 16 Jul 2001, Benjamin Pflugmann wrote:
If I understand it correctly, this is a known and fixed bug:
From http://www.mysql.com/documentation/mysql/bychapter/manual_News.html:
--
F.2.3 Changes in release 3.23.38
[...]
Hi.
On Fri, Jul 13, 2001 at 02:10:54PM +0200, [EMAIL PROTECTED] wrote:
On Don, 12 Jul 2001, Gerald Clark wrote:
It may be the DESC that prohibits the use of the index.
Try an normal ascending order.
Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not.
I
Hello,
On Don, 12 Jul 2001, Gerald Clark wrote:
It may be the DESC that prohibits the use of the index.
Try an normal ascending order.
Thanks for you idea, but DESC has no influence whether Mysql uses the INDEX or not.
I think maybe that this is a real _bug_ in mysql. :-(
Does somebody
Mysql Bug Report about Latin5 in 3.23.38max
I downloaded Mysql Win32 sources and saw that :=20
in share directory , in Index file there is #30 latin5 line.=20
but in directory this file does not exist.=20
all other files are correct and exist but
there is not latin5 file???
Yusuf Incekara
-
From: Arif Chowdhury [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 19, 2001 3:12 PM
To: [EMAIL PROTECTED]
Subject: MYSQL Bug on Solaris 8
Hi there,
I installed mysql 3.22.32 on Solaris 8 and everytime I am
trying to run mysqld it gives me the following error
ld.so.1: /usr/local/mysql
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127 |Chicago |1|
|127 |Boston |2|
|391 |Miami|1|
+--+
SELECT
On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127 |Chicago |1|
|127 |Boston |2|
|391
On Sun, Feb 18, 2001 at 02:19:17AM +0100, Fred van Engen wrote:
On Fri, Feb 16, 2001 at 06:50:53PM -0600, Richard Reina wrote:
Here is the table:
+--+
| STOP_0FFS |
+--+
|FLIGHT_NO |CITY | SEQUENCE|
|127
90 matches
Mail list logo