List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:March 24 1999 6:36pm
Subject:Re: BUG? Inserting a "Empty" recordset: CRASH! - Executable Testing Version
View as plain text  
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

Thread
BUG? Inserting a "Empty" recordset: CRASH! - Executable Testing Version(Brandon Shuey)24 Mar
  • Re: BUG? Inserting a "Empty" recordset: CRASH! - Executable Testing VersionChristian Mack24 Mar
    • RE: BUG? Inserting a "Empty" recordset: CRASH! - Executable Testing Version(Brandon Shuey)25 Mar