<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7650.28">
<TITLE>PHP Syslog NG error's</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Im having a couple of issue's with phpsyslog-ng, I cant seen any threads or posts that help with the problem's im having so I need to post, if im covering old ground, I apologize.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">Im not well versed with MySQL or PHP, so if you could help please explain in "novice language".</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">1. When I open the browser and login, I then select "search" from the menu bar, I get the following error:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">USING TABLE:logs</FONT>
</P>
<P><I><FONT FACE="Times New Roman">SELECT * FROM search_cache WHERE tablename='logs'Query failed: 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</FONT></I></P>
<P><FONT FACE="Times New Roman">Im getting the error displayed this way because I have it configured to echo the result.</FONT>
<BR><FONT FACE="Times New Roman">In the file search.php I see the following query configured:</FONT>
<BR><I><FONT FACE="Times New Roman">$sql = "SELECT * FROM ".CACHETABLENAME." WHERE tablename='".$useTable."'";</FONT></I>
<BR><FONT FACE="Times New Roman">2. When I try to add a user I input the username and password for the new account and then receive the following message:</FONT></P>
<P><FONT FACE="Times New Roman">No DB Link</FONT>
</P>
<P><FONT FACE="Times New Roman">Im sure these aren't difficult issues to resolve, but im done beating my head on a wall. Any help would be appreciated.</FONT>
<BR><FONT FACE="Times New Roman">Stuart</FONT>
</P>
</BODY>
</HTML>