From: Giannis S. <gi...@st...> - 2006-08-22 04:18:06
|
This error usually appears when the installation didn't finish correctly using the wizard. Redo the installation from scratch and report here any problems during the procedure. On 8/21/06, Reeves, Greg <Gre...@jc...> wrote: > I have just installed SQUID and SARG on my Debian3.1 box. I want to log my access.log to MySQL so I can create different reports. I followed the instructions in the install file and this is what I get when I go to http://mysquidbox/mysar: > > Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/mysar/inc/functions.inc.php on line 171 > > SQL Error > > ERROR on SQL query > > SQL query: SELECT DATE_FORMAT(date, '%W, %d %M %x') AS dateFormatted,date,MIN(date) AS minDate,MAX(date) AS maxDate,COUNT(DISTINCTROW ip) AS hosts,COUNT(DISTINCTROW usersID) AS users,COUNT(DISTINCTROW sitesID) AS sites,SUM(inCache+outCache) AS bytes,TRUNCATE(SUM(inCache)/SUM(inCache+outCache)*100,0) AS cachePercent FROM trafficSummaries GROUP BY dateFormatted ORDER BY > > > Database error number: 1064 > > > Database error message: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 > > > Exiting... > > > > Any help would be appreciated. If you even give me some troubleshooting tips to get me started, that would help. > > > > Thanks, > > > > Greg Reeves > > > > Jefferson County Department of Health > 1400 6th Avenue South s Birmingham, AL 35223 > Phone: (205) 930-1477 s Fax: (205) 930-1515 > Email: gre...@jc... s Website: http://www.jch.org |