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:
> 3.) Mysql shutsdown.
> Thanks for your help,
> Brandon Shuey
With 3.22.20 on WinNT 4.0 SP4 I get the following error message from your SELECT
IFNULL(DATE_FORMAT(p.Date_Time,'%Y-%m-%d'),'990301') as Date_NullPage,
IFNULL(DATE_FORMAT(p.Date_Time,'%k'),0) as Hour,
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?