<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hugh Messenger wrote:
<blockquote cite="mid01a601c79126$5b5b3fc0$1532a8c0@alaweb.com"
type="cite">
<pre wrap="">George Embrey <a class="moz-txt-link-rfc2396E" href="mailto:george@vmail.net.au"><george@vmail.net.au></a> says:
</pre>
<blockquote type="cite">
<pre wrap="">Queries to Windows MySQL servers from Linux Systems often fail unless
the lower_case_table_names parameter is set to 0 in the my.ini file in
the MySQL directory.
</pre>
</blockquote>
<pre wrap=""><!---->
I'm familiar with that issue, and I checked all the table case-ness. The
problem seems to be with providing an empty string ('') as the value for an
auto-incrementing integer primary index.
</pre>
</blockquote>
Yes that is true '' or empty strings are not nulls or integers... I
suggest replacing the '' with the word null, this will sort out the
issue based on the query you specified.<br>
<blockquote cite="mid01a601c79126$5b5b3fc0$1532a8c0@alaweb.com"
type="cite">
<pre wrap="">
The problem with setting lower_case_table_names to 0 is that I could end up
blowing away my MyISAM tables elsewhere in that server, as per the warning
the service control gives, if I moof a query on those and use the "wrong"
case:
</pre>
</blockquote>
I would rename the MyISAM tables using phpmyadmin or using SQL and sort
out the Database to run case sensitive in the first place like the ANSI
standard.<br>
<br>
Or much better still mysqldump the entire MySQL server into a file
"textfilename.sql", sort out the table names etc... using a good text
editor, place a drop table if exists before each create table entry,
save the file then run mysql -uroot -p < "textfilename.sql" to
recreate all of the databases including data with tablenames in the
correct case...<br>
<br>
Maybe I am just too fussy...<br>
<br>
<blockquote cite="mid01a601c79126$5b5b3fc0$1532a8c0@alaweb.com"
type="cite">
<pre wrap="">"You have forced lower_case_table_names to 0 through a command-line option,
even though your file system 'E:\MySQL\Data\' is case insensitive. This
means that you can corrupt a MyISAM table by accessing it with different
cases. You should consider changing lower_case_table_names to 1 or 2"
</pre>
</blockquote>
Only if you live in an all windows world... "Compatability is a bitch
it demands the use of standards, the little things which M$ don't
adhere to very well" ;-)<br>
<blockquote cite="mid01a601c79126$5b5b3fc0$1532a8c0@alaweb.com"
type="cite">
<pre wrap="">It's working fine with my modifie query, so I'm just going to put this down
to "a 5.x thing" and live with my change. Compared to the wholesale hack
and slash job I've had to do on the sqlippool queries to get them to work,
it's no Big Whoop, LOL!
But thanks for the suggestion, I appreciate your time.
-- hugh
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<br>
<div class="moz-signature"><span
style="font-weight: bold; font-family: helvetica,arial,sans-serif;">George
Embrey</span><br style="font-family: helvetica,arial,sans-serif;">
<small
style="font-family: helvetica,arial,sans-serif; font-weight: bold;">
CEO / Senior Systems Architect.</small><br
style="font-family: helvetica,arial,sans-serif;">
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;">
Vmail Internet Services Pty Ltd.</span></small><br
style="font-weight: bold; font-family: helvetica,arial,sans-serif;">
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;">318 Shoal Point Road</span><br
style="font-weight: bold;">
<span style="font-weight: bold;">Shoal Point QLD 4750</span><br
style="font-weight: bold;">
<span style="font-weight: bold;">Australia</span><br>
</small>
<small style="font-family: helvetica,arial,sans-serif;"><span
style="font-weight: bold;"></span></small></div>
</body>
</html>