Is this a MySQL 5.0.x bug OR What am I missing?

2005-12-23 Thread Gordon Bruce
I have 2 almost identical SQL statements {copied except 1 is a LEFT join and the other is an INNER join}. The INNER join gives me values for all of the fields. The LEFT join gives me NULL's for all of the prec_... {the LEFT join table} fields. If the INNER JOIN gives me values and not an empty se

Re: Error in Update Command Text - What am I missing

2005-09-20 Thread Arno Coetzee
Blue Wave Software wrote: I'm getting an error from the following SQL Syntax. Can anyone guide me on what I am missing. It's probably obvious but I can't see it I have even resorted to rereading the section on the update command. The CustID Field is the unique Identifier and primary key of the

Error in Update Command Text - What am I missing

2005-09-20 Thread Blue Wave Software
I'm getting an error from the following SQL Syntax. Can anyone guide me on what I am missing. It's probably obvious but I can't see it I have even resorted to rereading the section on the update command. The CustID Field is the unique Identifier and primary key of the table. The Updated field is a

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
Got it thanks - "set-variable=old-passwords=1" in the ini file -Original Message- From: Randy Chrismon [mailto:[EMAIL PROTECTED] Sent: 31 January 2004 21:11 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Subject: Re: Passwords and ODBC - what am I missing

Re: Passwords and ODBC - what am I missing

2004-01-31 Thread Randy Chrismon
Oh, and one other thing, you have to create the passwords AFTER you use the switch! That was probably obvious to you but it took me a while to figure out. Randy Randy Chrismon wrote: Ken Brown wrote: Just installed 4.1.1 on windows 2000 with current odbc layer Connects fine with root and no

Re: Passwords and ODBC - what am I missing

2004-01-31 Thread Randy Chrismon
Ken Brown wrote: Just installed 4.1.1 on windows 2000 with current odbc layer Connects fine with root and no password But if I set a password on root or create a user with a password odbc fails with "Client does not support authentication protocol requested by the server - consider upgrading M

RE: Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
uld advise otherwise - or at the very least how to switch on a security log Ken -Original Message- From: Ken Brown [mailto:[EMAIL PROTECTED] Sent: 31 January 2004 15:56 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: Passwords and ODBC - what am I missing Just instal

Passwords and ODBC - what am I missing

2004-01-31 Thread Ken Brown
Just installed 4.1.1 on windows 2000 with current odbc layer Connects fine with root and no password But if I set a password on root or create a user with a password odbc fails with "Client does not support authentication protocol requested by the server - consider upgrading MYSql Client"

SUMMARY: Problem with myisamchk -- what am I missing?

2001-10-21 Thread Robert Alexander
Hi all, I'd like to thank Gordon Burditt for responding to my question. (Original question below.) It seems I was invoking myisamchk incorrectly. Rather than doing: # myisamchk mailtable ...I was specifying both the data and index files, like this: # myisamchk mailtable.MYD mailtable.MYI

Problem with myisamchk -- what am I missing?

2001-10-20 Thread Robert Alexander
Hi all, I'm in the process of writing a searchable mailing list archive in Perl & MySQL. I'm using Monty's old mail_to_db.pl script (which I got from the MySQL site long ago) to load emails from their mailbox into MySQL. Runs just fine, BTW. However, when I run myisamchk on the mail table, i

RE: What am I missing?

2001-06-08 Thread Mike Jimenez
Yes Im running RegHat 6.2 I downloaded the RPM's off the mysql website. Mike -Original Message- From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 11:22 AM To: 'Mike Jimenez' Subject: RE: What am I missing? what OS ya running? RH? Are the RPM

RE: What am I missing?

2001-06-08 Thread Mike Jimenez
nd on the server That was installed from RPM does not have these files? What do I do how would I get them on to my new server? -Original Message- From: Larry Hotchkiss [mailto:[EMAIL PROTECTED]] Sent: Friday, June 08, 2001 9:38 AM To: 'Mike Jimenez' Subject: RE: What am I missing?

RE: What am I missing?

2001-06-08 Thread Neil Zanella
Perhaps you need the MySQL-DBI-perl-bin RPM (?). Is there such a thing? On Fri, 8 Jun 2001, Mike Jimenez wrote: > Perl is already installed installed on the server. > Mike > >> You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you >> still want to use it, you need to install per

RE: What am I missing?

2001-06-08 Thread Mike Jimenez
Perl is already installed installed on the server. Mike -Original Message- From: Rolf Hopkins [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 07, 2001 7:17 PM To: Mike Jimenez; Mysql Subject: Re: What am I missing? You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but i

Re: What am I missing?

2001-06-07 Thread Rolf Hopkins
You don't need MySQL-bench-3.23.38-1.i386.rpm to run mysql but if you still want to use it, you need to install perl first. - Original Message - From: "Mike Jimenez" <[EMAIL PROTECTED]> To: "Mysql" <[EMAIL PROTECTED]> Sent: Friday, June 08, 2001 1:3

What am I missing?

2001-06-07 Thread Mike Jimenez
rpm -i MySQL-3.23.38-1.i386.rpm MySQL-client-3.23.38-1.i386.rpm MySQL-bench-3.23.38-1.i386.rpm error: failed dependencies: MySQL-DBI-perl-bin is needed by MySQL-bench-3.23.38-1 Thanks Mike - Before posting, please check: