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
Dyego Souza do Carmo writes:
Sinisa:
Wednesday, June 11, 2003, 2:16:16 PM, você escreveu:
---[inicio]--
The FileName is l5.zip
---[cortar]--
-
, 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];
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
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
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
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
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
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
36 matches
Mail list logo