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
>
>
