Re: [cobalt-users] MySQL problem on raq2 with functions!!!!!

[Steven Werby <steven-lists@xxxxxxxxxxxx>]

On Wed, 22 Nov 2000, Annicke wrote:

> Hi,
> 
> I'm new to the list and have the following problem after installing MySQL
> version 3.22.21.
> 
> I tried out the functions there that it said worked...count(), avg(), std(),
> sum(), max(), min() and only count() works.  All the other ones return me a
> 0.  I tried changing my column's datatype from int(11) to float, and back,
> but that didn't fix it.  I was playing around with statements, but none
> seemed to work.

Said another way, it can only handle integers.
 
> Same database on other server (not cobalt) DOES work!

The problem is related to an old version of a library - glibc if I recall
correctly.  I suspect you can fix the problem by installing Cobalt
upgrades that take care of upgrading glibc.  Or you can grab the RPMs off
of the Cobalt FTP site.  For details about exact steps necessary on the
RaQ2 that worked for a RaQ2 1.5 to 2 years ago (before a long string of
Cobalt upgrades) search the MySQL mailing list for "werby sinisa".  If you
can find a web archive of that list I'm sure that will only turn up 1 or 2
messages since Sinisa of MySQL helped me with that problem in early 1999.

Also, I believe Cobalt has a pkg file for MySQL 3.22.32.  If not the
tarball installation works on the RaQ2 - I've installed 3.22.32 and 3.23.x
on it dozens of times.

--
Steven Werby {steven-lists@xxxxxxxxxxxx}