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

[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

[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 file: './mysql/host.frm' (errno: 13)
> *Solution*: RTFM
> Next time breathe 10 times deep, and reply!

WTF?

"Keep in mind that I have approximately 50  hours into this Mysql server install
and still no results!" and not look ONE TIME in the basic-manual in this
50 hours is the wrong way, everytime, everywhere and with every software

peopole spent many hours to writing documentation!

this is the start BEFORE mailing-list:
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

yes, is something unclear after that there is a starting-point for questions
but not "i do not read docs, say me exactly where the problem is"





signature.asc
Description: OpenPGP digital signature

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

[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
so this is a permissions-problem

i guess there is a data-dir in the tar.gz you "installed"
as root and you did not change its permissions

> Keep in mind that I have tried several dozen experiments over many late hours
> with a version host.frm from a older version of mysql with NO success! I have
> tried putting it in every possible location. Using 777 file permissions.

you should not blind copy files without any idea what you are doing

> root@Sun# pwd
> /usr/local/mysql
> root@Sun# ls
> bin infoman mysql-test  var
> host.frmlib my.cnf  share
> include libexec mysql   sql-bench

delete the host.from from here and everywhere you placed it
and please open your eyes if you too lazy read documentations

you see the folder "var"?
_

RTFM (google: "mysql /usr/local default datadir"):
http://dev.mysql.com/doc/refman/5.0/en/starting-server.html

If you get Errcode 13 (which means Permission denied) when starting mysqld, 
this means that the privileges of the
data directory or its contents do not permit server access. In this case, you 
change the permissions for the
involved files and directories so that the server has the right to use them. 
You can also start the server as root,
but this raises security issues and should be avoided.

On Unix, change location into the data directory and check the ownership of the 
data directory and its contents to
make sure the server has access. For example, if the data directory is 
/usr/local/mysql/var, use this command:

shell> ls -la /usr/local/mysql/var

If the data directory or its files or subdirectories are not owned by the login 
account that you use for running
the server, change their ownership to that account. If the account is named 
mysql, use these commands:

shell> chown -R mysql /usr/local/mysql/var
shell> chgrp -R mysql /usr/local/mysql/var




signature.asc
Description: OpenPGP digital signature

Re: Mysql Bug 04/01/11

[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 question is not worth answering just dont answer,
while if you answer do it in a useful way, so that all the community can
only improve from it,
do you find this useful?

*Problem:* 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't
find file: './mysql/host.frm' (errno: 13)
*Solution*: RTFM

Next time breathe 10 times deep, and reply!

This is just my opinion.

Sincerely,

Claudio




2011/4/2 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
> because at the end you have something running and understodd
> nothing!
>
> sounds like you never before had used mysql and missing
> all the basics from the first chapters in the well written documentation
>
> >> - 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 following error occurs:
> >> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find
> file: './mysql/host.frm' (errno: 13)
>
> you should read the manuals or use a operating system with packages
> which are idiot-proof, fedora does this for you:
>
> if [ ! -d "$datadir/mysql" ] ; then
>  # First, make sure $datadir is there with correct permissions
>  if [ ! -e "$datadir" -a ! -h "$datadir" ]
>  then
>  mkdir -p "$datadir" || exit 1
>  fi
>  chown mysql:mysql "$datadir"
>  chmod 0755 "$datadir"
>  [ -x /sbin/restorecon ] && /sbin/restorecon "$datadir"
>  # Now create the database
>  action $"Initializing MySQL database: " /usr/bin/mysql_install_db
> --datadir="$datadir" --user=mysql
>  ret=$?
>  chown -R mysql:mysql "$datadir"
>  if [ $ret -ne 0 ] ; then
>  return $ret
>  fi
> fi
>
> >> 1) Please identify where the missing file can be found,
> >> keeping in mind that I just installed and have no backup
> >> (of the current rev.)
>
> they CAN NOT BE FOUND if you have a fresh install and not used
> "mysql_install_db"
> and WHERE they are created depends on your configuration as said yesterday
>
> let me guess: you even have not spent any second for your my.cnf?
> > [mysqld]
> > datadir = /where/ever/you/want/your/databases/jesus/christ
>
> on my system typing mysql_ followed with 2 x TAB brings a list of commands
> since you think you must not use a environments package-system why
> in the world do you not look in your bin-folder at /usr/local/mysql/
> and read some docs to understand that the mysql-database is the userdb
>
> [root@srv-rhsoft:~]$ mysql_
> mysql_client_test   mysql_convert_table_format
>  mysql_fix_extensionsmysql_secure_installation
> mysql_tzinfo_to_sql mysql_upgrade_replication   mysql_zap
> mysql_configmysql_find_rows mysql_install_db
>  mysql_setpermission
> mysql_upgrade   mysql_waitpid
>
>


-- 
Claudio

Re: Mysql Bug 04/01/11

[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
because at the end you have something running and understodd
nothing!

sounds like you never before had used mysql and missing
all the basics from the first chapters in the well written documentation

>> - 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 following error occurs:
>> 110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find file: 
>> './mysql/host.frm' (errno: 13)

you should read the manuals or use a operating system with packages
which are idiot-proof, fedora does this for you:

if [ ! -d "$datadir/mysql" ] ; then
 # First, make sure $datadir is there with correct permissions
 if [ ! -e "$datadir" -a ! -h "$datadir" ]
 then
  mkdir -p "$datadir" || exit 1
 fi
 chown mysql:mysql "$datadir"
 chmod 0755 "$datadir"
 [ -x /sbin/restorecon ] && /sbin/restorecon "$datadir"
 # Now create the database
 action $"Initializing MySQL database: " /usr/bin/mysql_install_db 
--datadir="$datadir" --user=mysql
 ret=$?
 chown -R mysql:mysql "$datadir"
 if [ $ret -ne 0 ] ; then
  return $ret
 fi
fi

>> 1) Please identify where the missing file can be found, 
>> keeping in mind that I just installed and have no backup 
>> (of the current rev.)

they CAN NOT BE FOUND if you have a fresh install and not used 
"mysql_install_db"
and WHERE they are created depends on your configuration as said yesterday

let me guess: you even have not spent any second for your my.cnf?
> [mysqld]
> datadir = /where/ever/you/want/your/databases/jesus/christ

on my system typing mysql_ followed with 2 x TAB brings a list of commands
since you think you must not use a environments package-system why
in the world do you not look in your bin-folder at /usr/local/mysql/
and read some docs to understand that the mysql-database is the userdb

[root@srv-rhsoft:~]$ mysql_
mysql_client_test   mysql_convert_table_format  mysql_fix_extensions
mysql_secure_installation
mysql_tzinfo_to_sql mysql_upgrade_replication   mysql_zap
mysql_configmysql_find_rows mysql_install_db
mysql_setpermission
mysql_upgrade   mysql_waitpid



signature.asc
Description: OpenPGP digital signature

Re: Mysql Bug 04/01/11

[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.mysql.com/mysql?unsub=arch...@jab.org

Re: Mysql Bug 04/01/11

[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

[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 following error occurs:
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './mysql/host.frm' (errno: 13)


1) Please identify where the missing file can be found, keeping in mind 
that I just installed and

have no backup (of the current rev.).

2) If we are installing in /usr/local/mysql where exactly dose this file 
belong,

(exact path please).

3) What exactly do the file ownersiip and permissions have to be?

Keep in mind that I have tried several dozen experiments over many late 
hours with
a version host.frm from a older version of mysql with NO success! I have 
tried putting

it in every possible location. Using 777 file permissions.

A snapshot of my system:
root@Sun# pwd
/usr/local/mysql
root@Sun# ls
bin infoman mysql-test  var
host.frmlib my.cnf  share
include libexec mysql   sql-bench

root@Sun# ls -la host.frm
-rwxrwxrwx   1 root root9064 Apr  1 16:39 host.frm

root@Sun# ls -la mysql
total 22
drwxrwxrwx   2 root root 512 Apr  1 16:34 .
drwxr-xr-x  13 bin  bin  512 Apr  1 16:39 ..
-rwxrwxrwx   1 root root9064 Apr  1 16:34 host.frm

- The entire transcript is shown below:

10401 16:39:27  mysqld started
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 
18446744073709

551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'max_join_size': unsigned value 
18446744073709

551615 adjusted to 4294967295
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 
adjusted

to 131072
110401 16:39:27 [Warning] option 'thread_stack': unsigned value 65536 
adjusted

to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:39:27  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:39:27  InnoDB: Starting an apply batch of log records to the 
database

...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 
49 50 5
1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 
75 76 77

 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:39:27  InnoDB: Started; log sequence number 0 43655
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my

sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my

sql/host.frm' (errno: 13)
110401 16:39:27 [ERROR] Fatal error: Can't open and lock privilege 
tables: Can'

t find file: './mysql/host.frm' (errno: 13)
110401 16:39:27  mysqld ended

110401 16:42:30  mysqld started
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 
18446744073709

551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'max_join_size': unsigned value 
18446744073709

551615 adjusted to 4294967295
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 
adjusted

to 131072
110401 16:42:30 [Warning] option 'thread_stack': unsigned value 65536 
adjusted

to 131072
InnoDB: Log scan progressed past the checkpoint lsn 0 36808
110401 16:42:30  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Doing recovery: scanned up to log sequence number 0 43655
110401 16:42:30  InnoDB: Starting an apply batch of log records to the 
database

...
InnoDB: Progress in percents: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 
49 50 5
1 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 
75 76 77

 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
110401 16:42:30  InnoDB: Started; log sequence number 0 43655
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my

sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] /usr/local/mysql/libexec/mysqld: Can't find 
file: './my

sql/host.frm' (errno: 13)
110401 16:42:30 [ERROR] Fatal error: Can't open and lock privilege 
tables: Can'

t find file: './mysql/host.frm' (errno: 13)
110401 16:42:30  mysqld ended

root@Sun#

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

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

[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
And that every column ALSO has:
  charset=utf8
  collation=utf8_norwegian_ci

Notice that I am making 'utf8_norwegian_ci' up. I looked for it using my MySQL 
Query Browser but couldn't find it. As I'm from Sweden I've had similar 
problems (åäöÅÄÖ matched åaäÅÄAÖO) and setting as above but using (the 
existing) 'utf8_swedish_ci' worked in my case.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Magne Westlie]

Dear List,

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'.


Example:
CREATE TABLE names (
  name VARCHAR(255)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO names VALUES
('Foo'), ('Bar'), ('Båt'), ('Bør'), ('Ære');

Now, searching gives me the following results:

mysql> SELECT * FROM names WHERE name LIKE '%å%';
+--+
| name |
+--+
| Bar  |
| Båt  |
+--+

mysql> SELECT * FROM names WHERE name LIKE '%a%';
+--+
| name |
+--+
| Bar  |
| Båt  |
+--+


Searching for strings with other norwegian characters seams to work:

mysql> SELECT * FROM names WHERE name LIKE '%ø%';
+--+
| 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 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, but cannot find this exact problem.


Some additional information that might be useful:
mysql> SELECT VERSION();
+--+
| VERSION()|
+--+
| 5.0.45-Debian_1ubuntu3.1-log |
+--+

mysql> SHOW VARIABLES LIKE '%character%';
+--++
| Variable_name| Value  |
+--++
| character_set_client | utf8   |
| character_set_connection | utf8   |
| character_set_database   | utf8   |
| character_set_filesystem | binary |
| character_set_results| utf8   |
| character_set_server | utf8   |
| character_set_system | utf8   |
| character_sets_dir   | /usr/share/mysql/charsets/ |
+--++


Thanks,

Magne Westlie





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[Andrew Braithwaite]

Hmm - and further to this.  Strange differences of behaiour between the
last two production versions of MySQL

sh-2.05b# ln -s mysql-standard-4.0.24-apple-darwin7.7.0-powerpc mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.24-standard-log

mysql> create table wibble3 (
-> test1 double(3,6),
-> test2 double(7,6),
-> test3 double(9,6));
Query OK, 0 rows affected (0.11 sec)

mysql> desc wibble3;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
+---+-+--+-+-+---+
| test1 | double(7,6) | YES  | | NULL|   |
| test2 | double(7,6) | YES  | | NULL|   |
| test3 | double(9,6) | YES  | | NULL|   |
+---+-+--+-+-+---+
3 rows in set (0.17 sec)

mysql> insert into wibble3 values(50.123456,50.123456,50.123456);
Query OK, 1 row affected (0.08 sec)

mysql> select * from wibble3;
+---+---+---+
| test1 | test2 | test3 |
+---+---+---+
| 50.123456 | 50.123456 | 50.123456 |
+---+---+---+
1 row in set (0.08 sec)

sh-2.05b# ln -s mysql-standard-4.1.10a-apple-darwin7.7.0-powerpc mysql

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.10a-standard-log

mysql> insert into wibble3 values(50.123456,50.123456,50.123456);
Query OK, 1 row affected, 2 warnings (0.11 sec)

mysql> select * from wibble3;
+---+---+---+
| test1 | test2 | test3 |
+---+---+---+
| 50.123456 | 50.123456 | 50.123456 |
|  9.99 |  9.99 | 50.123456 |
+---+---+---+
2 rows in set (0.06 sec)

Looks like while MySQL 4.1 was not changing what was stored in the data but
changing what is inserted into new records to match the proper data tye
definitions.


On 19/9/05 17:49, "Andrew Braithwaite" <[EMAIL 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: mysql@lists.mysql.com
> Cc: Andrew Braithwaite
> Subject: Re: possible MySQL bug - insert into 'double' column problem
> with mysql 4.1
> 
> 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|
> |
>> | lat   | double(7,6)  | YES  | | NULL|
> |
> 
>  From the manual:
> 
> DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]
> 
> M is the total number of decimal digits and D is the number of digits
> following the decimal point.
> 
> http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html >
> 
>> mysql> INSERT INTO table1VALUES
>> (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
>> Query OK, 1 row affected, 1 warning (0.01 sec)
>> 
>> mysql> select * from table1 where id=8002\G
>> *** 1. row ***
>>id: 8002
>>GeoQuality: 2a
>>   lon: -0.361080
>>   lat: 9.99
> 
> You have created your columns with a max width of 7, out of which 6 are
> decimals, but you are trying to insert a number with 8 digits.
> 
> --
> Roger
> 
> 
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[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 MySQL bug - insert into 'double' column problem
with mysql 4.1

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|
|
> | lat   | double(7,6)  | YES  | | NULL|
|

 From the manual:

DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]

M is the total number of decimal digits and D is the number of digits 
following the decimal point.

http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html >

> mysql> INSERT INTO table1VALUES
> (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
> Query OK, 1 row affected, 1 warning (0.01 sec)
> 
> mysql> select * from table1 where id=8002\G
> *** 1. row ***
>id: 8002
>GeoQuality: 2a
>   lon: -0.361080
>   lat: 9.99

You have created your columns with a max width of 7, out of which 6 are 
decimals, but you are trying to insert a number with 8 digits.

--
Roger




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[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||
| lat   | double(7,6)  | YES  | | NULL||


From the manual:

DOUBLE[(M,D)] [UNSIGNED] [ZEROFILL]

M is the total number of decimal digits and D is the number of digits 
following the decimal point.


http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html >


mysql> INSERT INTO table1VALUES
(8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> select * from table1 where id=8002\G
*** 1. row ***
   id: 8002
   GeoQuality: 2a
  lon: -0.361080
  lat: 9.99


You have created your columns with a max width of 7, out of which 6 are 
decimals, but you are trying to insert a number with 8 digits.


--
Roger


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[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 binaries on redhat linux 7.2 kernel
> 2.4.20-28.7smp.  Help!
>
> Cheers,
>
> Andrew
>
>
> mysql> desc table1;
> +---+--+--+-+-++
> | Field | Type | Null | Key | Default | Extra  |
> +---+--+--+-+-++
> | id| mediumint(6) |  | PRI | NULL| auto_increment |
> | GeoQuality| varchar(5)   | YES  | | NULL||
> | lon   | double(7,6)  | YES  | MUL | NULL||
> | lat   | double(7,6)  | YES  | | NULL||
> | GeocodeDate   | date | YES  | | NULL||
> | GeocodeSource | varchar(25)  | YES  | | NULL||
> | state | varchar(70)  | YES  | | NULL||
> | client_id | varchar(40)  | YES  | MUL | NULL||
> +---+--+--+-+-++
> 15 rows in set (0.00 sec)
>
> mysql> INSERT INTO table1VALUES
> (8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
> Query OK, 1 row affected, 1 warning (0.01 sec)

My guess is that the second value overflows the maximum value in the column
and that MySQL is SILENTLY inserting the max value for the column.

Have you tried a larger "double" column?

Obviously: screw silent data changes!!

> mysql> select * from table1 where id=8002\G
> *** 1. row ***
>id: 8002
>GeoQuality: 2a
>   lon: -0.361080
>   lat: 9.99
>   GeocodeDate: 2005-08-31
> GeocodeSource: ES052
> state: NULL
> client_id: NULL

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

[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 linux 7.2 kernel
2.4.20-28.7smp.  Help!

Cheers,

Andrew


mysql> desc table1;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra  |
+---+--+--+-+-++
| id| mediumint(6) |  | PRI | NULL| auto_increment |
| GeoQuality| varchar(5)   | YES  | | NULL||
| lon   | double(7,6)  | YES  | MUL | NULL||
| lat   | double(7,6)  | YES  | | NULL||
| GeocodeDate   | date | YES  | | NULL||
| GeocodeSource | varchar(25)  | YES  | | NULL||
| state | varchar(70)  | YES  | | NULL||
| client_id | varchar(40)  | YES  | MUL | NULL||
+---+--+--+-+-++
15 rows in set (0.00 sec)

mysql> INSERT INTO table1VALUES
(8002,'2a',-0.361080,39.468270,'2005-08-31','ES052',NULL,NULL);
Query OK, 1 row affected, 1 warning (0.01 sec)

mysql> select * from table1 where id=8002\G
*** 1. row ***
   id: 8002
   GeoQuality: 2a
  lon: -0.361080
  lat: 9.99
  GeocodeDate: 2005-08-31
GeocodeSource: ES052
state: NULL
client_id: NULL
1 row in set (0.00 sec)

Mysql, query 


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySQL Bug Report

[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 a description how to test your settings if you're using

Windows:



  http://dev.mysql.com/doc/mysql/en/dsn-on-windows.html











>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] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on

>local host (10061)

>

>ERROR [HY000] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on

>local host (10061)"

>

> 

>

>I thought I had installed it correctly, but apparently I didn't.  Any idea

>what went wrong and how I would go about fixing it?



"Kari White" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mySQL Bug Report

[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] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on
local host (10061)

ERROR [HY000] [MySQL] [ODBC 3.51 Driver]Can't connect to MySQL server on
local host (10061)"

 

I thought I had installed it correctly, but apparently I didn't.  Any idea
what went wrong and how I would go about fixing it?

 

 

 

 

Kari White

Brook Group, LTD

8231 Main Street

Ellicott City, MD  21043

410.465.7805

www.brookgroup.com

 

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[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 looks like this could be easily applied to MySQL 4.0:

http://mysql.bkbits.net:8080/mysql-4.0/anno/sql/[EMAIL 
PROTECTED]|src/|src/sql|hist/sql/ha_innodb.cc|diffs/sql/[EMAIL PROTECTED]


Is this an option? Or is MySQL 4.0 falling into the 'discontinued' range 
of products nowadays?

I could apply the patch myself, but I'd rather use the official binaries 
from the MySQL site than rolling my own package.


Best regards,

-- 
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Heikki Tuuri]

Matthis,

unfortunately, the bug fix was never made to 4.0. It is only in 4.1.12 and 
later.


Regards,

Heikki

- Alkuperäinen viesti - 
Lähettäjä: "Matthijs van der Klip" <[EMAIL PROTECTED]>

Vastaanottaja: "MySQL mailing list" 
Kopio: <[EMAIL PROTECTED]>; <[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 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 should this bug already be fixed in 4.0.25?


Best regards,

--
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[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 
seemed to address only 4.1 and 5.0, but I'd like to hear an official 
statement that this bug will not be fixed in 4.0.


Best regards,

-- 
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug 9670 OPTIMIZE TABLE crashes

[Mikhail Entaltsev]

Matthijs,

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.
***
Best regards,
Mikhail.


- Original Message - 
From: "Matthijs van der Klip" <[EMAIL PROTECTED]>
To: "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/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 should this bug already be fixed in 4.0.25?
>
>
> Best regards,
>
> -- 
> Matthijs van der Klip
> System Administrator
> Spill E-Projects
> The Netherlands
>
>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql bug 9670 OPTIMIZE TABLE crashes

[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 should this bug already be fixed in 4.0.25?


Best regards,

-- 
Matthijs van der Klip
System Administrator
Spill E-Projects
The Netherlands



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql bug

[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

> 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 (see Manual)

> with the YAST 2.

> 2. I have typed mysqld_install_db

> 3. When I try to open mysql typing "mysql"I get the

> message "Cannot connect to local Mysql server through

>  socket var/lib/mysql/mysql.sock

> 4. I looked for the socket and there is no

> mysql.sock anywhere on my machine

> 5. If I type "safe_mysqld" the answer is "Starting

> mysql-max demon with database from /var/lib/mysql

>  050720 mysqld ended" >

>>How-To-Repeat:

> (multiple lines)>

>>Fix:

> (multiple lines)>

> 

>>Submitter-Id:  

>>Originator:Maurizio Dudine

>>Organization:

> 

>>MySQL support: [none | licence | email support |

> extended email support ]

>>Synopsis:  

>>Severity:  <[ non-critical | serious | critical ] (one

> line)>

>>Priority:  <[ low | medium | high ] (one line)>

>>Category:  mysql

>>Class: <[ sw-bug | doc-bug | change-request |

> support ] (one line)>

>>Release:   mysql-3.23.48 (Source distribution)

> 

>>Environment:

>

> System: Linux linux 2.4.18-4GB #1 Wed Mar 27 13:57:05

> UTC 2002 i686 unknown

> Architecture: i686

> 

> Some paths:  /usr/bin/perl /usr/bin/make

> /usr/bin/gmake /usr/bin/gcc /usr/bin/cc

> GCC: Reading specs from

> /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs

> gcc version 2.95.3 20010315 (SuSE)

> Compilation info: CC='gcc'  CFLAGS=''  CXX='c++' 

> CXXFLAGS='-O2 -march=i486 -mcpu=i686

> -D_FILE_OFFSET_BITS=64  -D_LARGEFILE_SOURCE   
>   

> -felide-constructors-fno-exceptions   
>   

> -fno-rtti'  LDFLAGS=''

> LIBC: 

> -rwxr-xr-x1 root root  1394238 mar 23 

> 2002 /lib/libc.so.6

> -rw-r--r--1 root root 25361424 mar 23 

> 2002 /usr/lib/libc.a

> -rw-r--r--1 root root  178 mar 23 

> 2002 /usr/lib/libc.so

> -rw-r--r--1 root root   869190 mar 23 

> 2002 /usr/lib/libc-client.a

> lrwxrwxrwx1 root root   20 jul 19

> 12:17 /usr/lib/libc-client.so -> libc-client.so.2001a

> -rwxr-xr-x1 root root   725296 mar 23 

> 2002 /usr/lib/libc-client.so.2001a

> Configure command: ./configure  --disable-shared

> --with-mysqld-ldflags=-static

> --with-client-ldflags=-static --without-berkeley-db

> --without-innodb --enable-assembler

> --enable-large-files --infodir=/usr/share/info

> --libdir=/usr/lib --libexecdir=/usr/sbin

> --localstatedir=/var/lib/mysql --mandir=/usr/share/man

> --prefix=/usr --sysconfdir=/etc

> --with-mysqld-user=mysql --without-debug

> --datadir=/usr/share --includedir=/usr/include

> --with-extra-charsets=complex

> --with-unix-socket-path=/var/lib/mysql/mysql.sock

> --with-libwrap

> 

> 

> 

> 

>

> __ 

> Renovamos el Correo Yahoo! 

> Nuevos servicios, m$s seguridad 

> http://correo.yahoo.es

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql bug

[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 (see Manual)
with the YAST 2.
 2. I have typed mysqld_install_db
 3. When I try to open mysql typing "mysql"I get the
message "Cannot connect to local Mysql server through
  socket var/lib/mysql/mysql.sock
 4. I looked for the socket and there is no
mysql.sock anywhere on my machine
 5. If I type "safe_mysqld" the answer is "Starting
mysql-max demon with database from /var/lib/mysql
  050720 mysqld ended" >
>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:Maurizio Dudine
>Organization:
 
>MySQL support: [none | licence | email support |
extended email support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one
line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request |
support ] (one line)>
>Release:   mysql-3.23.48 (Source distribution)

>Environment:

System: Linux linux 2.4.18-4GB #1 Wed Mar 27 13:57:05
UTC 2002 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make
/usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc'  CFLAGS=''  CXX='c++' 
CXXFLAGS='-O2 -march=i486 -mcpu=i686
-D_FILE_OFFSET_BITS=64  -D_LARGEFILE_SOURCE 

-felide-constructors-fno-exceptions 

-fno-rtti'  LDFLAGS=''
LIBC: 
-rwxr-xr-x1 root root  1394238 mar 23 
2002 /lib/libc.so.6
-rw-r--r--1 root root 25361424 mar 23 
2002 /usr/lib/libc.a
-rw-r--r--1 root root  178 mar 23 
2002 /usr/lib/libc.so
-rw-r--r--1 root root   869190 mar 23 
2002 /usr/lib/libc-client.a
lrwxrwxrwx1 root root   20 jul 19
12:17 /usr/lib/libc-client.so -> libc-client.so.2001a
-rwxr-xr-x1 root root   725296 mar 23 
2002 /usr/lib/libc-client.so.2001a
Configure command: ./configure  --disable-shared
--with-mysqld-ldflags=-static
--with-client-ldflags=-static --without-berkeley-db
--without-innodb --enable-assembler
--enable-large-files --infodir=/usr/share/info
--libdir=/usr/lib --libexecdir=/usr/sbin
--localstatedir=/var/lib/mysql --mandir=/usr/share/man
--prefix=/usr --sysconfdir=/etc
--with-mysqld-user=mysql --without-debug
--datadir=/usr/share --includedir=/usr/include
--with-extra-charsets=complex
--with-unix-socket-path=/var/lib/mysql/mysql.sock
--with-libwrap





__ 
Renovamos el Correo Yahoo! 
Nuevos servicios, más seguridad 
http://correo.yahoo.es

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql bug

[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]
-->Subject: Mysql bug
-->
-->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.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Mysql bug

[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.

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: root
To: [EMAIL PROTECTED]
Subject: [50 character or so descriptive subject here (for reference)]

>Description:

>How-To-Repeat:

>Fix:


>Submitter-Id:  
>Originator:root
>Organization:
 
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:  
>Severity:  <[ non-critical | serious | critical ] (one line)>
>Priority:  <[ low | medium | high ] (one line)>
>Category:  mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release:   mysql-3.23.52 (Mandrake Linux MySQL RPM)

>Environment:

System: Linux magnetic 2.4.19-16mdk #1 Fri Sep 20 18:15:05 CEST 2002 i686 unknown 
unknown GNU/Linux
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux-gnu/3.2/specs
Configured with: ../configure --prefix=/usr --libdir=/usr/lib --with-slibdir=/lib 
--mandir=/usr/share/man --infodir=/usr/share/info --enable-shared 
--enable-threads=posix --disable-checking --enable-long-long --enable-__cxa_atexit 
--enable-languages=c,c++,ada,f77,objc,java --host=i586-mandrake-linux-gnu 
--with-system-zlib
Thread model: posix
gcc version 3.2 (Mandrake Linux 9.0 3.2-1mdk)
Compilation info: CC='gcc-3.2'  CFLAGS='-O3 -fomit-frame-pointer -pipe 
-mcpu=pentiumpro -march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' 
 CXX='g++-3.2'  CXXFLAGS='-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 
-ffast-math -fno-strength-reduce -fno-omit-frame-pointer'  LDFLAGS=''
LIBC: 
lrwxr-xr-x1 root root   13 jui 26 14:03 /lib/libc.so.6 -> libc-2.2.5.so
-rwxr-xr-x1 root root  1147848 aoû 19  2002 /lib/libc-2.2.5.so
-rw-r--r--1 root root  178 aoû 19  2002 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static' 
'--with-client-ldflags=-all-static' '--with-other-libc=/lib' '--without-berkeley-db' 
'--without-innodb' '--enable-assembler' '--enable-local-infile' 
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock' 
'--prefix=/' '--libdir=/usr/lib' '--with-extra-charsets=complex' '--exec-prefix=/usr' 
'--libexecdir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' 
'--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info' 
'--includedir=/usr/include' '--mandir=/usr/share/man' '--with-comment=Mandrake Linux 
MySQL RPM' 'CC=gcc-3.2' 'CFLAGS=-O3 -fomit-frame-pointer -pipe -mcpu=pentiumpro 
-march=i586 -ffast-math -fno-strength-reduce -fno-omit-frame-pointer' 'CXXFLAGS=-O3 
-fomit-frame-pointer -pipe -mcpu=pentiumpro -march=i586 -ffast-math 
-fno-strength-reduce -fno-omit-frame-pointer' 'CXX=g++-3.2'

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql BUG, again ;)

[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.15 and Linux. If you try to do the same
>with mySql 4.0.14, the record that is updated is simple deleted.

Please post your bugs to http://bugs.mysql.com It is a tracking system for
bugs.

> My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
> using InnoDB tables ;)
>
> InnoDB,MyISAM,SQL
>
>
>
>
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>

-- 
Boyd Gerber, Software Engineer & Support Specialist
MySQL AB, www.mysql.com

Are you MySQL certified?  www.mysql.com/certification



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql BUG, again ;)

[Heikki Tuuri]

Dyego,

but now it works right.

[EMAIL PROTECTED]:~/mysql-standard-4.0.8-gamma-pc-linux-i686/bin> perror 139
Error code 139:  Unknown error 139
139 = Too big row (>= 16 M)

The error message text above is wrong, though :). This has nothing to do
with 16 MB.

You should not put THAT many BLOBs in the same row. Split the table
vertically into several. InnoDB-4.0.14 stores the first 512 bytes of each
BLOB into the clustered index record. If you have > 14 BLOBs, then the
clustered index record will be > 8000 bytes long, and you get the error
above.

Regards,

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 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.14, the record that is updated is simple deleted.

My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
using InnoDB tables ;)

InnoDB,MyISAM,SQL




-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento
-
 E S C R I B A   I N F O R M A T I C A


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql BUG, again ;)

[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.14, the record that is updated is simple deleted.

My System is a Debian Linux box , with kernel 2.4.20 with 768 of RAM
using InnoDB tables ;)

InnoDB,MyISAM,SQL




-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--ICQ   : 1647350
$ look into "my eyes" Phone : +55 041 296-2311  
look: cannot open my eyes Fax   : +55 041 296-6640
-
   Reply: [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The MySQL Bug ?

[Heikki Tuuri]

Dyego,

thank you for an excellent bug report. You probably tested the 4.0.14 tree?
That was where I was able to repeat the bug.

The bug was that InnoDB first deleted the old record and only after that
tested if the new record is too long (table handler error 139). You have
lots of BLOBs in the table, and in 4.0.14 each takes 534 bytes also in the
record itself, only the rest is stored externally on a separate page. That
was why the max record length 8000 bytes was exceeded.

The fix will be in 4.0.15 and 4.1.1.

Regards,

Heikki

- Original Message - 
From: "Dyego Souza do 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:
>
>*) 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;
>   You will see that there is a row where Ci_Descricao is "Padrão".
>
>source mysql_blob_bug.sql
>
>select Ci_Descricao from cfgimpressao;
>   Now, the record where Ci_Descricao is "Padrão" has disappear.
>   The script you just executed didn't erase that. There are only
>   update commands to change the blob contents.
>
> The bug is:
> The record where Ci_Descricao is "Padrão" mustn't be erased.
>
>
> The files are:
>
> cfgimpressao.dump <- The Dump Of Table
> mysql_blob_bug.sql <- The File of Blob Bug
>
> stored in the support.mysql.com/pub/mysql/secret
>
>
> Tnks in advance !
>
>
> innodb,mysql,help !
>
>
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
>



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

The MySQL Bug ?

[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;
  You will see that there is a row where Ci_Descricao is "Padrão".

   source mysql_blob_bug.sql
   
   select Ci_Descricao from cfgimpressao;
  Now, the record where Ci_Descricao is "Padrão" has disappear.
  The script you just executed didn't erase that. There are only
  update commands to change the blob contents.
   
The bug is:
The record where Ci_Descricao is "Padrão" mustn't be erased.


The files are:

cfgimpressao.dump <- The Dump Of Table
mysql_blob_bug.sql <- The File of Blob Bug

stored in the support.mysql.com/pub/mysql/secret


Tnks in advance !


innodb,mysql,help !


-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--ICQ   : 1647350
$ look into "my eyes" Phone : +55 041 296-2311  
look: cannot open my eyes Fax   : +55 041 296-6640
-
   Reply: [EMAIL PROTECTED]


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Re[2]: mySql BUG

[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]--
> 
> 
> 
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311  
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
> 
> 

Thanks. We shall take a look at it.
 

-- 

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
   <___/   www.mysql.com   Larnaca, Cyprus


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re[2]: mySql BUG

[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


---[cortar]--



-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--ICQ   : 1647350
$ look into "my eyes" Phone : +55 041 296-2311  
look: cannot open my eyes Fax   : +55 041 296-6640
-
   Reply: [EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mySql BUG

[Sinisa Milivojevic]

Dyego Souza do Carmo writes:
> Hi,
> 
> 
> Try to do the following:
> 

[skip]

> 
> 
> -
>   ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
> -
>  E S C R I B A   I N F O R M A T I C A
> -
> The only stupid question is the unasked one (somewhere in Linux's HowTo)
> Linux registred user : #230601
> --ICQ   : 1647350
> $ look into "my eyes" Phone : +55 041 296-2311  
> look: cannot open my eyes Fax   : +55 041 296-6640
> -
>Reply: [EMAIL PROTECTED]
> 

Hi!


Your attachment was stripped off.

Please upload it to:

ftp://support.mysql.com:/pub/mysql/secret

and let us know it's filename.

-- 

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
   <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mySql BUG

[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 = parte.l5_parteconjuge order
by conjuge.l5_seq desc limit 1;


It shows the error 1105: Unknown error   <-- here is the bug!!!


*) 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 = parte.l5_parteconjuge group
by conjuge.l5_seq having max(conjuge.l5_seq);


It returns an empty set. It is what I would like had happend in the previous command.



My System is Linux Debian Box kernel 2.4.18...
with 768 of ram and MySQl 4.0.13 using InnoDB Tables !!!



I have a dump of table with the bug ! i cant send file to the list...
exists a FTP to put the file ?


sql,query,innodb,hep please


-
  ++  Dyego Souza do Carmo   ++   Dep. Desenvolvimento   
-
 E S C R I B A   I N F O R M A T I C A
-
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--ICQ   : 1647350
$ look into "my eyes" Phone : +55 041 296-2311  
look: cannot open my eyes Fax   : +55 041 296-6640
-
   Reply: [EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql: bug in update (?)

[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 the both fields got the current date and time value.
I changed the name of field "date" to another and got the same result.
I got the same behavior in many mysql versions include 4.0.12.
This is how the TIMESTAMP column type works.  You'll find this section
of the manual to be of interest:
http://www.mysql.com/doc/en/DATETIME.html

Regards,
  Dmitry


--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: MySQL: bug in update (?)

[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 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 time value.
I changed the name of field "date" to another and got the same result.

I got the same behavior in many mysql versions include 4.0.12.

Regards,
  Dmitry

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql: bug in update (?)

[O'K Web Design]

Hi

Your problem lies in your columns.  A timestamp field has the special
property of recording when a record is created or modified.  However, only
the first timestamp column in a row is treated this way.  I hope this helps.
Mike


- Original Message -
From: "Dmitry Kosoy" <[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 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 time value.
> I changed the name of field "date" to another and got the same result.
>
> I got the same behavior in many mysql versions include 4.0.12.
>
> Regards,
>   Dmitry
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql: bug in update (?)

[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 time value.
I changed the name of field "date" to another and got the same result.

I got the same behavior in many mysql versions include 4.0.12.

Regards,
  Dmitry

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Mysql Bug Database

[Sunil Gavaskar]

hi,
 Thanks for the mail.
Ive got the link from Mr.Zak Greant-MySql Company.
The link is bugs.mysql.com
But Im not getting any result for my search here!!!:-))

Regards
Sunil Gavaskar
Egor Egorov wrote:


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.



 





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Mysql Bug Database

[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, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql Bug Database

[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



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php





-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql Bug Database

[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://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[Nuno Lopes]

Doesn't you have any simpler answer??


Maybe installing the new version of mysql server - I have version 3.23.49 -
should do the trick



- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>; "MySQL 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 absolutely necessary and stop everything in the registry under run
> and stop anything in the start folder of the start menu and run the same
> tests.  If no positive results I would uninstall php completely and clean
> any reference in the registry of it and then install with everything still
> shut down.  Retest, if no progress do the same with mysql.  These are
> radical and time-consuming methods, but it seems as though it is broken.
If
> you absolutely need this fixed fast you might resort to paying the
> developers to give you a solution, although it may end up being what I
just
> listed, or it could be some simple fix that we aren't aware of.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> 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 pconnect the error is the same!
>
>
> - Original Message -
> From: "Larry Brown" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> 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_pconnect instead of
> connect
> > just to see what result you get.  I have read some unfavorable
statements
> > about using pconnect with a large number of hits so if it works you
should
> > read the comments about it on php.net.  Do a search for mysql_pconnect.
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388
> >
> > -Original Message-
> > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, January 06, 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 PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > 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 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 statement is successfully run however either h did not
> > > change or there is an internal error.  Try executing the sql from the
> > > command line to make sure it otherwise works.");
> > > }
> > >
> > > and see which is coming back.
> > >
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[Nuno Lopes]

@mysql_select_db("be"); // this doesn't fail, because only the second
(UPDATE) query fails. The first query (SELECT) is done!


- Original Message -
From: "Marek Kilimajer" <[EMAIL PROTECTED]>
To: "Nuno Lopes" <[EMAIL PROTECTED]>
Cc: "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:
>
> >I done a echo of Mysql_error and it returned:
> >'Nenhum banco de dados foi selecionado'
> >
> >(I have the mysql server in portuguese, but the translation is something
> >like '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='$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
> >>determining that the query did not work?  Are you manually checking the
> >>database?  You don't have anything in your code to check the status of
> >>this query.
> >>
> >>Perhaps this might get you somewhere:
> >>
> >>$qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");
> >>
> >>if (isset($qid) && mysql_affected_rows() == 1)
> >>{
> >>  echo "query executed";
> >>} else {
> >>  echo "query failed: " . mysql_error();
> >>}
> >>
> >>At least this way you might get some indication of where the problem is.
> >>
> >>CYA, Dave



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: [PHP] Re: PHP and MySQL bug

[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 name of
the computer with the db.  If the db is on a system other than the one with
the web server than you should check the network/network cards for errors.
The connection may be dropping because of communication.  If it is on the
same box then some other memory resident program etc may be causing the
connection to drop.  Refer to my previous post in re. to stopping services
etc.

* MySQL
*
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: [PHP] Re: PHP and MySQL bug

[Christensen, Dave]

Then go to c:\winnt\system32\drivers\etc and make the changes in the hosts
file that you will find there.

-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 1:25 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP] Re: PHP and MySQL 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 -
> From: "Nuno Lopes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, January 07, 2003 7:31 AM
> 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 the error is the same!
> >
> >
> > - Original Message -
> > From: "Larry Brown" <[EMAIL PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > 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_pconnect instead 
> > > of
> > connect
> > > just to see what result you get.  I have read some unfavorable
> statements
> > > about using pconnect with a large number of hits so if it works 
> > > you
> should
> > > read the comments about it on php.net.  Do a search for
mysql_pconnect.
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388
> > >
> > > -Original Message-
> > > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 06, 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 PROTECTED]>
> > > To: "MySQL List" <[EMAIL PROTECTED]>
> > > 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 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 statement is successfully run however either h 
> > > > did
not
> > > > change or there is an internal error.  Try executing the sql 
> > > > from
the
> > > > command line to make sure it otherwise works.");
> > > > }
> > > >
> > > > and see which is coming back.
> > > >
> > > >
> > > > Larry S. Brown
> > > > Dimension Networks, Inc.
> > > > (727) 723-8388



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[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 is located
>
>
> - Original Message -
> From: "Nuno Lopes" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, January 07, 2003 7:31 AM
> 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 the error is the same!
> >
> >
> > - Original Message -
> > From: "Larry Brown" <[EMAIL PROTECTED]>
> > To: "MySQL List" <[EMAIL PROTECTED]>
> > 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_pconnect instead of
> > connect
> > > just to see what result you get.  I have read some unfavorable
> statements
> > > about using pconnect with a large number of hits so if it works you
> should
> > > read the comments about it on php.net.  Do a search for
mysql_pconnect.
> > >
> > > Larry S. Brown
> > > Dimension Networks, Inc.
> > > (727) 723-8388
> > >
> > > -Original Message-
> > > From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, January 06, 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 PROTECTED]>
> > > To: "MySQL List" <[EMAIL PROTECTED]>
> > > 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 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 statement is successfully run however either h did
not
> > > > change or there is an internal error.  Try executing the sql from
the
> > > > command line to make sure it otherwise works.");
> > > > }
> > > >
> > > > and see which is coming back.
> > > >
> > > >
> > > > Larry S. Brown
> > > > Dimension Networks, Inc.
> > > > (727) 723-8388



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[Marek Kilimajer]

@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 in portuguese, but the translation is something
like '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='$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
determining that the query did not work?  Are you manually checking the
database?  You don't have anything in your code to check the status of
this query.

Perhaps this might get you somewhere:

$qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");

if (isset($qid) && mysql_affected_rows() == 1)
{
 echo "query executed";
} else {
 echo "query failed: " . mysql_error();
}

At least this way you might get some indication of where the problem is.

CYA, Dave
   




 



-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: [PHP] Re: PHP and MySQL bug

[Larry Brown]

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 in the start folder of the start menu and run the same
tests.  If no positive results I would uninstall php completely and clean
any reference in the registry of it and then install with everything still
shut down.  Retest, if no progress do the same with mysql.  These are
radical and time-consuming methods, but it seems as though it is broken.  If
you absolutely need this fixed fast you might resort to paying the
developers to give you a solution, although it may end up being what I just
listed, or it could be some simple fix that we aren't aware of.

Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388

-Original Message-
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 pconnect the error is the same!


- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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_pconnect instead of
connect
> just to see what result you get.  I have read some unfavorable statements
> about using pconnect with a large number of hits so if it works you should
> read the comments about it on php.net.  Do a search for mysql_pconnect.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 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 PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> 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 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 statement is successfully run however either h did not
> > change or there is an internal error.  Try executing the sql from the
> > command line to make sure it otherwise works.");
> > }
> >
> > and see which is coming back.
> >
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[Nuno Lopes]

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 the error is the same!


- Original Message -
From: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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_pconnect instead of
connect
> just to see what result you get.  I have read some unfavorable statements
> about using pconnect with a large number of hits so if it works you should
> read the comments about it on php.net.  Do a search for mysql_pconnect.
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>
> -Original Message-
> From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 06, 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 PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> 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 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 statement is successfully run however either h did not
> > change or there is an internal error.  Try executing the sql from the
> > command line to make sure it otherwise works.");
> > }
> >
> > and see which is coming back.
> >
> >
> > Larry S. Brown
> > Dimension Networks, Inc.
> > (727) 723-8388



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: [PHP] Re: PHP and MySQL bug

[Larry Brown]

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 get.  I have read some unfavorable statements
about using pconnect with a large number of hits so if it works you should
read the comments about it on php.net.  Do a search for mysql_pconnect.

Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388

-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 06, 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 PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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 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 statement is successfully run however either h did not
> change or there is an internal error.  Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP and MySQL bug

[Jennifer Goodie]

It would be helpful if you posted that error.  You can get it by changing
the die to

$queryr = mysql_query($query) or die(mysql_error());

Without knowing the error, you problem will be harder for everyone to debug.


-Original Message-
From: Nuno Lopes [mailto:[EMAIL PROTECTED]]
Sent: 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: "Larry Brown" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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 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 statement is successfully run however either h did not
> change or there is an internal error.  Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP and MySQL bug

[Nuno Lopes]

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 PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
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 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 statement is successfully run however either h did not
> change or there is an internal error.  Try executing the sql from the
> command line to make sure it otherwise works.");
> }
>
> and see which is coming back.
>
>
> Larry S. Brown
> Dimension Networks, Inc.
> (727) 723-8388
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: [PHP] Re: PHP and MySQL bug

[Nuno Lopes]

I done a echo of Mysql_error and it returned:
'Nenhum banco de dados foi selecionado'

(I have the mysql server in portuguese, but the translation is something
like '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='$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
> determining that the query did not work?  Are you manually checking the
> database?  You don't have anything in your code to check the status of
> this query.
>
> Perhaps this might get you somewhere:
>
> $qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'");
>
> if (isset($qid) && mysql_affected_rows() == 1)
> {
>   echo "query executed";
> } else {
>   echo "query failed: " . mysql_error();
> }
>
> At least this way you might get some indication of where the problem is.
>
> CYA, Dave



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re:PHP and MySQL bug

[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 sql statement is successfully run however either h did not
change or there is an internal error.  Try executing the sql from the
command line to make sure it otherwise works.");
}

and see which is coming back.


Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP and MySQL bug

[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 dowload. No caso de um mirror estar indisponível, utilize
outro.";
}
}
@MYSQL_CLOSE();
?>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: PHP and MySQL bug

[Stefan Hinz, iConnect \(Berlin\)]

Nuno,

> $r=MYSQL_QUERY("SELECT n,u,m,h FROM d WHERE id='$id'");
>
> /* Some code including "mysql_num_rows" and "mysql_fetch_array($r,
> MYSQL_NUM)"
> And the another query:
> */
>
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> /* i don't know why but this doesn't work!*/

It doesn't work because of the /* Some code including ... */ part ;-)

First thing, I would check if $h and $id really are what you expect them
to be, like:

$sql = "UPDATE d SET h='$h' WHERE id='$id'";
echo $sql;
MYSQL_QUERY($sql);

If this part is okay, then the problem lies within this myterious /*
Some code */.

Regards,
--
  Stefan Hinz <[EMAIL PROTECTED]>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 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'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 code including "mysql_num_rows" and "mysql_fetch_array($r,
> MYSQL_NUM)"
> And the another query:
> */
>
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> /* i don't know why but this doesn't work! But if I close the
connection and
> open another te query is done:*/
>
> MYSQL_CLOSE();
> MYSQL_CONNECT("localhost", "**user**", "**pass**");
> mysql_select_db("be");
> MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");
>
> ---
> I don't know why is this? Because I'm used to do more than a query per
> connection and this never happened!
> I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.
>
>
> I hope you solve this,
> Nuno Lopes
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: PHP and MySQL bug

[Larry Brown]

I'd like to try and see if I can find the problem as I write with PHP for
MySQL quite a bit.  However, without the specifics of how the script is
running as is, I can't tell where the problem is.  Write a quick script in
complete detail that does what your post is doing and I'll look for
anything.  Right now I have to assume certain steps are being made.  If they
are than I don't have a solution but I'd rather go with what you are
actually doing than go by my assumptions.  By all means hide the names of
the innocent and continue with a,b,c but just don't do "..."

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 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 code including "mysql_num_rows" and "mysql_fetch_array($r,
MYSQL_NUM)"
And the another query:
*/

MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");

/* i don't know why but this doesn't work! But if I close the connection and
open another te query is done:*/

MYSQL_CLOSE();
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");

---
I don't know why is this? Because I'm used to do more than a query per
connection and this never happened!
I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.


I hope you solve this,
Nuno Lopes



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

PHP and MySQL bug

[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'");

/* Some code including "mysql_num_rows" and "mysql_fetch_array($r,
MYSQL_NUM)"
And the another query:
*/

MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");

/* i don't know why but this doesn't work! But if I close the connection and
open another te query is done:*/

MYSQL_CLOSE();
MYSQL_CONNECT("localhost", "**user**", "**pass**");
mysql_select_db("be");
MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'");

---
I don't know why is this? Because I'm used to do more than a query per
connection and this never happened!
I'm using Win 2k, Apache 2.0.43, MySQL 3.23.49-nt and PHP 4.3.


I hope you solve this,
Nuno Lopes



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: MySQL BUG

[Bill Kratochvil]

<<<<
MsgBox 1 --> Data provider or other service returned an E_FAIL status.
>>>>

Been there, done that (so have a lot of people via my research).   Not
so much a MySql thing as it is a Microsoft thing - I was seeing similar
messages with not only MySql, but also Microsoft SQL (ADO and E_FAIL).  

Like Peter Simard, I decided to dump MyODBC and moved to VbMyQL from
http://www.icarz.com/mysql .   This decision came after a frustrating
evolution process (over a period of two months).  I started with RDO
and worked my way up to ADO 2.7.   With ADO 2.7 I was finally able to
get stability (something I've been very used to with Visual Foxpro).
Although 2.7 offered the highest reliability I still got errors - if a
date range was not valid (Foxpro uses empty dates) *OR* a memo field
(longtext) field was blank then I would get the E_FAIL status every
time.   My work around was to ensure that FOXPRO did not write an empty
memo field or date (date set to 1900/01/01 and memos to ""). This was a
flakey solution at best because if a client had one of these scenerios
then my database utility manager (for support folks) would not permit my
utility to access the data because of the dreaded E_FAIL message

I suspect if you replace all your LONGTEXT fields with a chr(20), if
they are empty, your problem will go away - flakey

Once I converted to ICARZ's VbMyQL I was able to actually focus on
programming, versus debugging and now have the beginning of an open
source MySql manager in the works (VB6).   I have not experienced *any*
crashes or errors.   As soon as I figure out how GNU works and can give
proper credit where credit is due (icarz) I'll be publishing the utility
and source.   It does'n't offer all the bells and whistles of ADO but at
least it works ;)

Bill Kratochvil
QuickCARE Developer
www.QuickCARE.com

P.S.  Visual Foxpro works seemlessly with MySql - havn't had any
problems since we started evaluating it (starting January we're moving
to a client/server SQL/MySql backend).   I almost canned the VB6 MySql
management utility (started thinking about doing it in Fox) but now that
I have a stable development environment for the data it's back on track
- I am really impressed with Visual Basic - I've only been working with
it for a few months but I trust the power of the open 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


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 Table for testing
'* Script to generate the table and insert a record *'
USE TEST;
CREATE TABLE Testing
(
 ID   INT   NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 msg  LONGTEXT  NOT NULL ,
 fld2 INT   NOT NULL
) TYPE=InnoDB;

INSERT INTO Testing(msg,fld2)
VALUES("",1);

2. Create a VB Project
'* VB CODE * '
'Step to create a VB project
'a. Open a new VB project
'b. Add reference of ADO 2.0 
'c. By default New form will be added to the project
'd. Copy the below code in it

Option Explicit
 
Private mcnn As New ADODB.Connection
 
Private Sub Form_Load()
On Error GoTo DispError
Dim rst As New ADODB.Recordset
Dim strSQL  As String
 
'change below connection string as per your db
settings
mcnn.Open "Driver={MySQL ODBC 3.51
Driver};SERVER=server;DB=test;UID=root;PWD=;OPTION=3"
strSQL = "SELECT * FROM Testing"

'*** Method 1.  Client side recordset ***'
'   If 'msg' field has blank string - below
code will give error while trying
'   to access Recordcount property, and
strangely Recordpointer is at EOF
'   If 'msg' field has value other than blank
string & NULL then it will run properly
With rst
Set .ActiveConnection = mcnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open Source:=strSQL, Options:=adCmdText
 'Normally below statement should return 1 but
on my m/c
 'it generates E_FAIL status error.
MsgBox .RecordCount 
 'it will display -1 as record pointer is at
EOF, Strange?
MsgBox "Record pointer: " & .AbsolutePosition 
 
End With
Set rst = Nothing ''

'*** Method 2.  Server side recordset ***'
' 

MySQL BUG

[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 Table for testing
'* Script to generate the table and insert a record *'
USE TEST;
CREATE TABLE Testing
(
 ID   INT   NOT NULL AUTO_INCREMENT PRIMARY KEY ,
 msg  LONGTEXT  NOT NULL ,
 fld2 INT   NOT NULL
) TYPE=InnoDB;

INSERT INTO Testing(msg,fld2)
VALUES("",1);

2. Create a VB Project
'* VB CODE * '
'Step to create a VB project
'a. Open a new VB project
'b. Add reference of ADO 2.0 
'c. By default New form will be added to the project
'd. Copy the below code in it

Option Explicit
 
Private mcnn As New ADODB.Connection
 
Private Sub Form_Load()
On Error GoTo DispError
Dim rst As New ADODB.Recordset
Dim strSQL  As String
 
'change below connection string as per your db
settings
mcnn.Open "Driver={MySQL ODBC 3.51
Driver};SERVER=server;DB=test;UID=root;PWD=;OPTION=3"
strSQL = "SELECT * FROM Testing"

'*** Method 1.  Client side recordset ***'
'   If 'msg' field has blank string - below
code will give error while trying
'   to access Recordcount property, and
strangely Recordpointer is at EOF
'   If 'msg' field has value other than blank
string & NULL then it will run properly
With rst
Set .ActiveConnection = mcnn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockPessimistic
.Open Source:=strSQL, Options:=adCmdText
 'Normally below statement should return 1 but
on my m/c
 'it generates E_FAIL status error.
MsgBox .RecordCount 
 'it will display -1 as record pointer is at
EOF, Strange?
MsgBox "Record pointer: " & .AbsolutePosition 
 
End With
Set rst = Nothing
''

'*** Method 2.  Server side recordset ***'
'   If 'msg' field has blank string -
below code will return NULL
'   If 'msg' field has value other than
blank string & NULL then it will return blank string
Set rst = mcnn.Execute(CommandText:=strSQL,
Options:=adCmdText)
MsgBox "Msg: " &
IIf(IsNull(rst.Fields("msg").Value), "",
rst.Fields("msg").Value)
''

Exit Sub
DispError:
MsgBox Err.Description, vbCritical
Resume Next
End Sub
'** END OF VB CODE **'

'/'
 
3. run the project.  It will display 3 messagebox. On
my m/c it display following messages 
MsgBox 1 --> Data provider or other service returned
an E_FAIL status.
MsgBox 2 --> Record Pointer: -1
MsgBox 3 --> Msg: 
 

Any help is appreciated.

 
- DEEP 

__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: is this a MySQL bug?

[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, 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.mysql.com/doc/en/LOCK_TABLES.html):
> 
> All tables that are locked by the current thread are
> automatically unlocked when the thread issues another LOCK
> TABLES, or when the connection to the server is closed. 
> 
> So you have to lock the two tables in the same SQL statement.
> 
> [snip]
> > i have also tried locking the tables with:
> > 
> > "lock tables jobs mechanics read"
> 
> Look at the syntax for locking more than one table -- it uses commas: 
> 
> LOCK TABLES jobs READ, mechanics READ
> 
> The way you're doing it, you seem to be locking 'jobs' with an alias 
> of 'mechanics'.
> 
> -- 
> Keith C. Ivey <[EMAIL PROTECTED]>
> Tobacco Documents Online
> http://tobaccodocuments.org
> Phone 202-667-6653



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: is this a MySQL bug?

[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.mysql.com/doc/en/LOCK_TABLES.html):

All tables that are locked by the current thread are
automatically unlocked when the thread issues another LOCK
TABLES, or when the connection to the server is closed. 

So you have to lock the two tables in the same SQL statement.

[snip]
> i have also tried locking the tables with:
> 
> "lock tables jobs mechanics read"

Look at the syntax for locking more than one table -- it uses commas: 

LOCK TABLES jobs READ, mechanics READ

The way you're doing it, you seem to be locking 'jobs' with an alias 
of 'mechanics'.

-- 
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: is this a MySQL bug?

[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 mechanics

CB> i do
CB> "lock tables jobs read"

CB> everything seemed ok so then i do

CB> "lock tables mechanics read"

CB> again no errors so i guess it worked..now i'm expecting to have my 2
CB> tables locked for read only.

Nope. Any LOCK TABLES releases any previous LOCK for the current
thread. So, only table 'mechanics' is locked.

CB> No I would try to query them with a JOIN but i keep getting the error so
CB> I tried querying each table indiviually but i still get the error:

CB> "select * from jobs,mechanics where jobs.mech_id=mechanics.mech_id and
CB> status!='completed'"

CB> error 1100

[skip]

CB> does all this indicate a bug in MySQL or am i doing something stupid?


What version of MySQL do you use? It works fine for me.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

is this a MySQL bug?

[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 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.

No I would try to query them with a JOIN but i keep getting the error so
I tried querying each table indiviually but i still get the error:

"select * from jobs,mechanics where jobs.mech_id=mechanics.mech_id and
status!='completed'"

error 1100

"select * from jobs"

error 1100

"select * from mechanics"

error 1100

"unlock tables"

"select * from jobs,mechanics where jobs.mech_id=mechanics.mech_id and
status!='completed'"

SUCCESS!

"select * from jobs"

SUCCESS!

"select * from mechanics"

SUCCESS AGAIN!

i have also tried locking the tables with:

"lock tables jobs mechanics read"

which seems to execute ok, but again when i try to query the tables i
get error 1100.


does all this indicate a bug in MySQL or am i doing something stupid?

thanks for your help



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

How to report MySQL bug

[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 manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: 3.23.53 can't change to user mysql bug

[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 fixed this problem.  Any thoughts?

RG> By the way, I install via RPM packages and I'm running RedHat Linux 7.1
RG> (kernel 2.4.18-ac3).

It's a "bug" in .53 :-( Run nscd and then run MySQL server.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

3.23.53 can't change to user mysql bug

[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 and I'm running RedHat Linux 7.1
(kernel 2.4.18-ac3).


Richard Gabriel, CTO
CoreSense Inc.
(866) 229-2804 Toll Free
(518) 580 9843 Fax



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Jean-Pierre Pelletier]

>Description:

I wanted to get the rows from table Health for which no match exists in the
table resulting from the inner join of Object and NMID.

I ran these queries in MySQL 3.23 and 4.0 with the same incorrect results.
They all work fine on MS SQL Server 2000 and on DB2 7.2.

With a DBMS supporting subqueries, I would have expressed it like this:
1)
SELECT DISTINCT
H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort
FROM
Health H
WHERE
NOT EXISTS (SELECT 0
FROM
Object O

INNER JOIN NMID N
ON O.Object_ID = N.Object_ID
WHERE
H.Appliance_ID= N.Appliance_ID
AND H.Health_NMID = N.NMID_NMID
AND H.Health_DeviceOrPOrt = O.Object_Table
)
AND H.Appliance_ID = 0;

Because MySQL lacks support for subqueries, 
I tried this SQL-92 compliant form of outer join, but MySQL reject it
with a syntax error.
2)
SELECT DISTINCT
H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort
FROM
Health H

LEFT OUTER JOIN  Object O
INNER JOIN NMID N
ON O.Object_ID = N.Object_ID
ON H.Appliance_ID = N.Appliance_ID
AND H.Health_DeviceOrPOrt = O.Object_Table
AND H.Health_NMID = N.NMID_NMID
WHERE
H.Appliance_ID = 0 
AND N.Object_ID IS NULL;
 

With a right outer join, no syntax errors is generated but the result is
incorrect.
3)
SELECT DISTINCT
H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort
FROM
 Object O

INNER JOIN NMID N
ON O.Object_ID = N.Object_ID

RIGHT OUTER JOIN Health H
ON H.Appliance_ID = N.Appliance_ID
AND H.Health_NMID = N.NMID_NMID
AND H.Health_DeviceOrPOrt = O.Object_Table
WHERE
H.Appliance_ID = 0 
AND O.Object_ID IS NULL;

This incorrectly returns no rows.

With MS SQL Server 2000 and DB2 v7.2 it makes no difference to test
O.Object_ID IS NULL
or N.Object_ID IS NULL, but with MySQL, it does but in both cases the result
is wrong.

Testing N.Object_ID incorrectly returns 4 rows:
+--+-+-+
| Appliance_ID | Health_NMID | Health_DeviceOrPort |
+--+-+-+
|0 |   1 | device  |
|0 |   2 | device  |
|0 |   3 | device  |
|0 |   4 | device  |
+--+-+-+

Adding parenthesis to force the inner join to be done before the outer join
didn't fix the problem.
4)
SELECT DISTINCT
H.Appliance_ID, H.Health_NMID, H.Health_DeviceOrPort
FROM
--  (Object O
 Object O

INNER JOIN NMID N
--  ON O.Object_ID = N.Object_ID)
ON O.Object_ID = N.Object_ID

RIGHT OUTER JOIN Health H
ON H.Appliance_ID = N.Appliance_ID
AND H.Health_NMID = N.NMID_NMID
AND H.Health_DeviceOrPOrt = O.Object_Table
WHERE
H.Appliance_ID = 0 
AND O.Object_ID IS NULL;

>How-To-Repeat:

CREATE TABLE Object (Object_ID INTEGER NOT NULL, Object_Table VARCHAR(6) NOT
NULL);
CREATE TABLE NMID (Appliance_ID INTEGER NOT NULL, NMID_NMID INTEGER,
Object_ID INTEGER NOT NULL);
CREATE TABLE Health (Appliance_ID INTEGER NOT NULL, Health_NMID INTEGER NOT
NULL, Health_DeviceOrPort VARCHAR(6) NOT NULL);

INSERT INTO Object(Object_ID, Object_Table) VALUES (101,'Device');
INSERT INTO Object(Object_ID, Object_Table) VALUES (201,'Device');
INSERT INTO Object(Object_ID, Object_Table) VALUES (202,'Port');
INSERT INTO Object(Object_ID, Object_Table) VALUES (302,'Port');

INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 1, 101);
INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 2, 201);
INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 2, 202);
INSERT INTO NMID (Appliance_ID, NMID_NMID, Object_ID) VALUES (0, 3, 302);

INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES
(0, 1, 'Device');
INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES
(0, 2, 'Device');
INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES
(0, 3, 'Device');
INSERT INTO Health (Appliance_ID, Health_NMID, Health_DeviceOrPort) VALUES
(0, 4, 'Device');

The following 2 rows should be returned

Appliance_ID Health_NMID Health_DeviceOrPort 
 --- --- 
   0   3 Device
   0   4 Device


>Fix:
Create a temporary table with the result of the inner join
and then use the temporary table in an outer join

>Submitter-Id: Jean-Pierre Pelletier
>Originator:root
>Organization: Peregrine Systems, Inc.
>MySQL support: [none | licence | email support | extended

Re: MySQL bug?

[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 -0500, Jeremy Tinley wrote:
>
>>Are you deleting any logs and not restarting the server after deleting?
>>We had this problem with httpd logs.  We'd move them off, but they were
>>still open at the old file system location until a httpd restart.
>>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail 
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL bug?

[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 deleting?
> We had this problem with httpd logs.  We'd move them off, but they were
> still open at the old file system location until a httpd restart.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL bug?

[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 short window to play with before the machine will just die.  The
output from df shows:

machine:/var# df -k .
Filesystem   1k-blocks  Used Available Use% Mounted on
/dev/hda3   497861345390126767  74% /var

whereas the output from du returns:

machine:/var# du -sk /var
145841  /var

obviously there is a discrepency here.  I ran lsof on the /var directory
and noticed:

machine:/var# lsof +D /var
COMMAND PID USER   FD   TYPE DEVICESIZENODE NAME
mysqld10917 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld10917 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld10917 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld10917 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld10917 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld10931 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld10931 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld10931 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld10931 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld10931 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld10932 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld10932 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld10932 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld10932 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld10932 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld10933 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld10933 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld10933 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld10933 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld10933 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld30032 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld30032 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld30032 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld30032 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld30032 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld30146 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld30146 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld30146 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld30146 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld30146 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld30193 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld30193 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld30193 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld30193 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld30193 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock
mysqld30767 root3u  unix 0xc2367cc0  144707
/var/run/mysqld/mysqld.sock
mysqld30767 root7u  unix 0xc600f660 4464830
/var/run/mysqld/mysqld.sock
mysqld30767 root   24u  unix 0xc56f2c80 4465358
/var/run/mysqld/mysqld.sock
mysqld30767 root   62u  unix 0xc1bd7c80 4468136
/var/run/mysqld/mysqld.sock
mysqld30767 root   82u  unix 0xc2484980 4465577
/var/run/mysqld/mysqld.sock

Is this some sort of unlinking bug?  Naturally, a reboot fixes our
problems for a couple of months.  As I said in the beginning of the
email, I've got a few days/a week before I REALLY need to reboot this
machine.  So I'd love to get some help on chasing this down, in case it
is a bug and we need to get some data from it.

Mark

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the l

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

[Andis]

From: "Andis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>,
	"Victoria Reznichenko" <[EMAIL PROTECTED]>
References: <001d01c2394e$85803740$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <003601c239ea$f0f7d720$[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <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="=_NextPart_000_002C_01C23A4E.20042D80"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.

This is a multi-part message in MIME format.

--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: text/plain;
	charset="iso-8859-4"
Content-Transfer-Encoding: 7bit

Here is my conf file. Also I send my Excel file, where with yellow is marked
symbols which is used in Latvian language. Of course, also we use such
symbols as W, X, Y etc. This means, for right sorting all symbols with ascii
code from 32 to 255 better is include in character-set definition. I hope,
that you'll see xls file as I see :)).

Andis

- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 3:41 PM
Subject: Re: Re: Re: MySQL bug? - problems with character-set


> 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 included isn't correct.
>
> Seems, your to_lower[] array is not correct. Unfortunately, I don't
> know Latvian language and can't tell you what is wrong :(
>
> You say that included character set is not correct. Do you mean
> cp1257 ? If so, can you explain what is wrong with character set?
> Can you provide your own character set with explanation of changes
> that you did?
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

--=_NextPart_000_002C_01C23A4E.20042D80
Content-Type: application/octet-stream;
	name="latvian.conf"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
	filename="latvian.conf"

# Configuration file for the latvian character set.
# Created for case-sensitive record search=0A=
# Created accord with windows-1257 (iso-8859-4) codepage=0A=
# Created by Andis Grasis & Rihards Grasis=0D e-mail:[EMAIL PROTECTED]=0A=

# The ctype array must have 257 elements.
  00
  20  20  20  20  20  20  20  20  20  28  28  28  28  28  20  20
  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20  20
  48  10  10  10  10  10  10  10  10  10  10  10  10  10  10  10
  84  84  84  84  84  84  84  84  84  84  10  10  10  10  10  10
  10  81  81  81  81  81  81  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  01  01  01  01  10  10  10  10  10
  10  82  82  82  82  82  82  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  02  02  02  02  10  10  10  10  20
  01  20  10  20  10  10  00  00  20  10  20  10  20  10  10  10
  20  10  10  10  10  10  10  10  20  00  20  10  20  10  10  20
  48  20  10  10  10  20  10  10  10  10  01  10  10  10  10  01
  10  10  10  10  10  10  10  10  10  10  02  10  10  10  10  02
  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01  01
  01  01  01  01  01  01  01  10  01  01  01  01  01  01  01  02
  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02  02
  02  02  02  02  02  02  02  10  02  02  02  02  02  02  02  10

# The to_lower array must have 256 elements.
  00  01  02  03  04  05  06  07  08  09  0A  0B  0C  0D  0E  0F
  10  11  12  13  14  15  16  17  18  19  1A  1B  1C  1D  1E  1F
  20  21  22  23  24  25  26  27  28  29  2A  2B  2C  2D  2E  2F
  30  31  32  3

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

[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 included isn't correct.

Seems, your to_lower[] array is not correct. Unfortunately, I don't
know Latvian language and can't tell you what is wrong :(

You say that included character set is not correct. Do you mean
cp1257 ? If so, can you explain what is wrong with character set?
Can you provide your own character set with explanation of changes
that you did?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[Andis]

I created character-set myself. Here, in Latvia, we use windows-1257.
Problem is, when I use MySQL under Linux, conversation occurs better. Under
windows98 I have problems as I wrote before. Cheracter-set I created myself,
because included isn't correct.

Andis



- Original Message -
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
> 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 to lower case and vice versa you
should specify proper character set.
>
> If you look into *.conf files in the charsets dir you can see 4 arrays
there. Two of them,
> to_lower[] and to_upper[], contain the lowercase and uppercase
> characters corresponding to each member of the character set.
>
> What character set do you use in MySQL? And what character set is used for
Latvian language?
>
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

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

[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 case to lower case and vice versa you should specify 
proper character set.

If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of 
them,
to_lower[] and to_upper[], contain the lowercase and uppercase
characters corresponding to each member of the character set.

What character set do you use in MySQL? And what character set is used for Latvian 
language?




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL bug? - problems with character-set

[Andis]

Hi!

It's just a simple example, because I don't want send latvian-specific
symbols. This problem occurs with latvian-specific symbols only.
Configuration file I cheked some 4-5 times. I'm confused now.

Regards from Latvia!

Andis Grasis

- Original Message -
From: "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 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
> AG> case-sensitive configuration).
> AG> Result under Linux looks better, under window - wrong, because result
> AG> contain lower-case and upper-case symbols together
> AG> It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'
> AG> Now I feel confused, hov I can test, is my conf file.
>
> Strange ..
> on my w2k and RedHat 7.1 box I got correct results:
>
> mysql> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS');
> +--+
> | lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') |
> +--+
> | here i tiped in specific my language characters  |
> +--+
> 1 row in set (0.00 sec)
>
>
> What Windows do you use? How did you install MySQL from binary or from
source?
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL bug? - problems with character-set

[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
AG> case-sensitive configuration).
AG> Result under Linux looks better, under window - wrong, because result
AG> contain lower-case and upper-case symbols together
AG> It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'
AG> Now I feel confused, hov I can test, is my conf file.

Strange ..
on my w2k and RedHat 7.1 box I got correct results:

mysql> select lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS');
+--+
| lcase('HERE I TIPED IN SPECIFIC MY LANGUAGE CHARACTERS') |
+--+
| here i tiped in specific my language characters  |
+--+
1 row in set (0.00 sec)


What Windows do you use? How did you install MySQL from binary or from source?

-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL bug? - problems with character-set

[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, under window - wrong, because result
contain lower-case and upper-case symbols together
It's loks like this:'HErE I tIPED MY LaNGUaGE CHaraCtERS'

Now I feel confused, hov I can test, is my conf file.

Andis Grasis



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Bug - bug list rejected

[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 keeps
> assuming it is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.

This is a classic. :)

Your field is defined as a TINYINT, an signed single byte datatype with a
max value of 127.

You should redifine the field type to a SMALLINT, probably even a UNSIGNED
SMALLINT.

http://www.mysql.com/doc/C/o/Column_types.html >

--
Roger


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Bug - bug list rejected

[Gurhan Ozen]

I don't think this is a bug, you probably choose TINYINT datatype for the
column, and the maximum value a TINYINT column can have is 127, so anything
over 127 will automatically be changed to 127 silently by MySQL. Choose an
appropriate column datatype for your field.
See: http://www.mysql.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.
>
> 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 assuming it
is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.
>
> More detailed explanation is here:
>
> http://www.sitepointforums.com/showthread.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.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: MySQL Bug - bug list rejected

[Jocelyn Fournier]

Hi,

Your column comid is probably declared as a tinyint which has a range
between -128 and 127 (for not UNSIGNED column).
If you want to allow larger values, change the column type accordingly.

(Take a look here :

http://www.mysql.com/doc/C/o/Column_types.html
)

Regards,
  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 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 assuming it
is
> "127"  No matter what I do, I've renamed the variable, renamed the field,
> changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
> making up this number, there is no place it could get it.
>
> More detailed explanation is here:
>
> http://www.sitepointforums.com/showthread.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.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL Bug - bug list rejected

[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 assuming it is
"127"  No matter what I do, I've renamed the variable, renamed the field,
changed my INSERT syntax a couple of times.  127, 127 ,127.  MySQL is just
making up this number, there is no place it could get it.

More detailed explanation is here:

http://www.sitepointforums.com/showthread.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.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Followup: Mysql Bug Report, Random crashes, reason unknown

[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.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Mysql Bug Report, Random crashes, reason unknown

[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:  Random MySQL crashes (1-2 every 24h)
GW>Severity:  [ serious ]
GW>Priority:  [ medium ]
GW>Category:  mysql
GW>Class: [ sw-bug ]
GW>Release:   mysql-3.23.49a (Official MySQL Binary)

GW>Environment:
GW> System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown
GW> Architecture: i686


GW> I hope someone can help us on this one .. i guess i am lost.
GW> The distribution  we are using is SuSE 7.3

Signal 4 means "illegal instruction", when your binary is not
compatible with your architecture... Signal 11 means "Segmentation fault", when 
the program cames out of it's address space. 

In your case, the combination of these two most likely means broken hardware as SIGILL 
is _very_ unlikely to happen, if not impossible.

GW> Thanks for your Help in advance.
GW> Gavin Woodhatch
GW> NetZone Ltd.





-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Mysql Bug Report, Random crashes, reason unknown

[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:  [ medium ]
>Category:  mysql
>Class: [ sw-bug ]
>Release:   mysql-3.23.49a (Official MySQL Binary)

>Environment:
System: Linux db1 2.4.10-4GB #1 Tue Sep 25 12:33:54 GMT 2001 i686 unknown
Architecture: i686

Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs
gcc version 2.95.3 20010315 (SuSE)
Compilation info: CC='gcc'  CFLAGS='-Wimplicit -Wreturn-type -Wid-clash-51 -Wswi
tch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wimplicit-function-dec
-Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=penti
umpro -O3 -fno-omit-frame-pointer'  CXX='gcc'  CXXFLAGS='-Wimplicit -Wreturn-typ
e -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wi
mplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compare -Wwrite-strings
 -Woverloaded-virtual -Wextern-inline -Wsign-promo -Wreorder -Wctor-dtor-privacy
 -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentium
pro -O3 -fno-omit-frame-pointer'  LDFLAGS=''
LIBC:
-rwxr-xr-x1 root root  1384168 Sep 20  2001 /lib/libc.so.6
-rw-r--r--1 root root 25215580 Sep 20  2001 /usr/lib/libc.a
-rw-r--r--1 root root  178 Sep 20  2001 /usr/lib/libc.so
Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --wi
th-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all
-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-gli
bc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra
-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimp
licit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subsc
ripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Wsign-compa
re -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFL
AGS=-Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -W -Wc
har-subscripts -Wformat -Wimplicit-function-dec -Wimplicit-int -Wparentheses -Ws
ign-compare -Wwrite-strings -Woverloaded-virtual -Wextern-inline -Wsign-promo -W
reorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-excepti
ons -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc


Attached Here are the last two Stack Traces, and logfile entrys i dont know if there 
right, i
grabbed the mysqld.sym from the server.rpm, but am using the tar.gz
binary package. I did not find the mysqld.sym.gz in the tar.gz
archiv.

here is the bit of the log file for our last crash:

mysqld got signal 4;

Stack range sanity check OK, backtrace follows:
0x806db54
0x811c328
0x806afdd
0x808fb1d
0x8092cb8
0x808c1db
0x807472a
0x8078828
0x8073904
0x8072cb7
Stack trace seems successful - bottom reached

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x83a9c78 = SELECT id FROM dvdone_rented WHERE id_movie = '10089'
and state != 'back'
thd->thread_id=23860

And here is the resolved Stack Trace .. (hope its right ..)

db1:/tmp # /usr/local/mysql/bin/resolve_stack_dump -s /tmp/mysqld.sym -n 
/tmp/mysql.stack1
0x806db54 server_init__Fv + 8
0x811c328 pthread_mutex_trylock + 8
0x806afdd mysql_lock_tables__FP3THDPP8st_tableUi + 573
0x808fb1d make_join_select__FP4JOINP10SQL_SELECTP4Item + 713
0x8092cb8 create_myisam_tmp_table__FP8st_tableP15TMP_TABLE_PARAMUi + 336
0x808c1db 
mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result
 + 3611
0x807472a do_command__FP3THD + 3466
0x8078828 
add_table_to_list__FP11Table_identP10lex_stringb13thr_lock_typePt4List1Z6StringT4 + 280
0x8073904 mysql_table_dump__FP3THDPcT1i + 260
0x8072cb7 check_for_max_user_connections__FPCciT0 + 311

Here is some more info on the 2nd last crash

mysqld got signal 11;

key_buffer_size=16773120
record_buffer=1044480
sort_buffer=4194296
max_used_connections=28
max_connections=150
threads_connected=19
It is possible that mysqld could use up to
key_buffer_size + (record_buffer + sort_buffer)*max_connections = 783778 K
bytes of memory
Hope that's ok, if not, decrease some variables in the equation

Stack range sanity check OK, backtrace follows:
0x806db54
0x811c328
0xb3
0x806981c
0x8069726
0x80679f2
0x809827d
0x8092f76
0x8092c80
0x808c1db
0x807472a
0x8078828
0x8073904
0x8072cb7
Stack trace seems successful - bottom reached

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x83c2138 = SELECT * FROM fm_ad WHERE expired > '1019424115'
thd->thread_id=26095


And here again is the resolved stack Trace :

Re: MySQL Bug

[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 for the files existence. Any Idea?

The message error shows that you had installed on another directory
than the default c:\mysql, so you need to have the my.cnf or my.ini
file with:

[mysqld]
basedir=c:\mysqin
datadir=c:\mysqin\data

Regards,
Miguel



-- 
For technical support contracts, goto https://order.mysql.com/
__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /Miguel A. Solórzano <[EMAIL PROTECTED]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, FullTime Developer
/_/  /_/\_, /___/\___\_\___/   Mogi das Cruzes - São Paulo, Brazil
<___/   www.mysql.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL Bug

[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?

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

MySQL++ (?) bug

[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();
}
catch ( BadQuery er )
{
std::cout << er.error.c_str() << endl;
}
}

Last lines of strace - libc 2.2.5, linux 2.4.18 smp (the same result for
libc 2.2.4, linux 2.4.16 smp).:
..
open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0644, st_size=1897, ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x40016000
read(3, "# You can copy this to one of:\n#"..., 4096) = 1897
read(3, "", 4096)   = 0
close(3)= 0
munmap(0x40016000, 4096)= 0
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such
file or directory)
open("/home/projects/kia2/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No
such file or directory)
--- SIGSEGV (Segmentation fault) ---
+++ killed by SIGSEGV +++

On another server (libc 2.2.4, linux 2.4.3, MySQL++ 1.7.9) the same place:

open("/etc/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or
directory)
open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such
file or directory)
open("/home/baubas/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file
or directory)
socket(PF_UNIX, SOCK_STREAM, 0) = 3
fcntl64(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sin_family=AF_UNIX, path="/var/run/mysqld/mysqld.sock"}, 110)
= -1 ENOENT (No such file or directory)
shutdown(3, 2 /* send and receive */)   = 0
close(3)= 0
brk(0x8058000)  = 0x8058000
brk(0x805a000)  = 0x805a000
fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 2), ...}) = 0
old_mmap(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0)
= 0x40016000
write(1, "Can\'t connect to local M"..., 93) = 93
munmap(0x40016000, 4096)= 0
_exit(0)= ?

I don't get where is the problem, because it crashes only on the second
server. Any help would be appreciated.

Thanks in advance :)

.:: Andrius Armonas ::.
.:: [EMAIL PROTECTED] ::.
.:: http://baubas.andrius.org ::.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql bug

[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 manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql bug

[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 *item) const  // Only doing this on conds
+/*
+  This function is only called when comparing items in the WHERE clause
+*/
+
+bool Item::eq(const Item *item, bool binary_cmp) const
 {
   return type() == item->type() && name && item->name &&
 !my_strcasecmp(name,item->name);
 }
 
+bool Item_string::eq(const Item *item, bool binary_cmp) const
+{
+  if (type() == item->type())
+  {
+if (binary_cmp)
+  return !stringcmp(&str_value, &item->str_value);
+return !sortcmp(&str_value, &item->str_value);
+  }
+  return 0;
+}
+
+
 /*
   Get the value of the function as a TIME structure.
   As a extra convenience the time structure is reset on error!
@@ -202,7 +218,7 @@
   return result_field->val_int();
 }
 
-bool Item_field::eq(const Item *item) const
+bool Item_field::eq(const Item *item, bool binary_cmp) const
 {
   return item->type() == FIELD_ITEM && ((Item_field*) item)->field == field;
 }
@@ -245,7 +261,8 @@
   str->append('\'');
 }
 
-bool Item_null::eq(const Item *item) const { return item->type() == type(); }
+bool Item_null::eq(const Item *item, bool binary_cmp) const
+{ return item->type() == type(); }
 double Item_null::val() { null_value=1; return 0.0; }
 longlong Item_null::val_int() { null_value=1; return 0; }
 /* ARGSUSED */

--- 1.12/sql/item.h Wed Oct 31 18:27:48 2001
+++ 1.13/sql/item.h Fri Mar 22 14:03:42 2002
@@ -56,7 +56,7 @@
   virtual void save_org_in_field(Field *field)
 { (void) save_in_field(field); }
   virtual bool send(String *str);
-  virtual bool eq(const Item *) const;
+  virtual bool eq(const Item *, bool binary_cmp) const;
   virtual Item_result result_type () const { return REAL_RESULT; }
   virtual enum Type type() const =0;
   virtual double val()=0;
@@ -109,7 +109,7 @@
   {}
   Item_field(Field *field);
   enum Type type() const { return FIELD_ITEM; }
-  bool eq(const Item *item) const;
+  bool eq(const Item *item, bool binary_cmp) const;
   double val();
   longlong val_int();
   String *val_str(String*);
@@ -138,7 +138,7 @@
   Item_null(char *name_par=0)
 { maybe_null=null_value=TRUE; name= name_par ? name_par : (char*) "NULL";}
   enum Type type() const { return NULL_ITEM; }
-  bool eq(const Item *item) const;
+  bool eq(const Item *item, bool binary_cmp) const;
   double val();
   longlong val_int();
   String *val_str(String *str);
@@ -247,6 +247,7 @@
   void make_field(Send_field *field);
   enum Item_result result_type () const { return STRING_RESULT; }
   bool basic_const_item() const { return 1; }
+  bool eq(const Item *item, bool binary_cmp) const;
   Item *new_item() { return new Item_string(name,str_value.ptr(),max_length); }
   String *const_string() { return &str_value; }
   inline void append(char *str,uint length) { str_value.append(str,length); }
@@ -306,7 +307,8 @@
   Item_ref(Item **item, char *table_name_par,char *field_name_par)
 :Item_ident(NullS,table_name_par,field_name_par),ref(item) {}
   enum Type type() const   { return REF_ITEM; }
-  bool eq(const Item *item) const  { return (*ref)->eq(item); }
+  bool eq(const Item *item, bool binary_cmp) const
+  { return (*ref)->eq(item, binary_cmp); }
   ~Item_ref() { if (ref) delete *ref; }
   double val()
   {

--- 1.46/sql/item_func.cc   Thu Dec 27 02:04:27 2001
+++ 1.47/sql/item_func.cc   Fri Mar 22 14:03:42 2002
@@ -148,7 +148,7 @@
   str->append(')');
 }
 
-bool Item_func::eq(const Item *item) const
+bool Item_func::eq(const Item *item, bool binary_cmp) const
 {
   /* Assume we don't have rtti */
   if (this == item)
@@ -160,7 +160,7 @@
   func_name() != item_func->func_name())
 return 0;
   for (uint i=0; i < arg_count ; i++)
-if (!args[i]->eq(item_func->args[i]))
+if (!args[i]->eq(item_func->args[i], binary_cmp))
   return 0;
   return 1;
 }
@@ -1882,7 +1882,7 @@
   str->append(')');
 }
 
-bool Item_func_get_user_var::eq(const Item *item) const
+bool Item_func_get_user_var::eq(const Item *item, bool binary_cmp) const
 {
   /* Assume we don't have rtti */
   if (this == item)
@@ -2135,7 +2135,7 @@
   return 1;
 }
 
-bool Item_func_match::eq(const Item *item) const
+bool Item_func_match::eq(const Item *item, bool binary_cmp) const
 {
   if (item->type() != FUNC_ITEM)
 return 0;
@@ -2146,7 +2146,7 @@
   Item_func_match *ifm=(Item_func_match*) item;
 
   if (key == ifm->key && table == ifm->table &&
-  key_item()->eq(ifm->key_item()))
+  key_item()->eq(ifm->key_item(), binary_cmp))
 return 1;
 
   return 0;

--- 1.24/sql/item_func.hThu Dec 27 02:04:27 2001
+++ 1.25/sql/item_func.hFri Mar 22 14:03:42 2002
@@ -98,7 +98,7 @@
   void make_field(Send_field *field);
   table_map used_tables() const;
  

mysql bug

[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(10) NOT NULL default '',
  TEX char(70) NOT NULL default '',
  PRIMARY KEY  (asinfoID),
  KEY IdxArt (art),
  KEY IdxKnr (KNR),
  KEY IdxArtnr (ARTNR)
) TYPE=MyISAM;

INSERT INTO asinfo VALUES (27,'j','','','','',''), []

# there are 620 'J' and 667 'j' records.

select count(*) from asinfo where upper(art) = 'J';
select count(*) from asinfo where art = 'J' or art = 'j';
select count(*) from asinfo where art = 'j' or art = 'J';

mysql OS/2 3.23.42
count(*)
1287
count(*)
620
count(*)
667

mysql linux 3.23.44
count(*)
1287
count(*)
620
count(*)
667

So the Linux version is doing it the same way. For me it's a bug in
both versions. Please reply. Thanks.

tam
-- 
Ducati 750SS '92 -> on the road again
http://tam.belchenstuermer.de/
Uptime 230d 22h 55m 04s

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: is this a mysql Bug ?

[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 a
value in '-MM-DD' or MMDD format, depending on whether the function
is used in a string or numeric context"

Use this syntax:

mysql> select curdate() - interval 2 day;
++
| curdate() - interval 2 day |
++
| 2002-02-28 |
++
1 row in set (0.01 sec)

--
Roger
query


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: is this a mysql Bug ?

[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 this number 
you substract.

When dealing with dates use the Date/Timefunctions described in the Manual.

Regards

Georg

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

is this a mysql Bug ?

[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)

mysql> select curdate()-1;
+-+
| curdate()-1 |
+-+
|20020301 |
+-+
1 row in set (0.00 sec)

mysql> select curdate()-2;
+-+
| curdate()-2 |
+-+
|20020300 |
+-+
1 row in set (0.00 sec)

mysql> select curdate()-3;
+-+
| curdate()-3 |
+-+
|20020299 |
+-+
1 row in set (0.00 sec)

mysql>

*


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql bug in TEXT type

[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 and
decided to change it to

  myisamchk --safe-recover --extend-check --sort-index */*.MYI

On one of the machines this generated lots and lots of errors; lots of

  Found block with too small length at #; Skipped

And several

  Found link that points at ## (outside data
  file) at ##

And several

  Found block that points outside data file at ##

One annoying thing is that myisamchk never fixed these problems; each
time we ran it the same errors were there.  We tried copying the db
files to a different machine with the latest version of mysql; no
cigar.

Then we tried dumping the database using mysqldump and then importing
that into a fresh database, ran the above myisamchk and even that
generated the *SAME ERRORS*!  No complaints whatsoever from mysql
during the import.

Then I started searching the mailing list archives and I noticed one
response by Widenius suggesting using a binary version from mysql.com
so I downloaded the mysql-3.23.47-sun-solaris2.8-sparc and installed
it, input the output from mysqldump, ran the above myisamchk; that
generated the *SAME ERRORS*!

Then I decided to eyeball the output of mysqldump and see if there was
anything suspicious looking.  It was mainly one of the tables that got
a lot of these errors.  Here's its definition from mysqldump:

CREATE TABLE time_edit (
  teid int(10) unsigned NOT NULL auto_increment,
  classid int(10) unsigned default NULL,
  empid int(11) default NULL,
  starttime int(10) unsigned default NULL,
  duration smallint(5) default NULL,
  facid tinyint(4) default NULL,
  comment text,
  PRIMARY KEY  (teid),
  KEY index_te_st (starttime,empid)
) TYPE=MyISAM;

The only thing that made me suspicious was the COMMENT field that's of
type TEXT.  On a hunch I decided to change it to VARCHAR(255) and
Voila! when I ran the above myisamchk the messages were gone.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql bug in TEXT type

[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 and
decided to change it to

  myisamchk --safe-recover --extend-check --sort-index */*.MYI

On one of the machines this generated lots and lots of errors; lots of

  Found block with too small length at #; Skipped

And several

  Found link that points at ## (outside data
  file) at ##

And several

  Found block that points outside data file at ##

One annoying thing is that myisamchk never fixed these problems; each
time we ran it the same errors were there.  We tried copying the db
files to a different machine with the latest version of mysql; no
cigar.

Then we tried dumping the database using mysqldump and then importing
that into a fresh database, ran the above myisamchk and even that
generated the *SAME ERRORS*!  No complaints whatsoever from mysql
during the import.

Then I started searching the mailing list archives and I noticed one
response by Widenius suggesting using a binary version from mysql.com
so I downloaded the mysql-3.23.47-sun-solaris2.8-sparc and installed
it, input the output from mysqldump, ran the above myisamchk; that
generated the *SAME ERRORS*!

Then I decided to eyeball the output of mysqldump and see if there was
anything suspicious looking.  It was mainly one of the tables that got
a lot of these errors.  Here's its definition from mysqldump:

CREATE TABLE time_edit (
  teid int(10) unsigned NOT NULL auto_increment,
  classid int(10) unsigned default NULL,
  empid int(11) default NULL,
  starttime int(10) unsigned default NULL,
  duration smallint(5) default NULL,
  facid tinyint(4) default NULL,
  comment text,
  PRIMARY KEY  (teid),
  KEY index_te_st (starttime,empid)
) TYPE=MyISAM;

The only thing that made me suspicious was the COMMENT field that's of
type TEXT.  On a hunch I decided to change it to VARCHAR(255) and
Voila! when I ran the above myisamchk the messages were gone.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail 
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

mysql bug

[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 up to 3.23.47 which I
downloaded today all they fail in the binary test. The most obvious
reason is some locale/charsets related code. MySQL configuring
options was

--with-charset=cp1251 --with-extra-charsets=koi8_ru --with-mysqld-user=mysql
--enable-thread-safe-client

(I suppose, only *charset options value). So it's maybe needed to diff
the code with that one from 3.23.43 and find the mangled piece. Thank
you for your great product.

--- mysql-test/r/binary.result  Thu Dec 27 15:37:53 2001
+++ mysql-test/r/binary.reject  Sat Jan 26 22:18:08 2002
@@ -1,13 +1,13 @@
 name
-å
 ä
+å
 ö
 concat("*",name,"*")
-*å*
 *ä*
+*å*
 *ö*
 min(name)  min(concat("*",name,"*"))   max(name)   
max(concat("*",name,"*"))
-å  *å* ö   *ö*
+ä  *ä* ö   *ö*
 name
 ä
 å
@@ -20,6 +20,7 @@
 ä  *ä* ö   *ö*
 name
 ä
+å
 ö
 name
 ä

SY, Seva Gluschenko, just stranger on The Road. | http://gvs.rinet.ru/
Cronyx Plus / RiNet network administrator.  | GVS-RIPE | GVS3-RIPN



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql bug

[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 to Manual but im
> not getting the my.cnf file any where in that folder i
> searche all the computer but i didnt get that my.cnf
> file  what happend to that my.cnf file please let
> meknow about that my.cnf file 

There is no default my.cnf file installed. You have to create your own
one. There come some sample config files with the distribution called
e.g. my-small.cnf (medium, large and huge). You can copy one of them
to start with.

For more information about the config file, have a look at the fine
manual: http://www.mysql.com/doc/O/p/Option_files.html

> please mail me back
> thanks and regards
> kiran.

Bye,

Benjamin.

-- 
[EMAIL PROTECTED]

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php