List:General Discussion« Previous MessageNext Message »
From:Josh Milane Date:August 13 2006 1:45pm
Subject:logging
View as plain text  
Hello,

I realize that this is a silly question, but I cannot figure it out. I
don't know why. Id really appreciate your help.

I cannot get mysql to do general logging. My my.ini reads like this:

----------------------------------------------

#This File was made using the WinMySQLAdmin 1.4 Tool
#8/4/2006 9:31:16 PM

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
log=C:/development/xampp/mysql/data/hostname.log
basedir=C:/development/xampp/mysql
#bind-address=192.168.1.222
datadir=C:/development/xampp/mysql/data
#language=C:/XAMPP/xampp/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/development/xampp/mysql/bin/mysqld-nt.exe
user=root
password=

----------------------------------------------

I start the service, no hostname.log is created. Even if I don't run it
as a service, it does not work. 

Permissions are set... this is my machine at home and I am running as
Admin. Even if I create the file manually, it doesn't get updated.

For one second, unexplicably, it DID log one line. Then it stopped and
did no more. This is happening here at home and at work... and I need to
be able to see the sql being executed on my server.

The error log is working fine. 

Any ideas? I sure would appreciate it.



-----Original Message-----
From: Steffan A. Cline [mailto:steffan@stripped] 
Sent: Sunday, August 13, 2006 5:34 AM
To: mysql@stripped
Subject: Group by with an IF

I have the following query:

select *, 
if( season_week_date = "2006-08-16", "on", "off" ) as stat,
sum(overall_points) as total_points
from rosters r 
left join celebs c 
on c.celeb_id = r.celeb_id
where 
season_id=5062
and user_id=1
group by r.celeb_id
order by overall_rank, ln, fn;

It almost works as expected however the problem I am concerned about is
that
I never get a stat saying "On" after it resolves. Removing the sum() and
adding group I get the total_points as expected but now the results are
always off.

Can anyone shed any light on this one?


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
                                  Lasso Partner Alliance Member
---------------------------------------------------------------




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
Group by with an IFSteffan A. Cline13 Aug
  • loggingJosh Milane13 Aug
  • Re: Group by with an IFChris14 Aug
  • Re: Group by with an IFBrent Baisley14 Aug