C API metadata bug

2003-02-17 Thread matt neuburg
by Products.ProductID then the BUG returns. Apart from the fact that this bug occurs only when group by or order by clauses are present, I have not been able to work out a pattern here. This bug has been causing us trouble since July 2002 (when we started using MySQL). matt neuburg, phd = [EMAIL

Bug: MYSQL_FIELD-flags indicates NOT NULL with aggregates

2003-01-24 Thread Matt Solnit
, row[0] ? row[0] : NULL); mysql_close(cnn); Fix: None. Originator:Matt Solnit Organization: Iteration Software, Inc. http://www.iteration.com Release: mysql-4.0.9-gamma (Binary distribution) Environment: System: Windows XP Professional Architecture: Pentium IV

Disable log messages for Embedded Server?

2003-01-13 Thread Matt Solnit
to the user, but not MySQL's. Ideally we would be able to turn off MySQL output, but at least we would like to be able to redirect it. -- Matt Solnit [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Calculating innodb_additional_mem_pool_size?

2003-01-07 Thread Matt Solnit
Is there a good way of calculating the size for innodb_additional_mem_pool_size? I would like to calculate based on the number of tables, rows, or whatever else I can use to pre-determine a value so that the warning message allocating memory from the OS does not appear. -- Matt Solnit [EMAIL

Re: auto increment

2003-01-06 Thread Matt Hargraves
can't try doing it all in one table. He simply needs to go pick up some books that explain what normalization is and apply those rules and he'll be fine. Matt - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: vinita Vigine Murugiah [EMAIL PROTECTED]; kayamboo [EMAIL PROTECTED

Re: Replication priority / speed

2002-12-31 Thread Matt Sturtz
on the slaves are to connect to the master-- everything else is stock... Thanks again for the help, -Matt Sturtz- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Replication priority / speed

2002-12-30 Thread Matt Sturtz
optimized things as best we can. The problem is our customers are allowed to bulk-load keywords into our database, which causes about 4 large tables to be updated quite a bit. Whenever this happens, the slaves struggle to get caught back up... Thanks again, -Matt Sturtz

Bug report: UNIQUE KEY and DESCRIBE TABLE

2002-12-27 Thread Matt Solnit
); if (!mysql_real_connect(db, NULL, NULL, NULL, dbname, 0, NULL, 0)) die(db, mysql_real_connect failed: %s, mysql_error(db)); return db; } void db_disconnect(MYSQL *db) { mysql_close(db); } --- My contact information: --- Matt Solnit [EMAIL PROTECTED

Replication priority / speed

2002-12-26 Thread Matt Sturtz
for any advice, -Matt Sturtz- - 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

What terminates a query?

2002-12-23 Thread Matt Young
My sql command pipes its result to a perl program (in batch mode) . but the perl program has no waf to tell when the query is finished. HTTP uses a blank line to signal the end. but there is no such thing for mysql. - Before

Re: Password function not working with latest 4.1 tree

2002-12-19 Thread Matt Parlane
() function was irreversible. Therefore I am left with no choice but to use a deprecated function... which I really don't want to do... What do you suggest? Regards, Matt Parlane Modus Consulting sql,query - Before posting

Password function not working with latest 4.1 tree

2002-12-18 Thread matt
Description: with the latest 4.1 tree (from today) the PASSWORD() function returns random alpha-numeric text /[a-f0-9]/ 45 characters in length (which is too long for a password string). The string always starts with a * (asterisk). example:

PASSWORD() function not working

2002-12-18 Thread Matt Parlane
Description: The password function does not work as intended with latest 4.1 tree (today's). It returns a string of LENGTH() = 45 starting with a * (asterisk) and 44 alphanumeric characters /[a-z0-9]/ How-To-Repeat: Using latest 4.1 BK tree, SELECT PASSWORD('something'); Fix: Not

InnoDB exits process when files are read-only

2002-12-16 Thread Matt Solnit
it terminates the process. We are using Embedded MySQL, so when the process terminates, our EXE goes down. It would be ideal if the function could return an error code so that we could continue. Is there anything we can do? Sincerely, Matt Solnit [EMAIL PROTECTED

safe_mysqld will not start correctly

2002-12-10 Thread Matt Allen
Could someone please tell me how to fix this problem: 021210 12:50:49 mysqld started 021210 12:50:52 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 2785410520 InnoDB: Doing

Bug report: Embedded MySQL version 4.05a

2002-12-10 Thread Matt Solnit
this parameter value to 1, so the ACL's never get loaded and every access succeeds. --- My contact information: --- Matt Solnit [EMAIL PROTECTED] - Before posting, please check: http

Bug report: Embedded MySQL v4.04b

2002-11-27 Thread Matt Solnit
project. The reason is that it's required for clients that use LoadLibrary(), which includes all C# clients. More information can be found in the VC++ documentation article Rules and Limitations for TLS. --- My contact information: --- Matt Solnit [EMAIL

RE: Bug report: Embedded MySQL v4.04b

2002-11-27 Thread Matt Solnit
I am looking into USE_TLS. But yes, I see that mysql_real_data_home is not corrupted, only mysql_data_home is. Thanks for your response. -- Matt -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 11:40 AM To: Matt Solnit; [EMAIL

Problems with reserved words

2002-11-16 Thread Matt Kenigson
dropping the db proves to not work). Here's a thought: Would renaming the MYD, MYI, and frm files do the job? I'll try that now. Thanks, Matt Kenigson - Before posting, please check: http://www.mysql.com/manual.php

Re: Problems with reserved words

2002-11-16 Thread Matt Kenigson
Never mind. Renaming the files worked the trick. :) Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:35 AM Subject: Problems with reserved words Howdy, Recently I was working with a contractor on a schema

Re: Problems with reserved words

2002-11-16 Thread Matt Kenigson
Oh, FYI, I did stop mysql first, change the file names, then restart it. Matt - Original Message - From: Matt Kenigson [EMAIL PROTECTED] To: Matt Kenigson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 16, 2002 11:39 AM Subject: Re: Problems with reserved words Never

bug report: Embedded MySQL v4.04b

2002-11-15 Thread Matt Solnit
is that it's required for clients that use LoadLibrary(), which includes all C# clients. More information can be found in the VC++ documentation article Rules and Limitations for TLS. --- My contact information: --- Matt Solnit [EMAIL PROTECTED

delayed inserts and messages in the host.err log

2002-11-12 Thread matt
. I am not extremely proficient with mysql and solaris. But, I did notice the log and was wondering if I should be concerned. Any input will be greatly appreciated. Thank you guys and gals :-) matt -- m@ Like a cloud dropping rain, I'm discarding all thought. - Eddie Vedder

Mysql seg faults on remote connections

2002-10-15 Thread Matt Petteys
Description: I have some issues with mysql in my production environment that is causing mysql not to accept remote connections on multiple machines. It now appear that a name resolution problem is the root of the problem but it is not handled very well by mysql so it may want to be looked at.

Interview with MySQL designer Monty Widenius

2002-10-13 Thread Matt Wade
will be voted upon by the users of the site and the top 10-15 questions will be sent off to Monty on the 22nd of this month. Matt Wade http://codewalkers.com/ - Before posting, please check: http://www.mysql.com/manual.php

Re: Stored Procedures

2002-10-13 Thread Matt Hargraves
... I'm kinda waiting for Stored Procedures meself, but am hoping that they will hit by June of next year. Matt - Original Message - From: Ian Hagan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 13, 2002 8:10 PM Subject: Stored Procedures Hello All List Members, My

Re: pro vs max

2002-10-02 Thread Matt Hargraves
Neat thing on the MySQL front page... it's called news. It lists that there are new 'price points' (versions) for people. The only differnce between MySQL Classic and MySQL Pro is Innodb, IIRC. Matt - Original Message - From: Hathaway, Scott L [EMAIL PROTECTED] To: Mysql (E-mail

Re: pro vs max

2002-10-02 Thread Matt Hargraves
what you wanted. Matt - Original Message - From: Keith C. Ivey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 02, 2002 11:40 AM Subject: Re: pro vs max Perhaps those posting obnoxious RTFM responses to Scott's question should actually take a look at the Versions box

possible left join problem?

2002-09-27 Thread Matt MacDougall
OR links.category2=tmplinks.category OR links.category3=tmplinks.category) AND links.rating=tmplinks.rating AND links.display=yes GROUP BY categories.name; UNLOCK TABLES; DROP TABLE tmplinks; Thanks much! -Matt MacDougall - Before posting

Re: MySQL Gui Install and Setup for Win2K

2002-09-23 Thread Matt Hargraves
stuff in MySQL. Matt - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 7:01 AM Subject: Re: MySQL Gui Install and Setup for Win2K And where would one obtain MySQL Navigator? JMichael Matt Hargraves [EMAIL PROTECTED] 09/22/2002 09:14

Re: MySQL Gui Install and Setup for Win2K

2002-09-22 Thread Matt Hargraves
Oops... I meant Microsoft SQL Server and Oracle, not MySQL and Oracle. Matt - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Arthur Fuller [EMAIL PROTECTED]; David Kramer [EMAIL PROTECTED] Cc: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, September 22, 2002 9:14 PM

Re: FREE traffic to your website !

2002-09-08 Thread Matt Hargraves
Doesn't this figure... the spamming bastards are now wasting time in user groups. What a dumbass. Matt - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, September 08, 2002 7:26 AM Subject: FREE traffic to your website ! Hi, My name is Mike and I have

Re: Innodb error on windows ME platform

2002-09-07 Thread Matt Hargraves
actually know what a steaming pile of crap WinME is. Matt - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 07, 2002 2:03 PM Subject: Re: Innodb error on windows ME platform Neil, - Original Message - From: Neil Malkani

Re: Re: Install questions

2002-09-05 Thread Matt \TrollBoy\ Wiseman
. How can I tell what ports its using now? I'd like to stick with defaults... 3. You can just create a symbolic link How does one accomplish this? I'm not sure how a symlink will help this problem.. -- Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest

Re: Looking for opinion

2002-09-05 Thread Matt Hargraves
involve a template to save my life. :) Matt - Original Message - From: Bryan Koschmann - GKT [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 5:21 PM Subject: Looking for opinion Hello, I'm new to this list, and actually rather new to MySQL. I am still

Re: storing dabase on linux ramdisk

2002-09-05 Thread Matt Hargraves
. Are there situations that I can think of where I would want to do it? Sure, but they all involve massive conversational AI systems. Matt - Original Message - From: Joseph Monti [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 05, 2002 11:21 PM Subject: storing dabase

Re: GRANT not working

2002-09-03 Thread Matt Hargraves
. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From

Re: Install questions

2002-09-03 Thread Matt \TrollBoy\ Wiseman
, and see no place to enter that info in php.ini... any other thoughts? -- Matt TrollBoy Wiseman Webmaster: Shoggoth.net Site Designer: phpslash.org The oldest and strongest emotion of mankind is fear, and the oldest and strongest kind of fear is fear of the unknown. -H.P. Lovecraft

Install questions

2002-09-02 Thread Matt \TrollBoy\ Wiseman
I just installed MySQL from RPM and can connect to it via shell using the MySQL command, but I can't get anything else to connect to it. MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Thoughts? Matt Wiseman

Crash when adding field

2002-09-02 Thread Matt Parlane
` (`ID`) ) TYPE=MyISAM matt@homer:/usr/local/mysql/bin# ./mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 30 to server version: 4.0.3-beta Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql USE zeviwm; Reading table

mysql 4 release

2002-08-27 Thread Matt Darcy
Does anyone have any idea when Mysql 4 will be classed as stable. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

RE: mysql 4 release

2002-08-27 Thread Matt Darcy
Sounds fair. I have played with it a bit and found it good. Just hoping it was be found stable soon as I am keen to use it in production. I'll get back to some testing. Thanks, Matt -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: 27 August 2002 22:15

Status question about Mysql

2002-08-20 Thread Matt Heaton
so I can find an alternative? If you have any ideas for the best way to do this I would really appreciate it. Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

MyCC

2002-08-19 Thread Matt Hargraves
. Matt Hargraves - 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

2 mysql daemons starting - both with different configs

2002-07-28 Thread Matt Darcy
is the root processes of mysql not owned by mysqldba ? do I need to add an su - mysqldba at the start of the mysql_server script ? why is mysqld setting --datadir=/usr/locl when the script sets datadir=/usr/local/mysql/var ? Thanks, Matt

RE: Joins, ANSI 92 or the old way

2002-07-24 Thread Matt Khan
the practical differences between them when the statements are executed. Regards, Matt -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: 23 July 2002 18:23 To: Defryn, Guy Cc: '[EMAIL PROTECTED]' Subject: Re: Joins, ANSI 92 or the old way Hi. On Wed 2002-07-17

Host IP is not allowed to connect this MySQL server

2002-07-18 Thread Matt
Hello, I am trying to connect to a remote MySQL server of mine and I get this error Host IP is not allowed to connect this MySQL server If someone could give me the shortcut to this file so I can edit it to allow me in- It would be greatly appreciated. Thank You Matt

web archive project

2002-07-11 Thread Matt Price
with some pre-existing code than start from the ground up. Any suggestings? Is this the right list to be asking this question on? Thanks loads, Matt - Before posting, please check: http://www.mysql.com/manual.php

64 Bit mysqld on Solaris

2002-06-21 Thread Matt Patterson
for all your help. Matt Patterson [EMAIL PROTECTED] Programmer, Solinus, Inc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

2002-06-10 Thread Matt Rowe
fields with = versus =? Thanks, Matt - 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

RE: Indexing on a DATE field/bizarre speed issue with a LEFT JOIN?

2002-06-10 Thread Matt Rowe
, Matt - 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

Re: Thread based optimization?

2002-06-07 Thread Matt Rowe
think that will have much of an affect, since MySQL only queue's high_priority selects in front of inserts and updates. Thanks Jeremy, Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual

Thread based optimization?

2002-06-06 Thread Matt Rowe
seconds than have several short-query people wait. I've tried tuning all the typical parameters, but I don't think the logjam is memory-based (the hard disk doesn't move). The database server is Win2k, 512Mb memory, PIII @ 450mhz. Variables are as below. Thanks in advance, Matt back_log

Problem starting server

2002-05-27 Thread Matt Hargraves
either mysqld or safe_mysqld, it immediately stops (within a tenth of a second of starting). Any ideas? I'm sure it's my fault, since I just reinstalled the server fresh from the RedHat 7.2 CD and used the OS install to install the MySQL server. Any help would be appreciated. Matt Hargraves

Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
either mysqld or safe_mysqld, it immediately stops (within a tenth of a second of starting). Any ideas? I'm sure it's my fault, since I just reinstalled the server fresh from the RedHat 7.2 CD and used the OS install to install the MySQL server. Any help would be appreciated. Matt Hargraves

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
- From: Phil Dobbin [EMAIL PROTECTED] To: Matt Hargraves [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 1:32 PM Subject: Re: Fw: Problem starting server On 27/5/02 at 12:47, [EMAIL PROTECTED] (Matt Hargraves) wrote: I keep getting the following error: error: 'Can't

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
OK, that helps a lot. There is no '/usr/local/mysql directory' Any chance that this is different in RedHat? There is very little in the rc.local file and nothing having to do with mysql. Matt - Original Message - From: Phil Dobbin [EMAIL PROTECTED] To: Matt Hargraves [EMAIL PROTECTED

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
the skip-innodb entry is not appropriate, since it's the only entry that doesn't have an '=' in the middle of it though. Matt - Original Message - From: Mark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 27, 2002 4:12 PM Subject: Re: Fw: Problem starting server Been there, had

Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
- Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Mark [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 27, 2002 5:19 PM Subject: Re: Fw: Problem starting server OK, there really is nothing more to my install, installed it during the OS install. I clicked on 'Next

Re: Fw: Problem starting server

2002-05-27 Thread Matt Hargraves
and in my MySQL mSQL book for installation. Neither manual seems to cover what I need to do to get MySQL running properly. I'm going to try installing RedHat fresh again, this time without any database software and installing by rpm again. Matt - Original Message - From: Mark [EMAIL PROTECTED

Need help.

2002-05-22 Thread Matt Hargraves
. Thanks, Matt - 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

Having problem installing.

2002-05-21 Thread Matt Hargraves
for any help, Matt - 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

GROUP BY on multiple fields apparently broken

2002-05-19 Thread matt
by One,Two; -- fails select One, Two, sum(Four) from test group by concat(One,Two); -- succeeds Fix: Use concat() to create a single group by element, but this isn't the right way to do it, surely! Submitter-Id: submitter ID Originator:Matt Johnson Organization: AVSIM Online

Determining character set from table data

2002-04-27 Thread Matt Culbreth \(EIDMySql support\)
? Thanks, Matt Culbreth - 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

Announcing native .NET provider to MySQL

2002-04-10 Thread Matt Culbreth \(EIDMySql support\)
Hello, This is an announcement of a new product that will interest some of you. I have completed work for the first Beta release of a native ADO.NET provider to MySQL. You can find the details at http://www.mattculbreth.com/eidmysql. Thank you, Matt Culbreth

TZ

2002-04-03 Thread Matt Shaw
Hi, hopefully I have reached the right list.. I have recently updgraded to version 3.23.49 and have found that when doing the following query: select now() I get a universal time returned to me. I have this version installed on linux 7.2 and I require a time in australian eastern standard

Procedures

2002-04-02 Thread matt
Does any know if mysql has any kind of stored procedures? If not, is there any plans on including them? -matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Query for Summary Report

2002-04-01 Thread Matt Neimeyer
the distinct subjects, loop over that resultset and then fetch the count and average for that particular subject on each iteration) Any advice is greatly appreciated. Matt - Before posting, please check: http://www.mysql.com

Re: Unicode in 4.1

2002-03-19 Thread Matt Wagner
of a in-depth whitepaper, then you could hire some consulting services from our developers to write this for you. Please contact [EMAIL PROTECTED] if you are interested. Matt -- For technical support contracts, visit https://order.mysql.com

Leap seconds

2002-03-18 Thread matt
values (2002010100); mysql select * from teststamps; ++ | stamp | ++ | 2002010138 | ++ 1 row in set (0.00 sec) Fix: Please tell me. Submitter-Id: Originator:matt

Re: xml

2002-03-09 Thread Matt Wagner
development. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Coordinator of Development

Re: Why v3.23.49 does not build on RedHat 6.2 ?????

2002-03-08 Thread Matt Wagner
with 2.96RH -- that this compiler is not good for MySQL. Now that GCC 3.x has been released, we will be looking at making MySQL 4.x series (and higher) work well with it. GCC 3.x is looking very promising. Regards, Matt -- For technical support contracts, visit https://order.mysql.com

merge problems under 3.23.47?

2002-03-04 Thread matt
; In testing, the problem only arises when the total line count of the two mapped tables reaches 20. Anyone have any ideas? - Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Geo- datatype support

2002-03-03 Thread Matt Wagner
hints of that work in version 4.1 Jeremy, Yes, we will have matched functionality to that of PostgreSQL's PostGIS in MySQL 4.1. We will probably start an Alpha release of 4.1 within the next 1-2 months. Matt -- For technical support contracts, visit https://order.mysql.com

HELP - Admin Removed mysql.host

2002-02-27 Thread Matt Rudderham
mysql_install_db this should restore it correct? But will this effect the existing production databases? Many Thanks! - Matt Bonum volens duceris in Tartarum - Before posting, please check: http://www.mysql.com/manual.php

Porting databases

2002-02-26 Thread Matt James
New to list so please excuse me if this is an obvious question. Is there any tools / documentation to simplify porting MS Access databases to MySQL ? This Internet E-mail is intended solely for the person to whom it is

MySQL / PHP Augmenting Variables For UPDATE

2002-02-12 Thread Matt Rudderham
then $1-name dynamically until all the records in the table have been displayed. Does anyone know how I can accomplish this? Many Thanks. - Matt Rudderham - Before posting, please check: http://www.mysql.com/manual.php

FULL-TEXT Index / Searching Question

2002-02-11 Thread Matt Rudderham
. Matt Rudderham I am running MySQL 3.23.38 - 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

MySQL / PHP Augmenting Variables For UPDATE

2002-02-06 Thread Matt Rudderham
then $1-name dynamically until all the records in the table have been displayed. Does anyone know how I can accomplish this? Many Thanks. - Matt Rudderham - Before posting, please check: http://www.mysql.com/manual.php

FULL-TEXT Index / Searching Question

2002-02-05 Thread Matt Rudderham
. Matt Rudderham I am running MySQL 3.23.38 - 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

Dumping a MySQL DB Out to Access

2002-02-01 Thread Matt Rudderham
. Matt Rudderham - 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

Echoing Values Inside Single Quotes for an Insert (PHP)

2002-01-20 Thread Matt Rudderham
('$member_id','$skill_name + $i','$schooling+ $i','$certifications + $i','$skill_description$i')); Thanks a bunch. - Matt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Summary: Board Meeting

2002-01-16 Thread Matt Wagner
meet today? 14:16:00 marten 10am to 1pm 14:16:52 marten Matt, I don't remember how to send a msg to you only, but feel free to mail the log to discuss if you find it of interest. 14:17:05 mwagner ok 14:17:08 Kaj messages /msg marten way to go! 14:17:37 Kaj MÃ¥rten, back in Finland

My Apologies - Re: Summary: Board Meeting

2002-01-16 Thread Matt Wagner
All, Please disregard this Summary: Board Meeting message. It was sent to the public mailing list in error. This message was NOT at all meant for the public mailing list. Please except my apologies for the intrusion. Matt Wagner, MySQL AB -- For technical support contracts, visit https

INSERT value from another table

2002-01-07 Thread matt
the result in a variable and then insert it? Thanks very much for the help. Cheers, Matt Rudderham - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Could you look at this PHP/MySQL Code?

2002-01-02 Thread Matt Rudderham
Hi, This is generating an error: Warning: Wrong parameter count for mysql_result() in /usr/local/www/html/matt/add.php on line 27 I can't figure out what the problem is, here is the code in question, it is part of an HTML form: --Snip connect etc.. -- // process form $sql = INSERT

RE: Could you look at this PHP/MySQL Code?

2002-01-02 Thread Matt Rudderham
D'oh. Meant to call mysql_query! Thanks! - Matt Bonum volens duceris in Tartarum -Original Message- From: Michael Brunson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 3:36 PM To: Matt Rudderham Cc: [EMAIL PROTECTED] Subject: Re: Could you look at this PHP/MySQL

Programming for referential integrity

2001-12-28 Thread Matt Rudderham
the information about those members? I am using PHP and MySQL 3.23.38 running on FreeBSD / Apache(PhP4). Thanks. Matt Rudderham Bonum volens duceris in Tartarum - Before posting, please check: http://www.mysql.com/manual.php

Re: 4.0 style full text searching in 3.23.x

2001-12-19 Thread Matt Wagner
environment. :) My advice is to setup a test environment and try out 4.x, and submit good bug reports to us so that 4.x can become stable faster. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL

Re: Decrypting PASSWORD() from MySQL

2001-12-19 Thread Matt Wagner
to obscure the clear-text field in a decodable fashion, then check out the ENCODE()/DECODE() functions. Note, in MySQL 4.x there will be two new functions, DES_ENCRYPT()/DES_DECRYPT(). Matt -- For technical support contracts, visit https://order.mysql.com

Re: Decrypting PASSWORD() from MySQL

2001-12-19 Thread Matt Wagner
do what he was trying to do. It's up to him to decide if it is a good/bad solution. Regards, Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED

Re: MySQL and kernel upgrade

2001-12-17 Thread Matt Wagner
in newer kernel. What will effect my system if I install latest MySQL with current kernel? Sommai, Linux kernel 2.2.16 should be ok. The problem is specifically with an I/O bug in kernel 2.2.14. Matt -- For technical support contracts, visit https://order.mysql.com

Re: MySQL Alpha Linux binary distribution: Core dumped on AlphaServer 1200

2001-12-14 Thread Matt Wagner
* binaries... the same as MySQL.com. Matt -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Matt Wagner [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Herr Direktor

Re: Problem with bk://work.mysql.com ?

2001-12-12 Thread Matt Wagner
Fournier Jocelyn [Presence-PC] writes: Hi, When I try to do a bk pull, I have the following unexpected message : bk pull bk://work.mysql.com:7001: No route to host What's wrong ? Hi, It should be fixed now. We were doing an internet connection upgrade (from 10mb to 100mb). Matt

Re: Failure to enforce length of fields to index corrupts tables -- fully resolved in BK

2001-12-11 Thread Matt Johnson
help! :-) Regards, -- Matt Johnson [EMAIL PROTECTED] AVSIM Online! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

killed by SIGSEGV

2001-12-10 Thread matt
/mysqlnew, then symlink ./var to where the db files really are. Is there anything else I need to change? I'll let you know how it goes. Thanks again, Matt -- #!/usr/bin/perl $A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_} A A A =~m{(...)}g)?A: )=~/([ A])$/){if(!(++$l%80)){print\n;sleep

Re: Mysql 4.0

2001-12-07 Thread Matt Wagner
just fine on the same machine. It seems to depend on the CPU. For me the binary distribution of MySQL 4.0 works fine on Pentiums and Athlons, but I get illegal instructions on K6/2s. Hi, AFAIK, this should be fixed when 4.0.1 comes out in a couple days. Matt -- For technical support

killed by SIGSEGV

2001-12-04 Thread matt
to happen on demand - so this seems like a good enough way to start. If anyone can make any suggestions on tests/things to try then please do. Thanks, Matt This is what a typical log entry looks like: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells

Re: killed by SIGSEGV

2001-12-04 Thread matt
of times. Hopefully thats covered everything, thanks again - Matt. -- #!/usr/bin/perl $A='A';while(print+($A.=(grep{($A=~/(...).{78}$/)[0]eq$_} A A A =~m{(...)}g)?A: )=~/([ A])$/){if(!(++$l%80)){print\n;sleep 1}} - Before

getting id or record just inserted

2001-11-29 Thread Matt Graham
to the mailing list...yet. Thank you, Robert Matt Graham, Esq. Product Manager THE AGOS GROUP, LLC [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

<    1   2   3   4   5   6   7   >