[MYSQL - Windows Version 3.23.41] Invalid Field Size

2001-09-02 Thread Chee Chong Hwa
Hi My PC environment are as follows : - Pentoum 933 Mhz - 1.128G RAM - Windows 2000, SP2 - Raid 5 - 32G HDD - MYSQL Windows version 3.23.41 - MYODBC 2.50 - Delphi 6 Using the Delphi Datapump, I successfully ported 200 tables to the test database. Using ADO connection, I successufully connected

MySQL Delphi

2001-09-02 Thread Ales Vaupotic
Hello, I've got a problem with MySQL 3.23.41 on Solaris 8 and Delphi 5 Ent. on Windows 98. I installed the latest MyODBC a week ago and am using ADO components to connect to the server. The connection itself works but when I open the field editor of a table, char(50) is interpreted in Delphi as

Re: Problem while compiling mysql-4.0

2001-09-02 Thread Michael Widenius
Hi! Fournier == Fournier Jocelyn Fournier writes: Fournier Sorry, I've just seen the problem has been already fixed by tonu in the Fournier mysql-4.0 tree. If you have any problems compiling MySQL 4.0 from the bk repository, please post these question to [EMAIL PROTECTED] list. I am just

RE: Bulk mailing

2001-09-02 Thread John Coggeshall
Sure... ?php // connect to mysql // perform query to get e-mails while($row = mysql_fetch_row($result)) { mail($row['email'], $subject, $content); } mysql_close(); ? |-Original Message- |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] |Sent: Saturday,

Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Jari Aalto
I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box Failed to install service In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done this 1 time(s). The following

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Sinisa Milivojevic
Simon J Mudd writes: On Sat, 1 Sep 2001, Sinisa Milivojevic wrote: This gives me: [sjmudd@phoenix sjmudd]$ mysql --host=phoenix Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 20 to server version: 3.23.36 cut Having not been subscribed to this

Re: Is mysql_query() reentrant ?

2001-09-02 Thread Sinisa Milivojevic
Marc A. Mueller writes: Hi, I want my application (LINUX, C++) to send periodically an information to a MySQL-Server, regardless of whats it is actually doing at the moment. Can I use the alarm signal for this (is mysql_query() signal-reentrant) ? I'm using the normal mysql-library,

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Simon J Mudd
On Sun, 2 Sep 2001, Sinisa Milivojevic wrote: What does SHOW GRANTS presents for that user ?? [sjmudd@phoenix sjmudd]$ mysql --host=phoenix Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.36 Type 'help;' or '\h' for help. Type

Re: mysqld or kernel bug?

2001-09-02 Thread Sinisa Milivojevic
Robert La Ferla writes: I forgot to include the info on the zombied mysql process. mysql10389 0.0 0.0 00 pts/0Z12:51 0:00 [mysqld defunct] Robert That was definitely kernel. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa

Re: Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Sinisa Milivojevic
Jari Aalto writes: I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box Failed to install service In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done

Re: mysqlshow shows list of blank (not empty) tables (FAQ?)

2001-09-02 Thread Simon J Mudd
[EMAIL PROTECTED] (Sinisa Milivojevic) writes: Also, there was a bug in 3.23.36. Can you try .41 ?? I've just upgraded to 3.23.41-1 (rpm) and things now seem fine. [sjmudd@phoenix sjmudd]$ mysqlshow --host=phoenix ++ | Databases| ++ | bounces| |

Re: Mysql 3.23.41 fails to install as service on Win 2000 Professional

2001-09-02 Thread Dmitry Mityugov
I'm using Ver 3.23.41-max-debug for Win95/Win98 on i32 And command mysqld-nt --install Displays error dialog box Failed to install service In Event viewer the messages simply says: The MySql service terminated unexpectedly. It has done this 1 time(s). The

Re: WHERE IN ( MAX ) in MySQL

2001-09-02 Thread Benjamin Pflugmann
Hi. This is mentioned in the fine manual: http://www.mysql.com/doc/e/x/example-Maximum-column-group-row.html Bye, Benjamin. On Fri, Aug 31, 2001 at 01:46:43PM +0200, [EMAIL PROTECTED] wrote: [...] Normally I would go about like this: SELECT currency_rate.currency_id,

RE: Win98 Installation problems

2001-09-02 Thread Heikki Tuuri
Mathew, if you do not want to use transactional InnoDB tables, add skip-innodb to the [mysqld] section of your my.cnf or my.ini. However, your startup parameters for InnoDB look right. If you have created the directories \ibdata and \iblogs, it should start (unless you are using mysqld.exe in

Re: Win98 Installation problems

2001-09-02 Thread Gerald R. Jensen
Mathew: Under the [mysqld] section of c:\my.cnf, make sure there is a line that reads: skip-innodb Unless, of course, you intend to use innodb. Since you are new with MySQL, there are some excellent resources you should check before posting ... http://www.mysql.com/manual.php (the manual),

Re: MySQL Delphi

2001-09-02 Thread Elizabeth Alderton
Hi Well, I've no experience with ADO's, but I'm using Zeos components and I've not had any () problems. Here's the url http://www.zeoslib.org/. They're free and they don't use ODBC, but rather libmysql.dll which was described to me by my ISP as 'more secure' - whatever that means! They

High Availability for 2 MySQL servers

2001-09-02 Thread Wendell Dingus
I've searched the lists, newsgroups, etc... The info that's out there is somewhat confusing or not as complete as it should be. This is a bit more of a Linux question than a MySQL one but folks on here are likely to be the ones to know the answer. Can anyone give a suggestion as to the best way

Continuing Win98 install problems...

2001-09-02 Thread Mathew Hamilton
Hello, Adding in skip-innodb has indeed helpedbut the server still does not start. If I go into the mysql.err filethis the message I'm getting.. Table 'mysql.host' doesn't exist Anyhelp would be appreciated... Mathew

Re: mysqld or kernel bug?

2001-09-02 Thread Trond Eivind Glomsrød
Robert La Ferla [EMAIL PROTECTED] writes: I saw this message in the log. Is this a mysql or kernel? I also saw one of the mysqld processes (threads?) in the process list as a Zombie. I think it happened at the same time of this log but I don't remember so it's not definite but likely.

mysqld as root

2001-09-02 Thread Michael Widenius
Hi! Ken == Ken Menzel [EMAIL PROTECTED] writes: Ken Wasn't there something awhile back that was supposed to prevent Ken running the daemon as root? When the daemon was started through Ken safe_mysqld it would tell you to select a user as root you had to Ken use --user=root, this seems to be

Re: MySQL Delphi

2001-09-02 Thread Mike
I use D5 and ZEOS without any problems other than it chocked on BLOBS but that was fixed. I also use ASTA http://www.astatech.com/freetools/EvalComps.htm and the ASTA MySQL Server. Works great. Cheers M;) Quote of the day; Programming is like sex: one mistake and you have to support it for the

Re: MySQL Delphi

2001-09-02 Thread j.urban
Is it actually truncating data or is the width simply short? If it's the latter, you might want to have a look at the MyODBC settings for the connection. There is an option called something like, Don't optimize column widths. If this is checked, MyODBC should return the entire column width.

asm constraint problem

2001-09-02 Thread Vladislav Malyshkin
There is a problem with mysql-3.23.41 when compiled by gcc-2.96-85 (RedHat) gcc -DHAVE_CONFIG_H -I. -I. -I.. -I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF -O3 -DDEBUG_OFF -DUNIV_INTEL_X86 -c sync0sync.c sync0sync.c: In function `sync_gnuc_intelx86_test_and_set': sync0sync.c:187:

Re:asm constraint problem

2001-09-02 Thread Heikki Tuuri
Vladislav, gcc-2.96 does not compile the assembly while 2.95 and 3.0 do. But the asm code is actually not needed. You can just comment out the two offending functions in mysql/innobase/sync/sync0sync.c. Regards, Heikki http://www.innodb.com There is a problem with mysql-3.23.41 when compiled