From: Brandon Shuey
Date: March 24 1999 7:28pm
Subject: RE: BUG? Inserting a "Empty" recordset: CRASH! - Executable Testing Version
List-Archive: http://lists.mysql.com/mysql/926
Message-Id: <009b01be762c$7a7466c0$a3c92499@shueybox>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I added:
	 GROUP BY Date_NullPage
to the INSERT INTO statment and that seemed to solve the problem.  Thank you VERY MUCH!!!

> -----Original Message-----
> From: Christian Mack [mailto:Mack@stripped]
> Sent: Wednesday, March 24, 1999 12:36 PM
> To: brandon@stripped
> Cc: mysql@stripped
> Subject: Re: BUG? Inserting a "Empty" recordset: CRASH! - Executable
> Testing Version
> 
> 
> Brandon Shuey wrote:
> > 
> > Everything you would need to duplicate this test is in the zip file:
> > Again, I'm running 450Mhz, PII with WinNT4.0.
> > Mysql Version: Win32 version:3.21.29a-gamma-debug
> > 
> > The crash happenes every time, hopefully you'll be able to duplicate it.  I hope it is due you my ignorance.
> > Good LUCK!
> > 
> >     1.) A bell, and a dialog box that has the title "DBUG" and message "Test Signal"
> >     2.) Dr.Watson, mysql.exe Exception: access violation (0xc0000005), Address: 0x0045ec8a
> >     3.) Mysql shutsdown.
> > 
> > Thanks for your help,
> > 
> > Brandon Shuey
> 
> Hi Brandon
> 
> With 3.22.20 on WinNT 4.0 SP4 I get the following error message from your SELECT statement:
> SELECT 
> 	IFNULL(DATE_FORMAT(p.Date_Time,'%Y-%m-%d'),'990301') as Date_NullPage,
> 	IFNULL(DATE_FORMAT(p.Date_Time,'%k'),0) as Hour,
> 	'N/A',
> 	'N/A',
> 	'N/A',
> 	Count(p.PageViewLogID)
> FROM tblPageViews p LEFT JOIN tblVisits v ON p.VisitLogID = v.VisitLogID
> WHERE (((v.VisitLogID) Is Null));
> 
> ERROR 1140 at line 40: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no 
> GROUP columns is illegal if there is no GROUP BY clause
> 
> So your problem is the COUNT(...) part.
> Don't know exactly what you try to do, but perhaps you can GROUP on VisitLogID?
> 
> Tschau
> Christian
> 
>