logo
bgImage
http://www.winsnort.com


Welcome to the home of WinIDS - Windows Intrusion Detection System!
header

Thank you for visiting WINSNORT.com

FAQ  •  Search  •  Register  •  Log in to check your private messages
Log in

Database ERROR:Database ERROR:You have an error in your SQL
WINSNORT.com Forum Index » WinIDS - Windows XP / 2003 » WinIDS - IIS 5.5 Web Server with MySQL Database Support
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
Author Message
john11Offline
Post subject: Database ERROR:Database ERROR:You have an error in your SQL  PostPosted: Jan 19, 2012 - 08:51 PM



Joined: Jan 16, 2012
California
Posts: 12
Location: California
Status: Offline
Using MySQL, running http://winids, the following appears:

Database ERROR:Database ERROR: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 '1 timestamp FROM acid_event ORDER BY timestamp ASC ), (SELECT TOP 1 timestamp FR' at line 1

Any idea what the syntax error is?

Here is a line from base_stat_common.php
$result = $db->baseExecute("SELECT (SELECT TOP 1 timestamp FROM acid_event ORDER BY timestamp ASC ), ".
"(SELECT TOP 1 timestamp FROM acid_event ORDER BY timestamp DESC )");
 
 View user's profile Send private message  
Reply with quote Back to top
john11Offline
Post subject: RE: Database ERROR:Database ERROR:You have an error in your   PostPosted: Jan 19, 2012 - 09:24 PM



Joined: Jan 16, 2012
California
Posts: 12
Location: California
Status: Offline
Changed it to the following and there are not errors. Just not sure if this is the correct statement. Not very versed in MySQL. Anyone know if this is the correct "solution" to the syntax error above?

$result = $db->baseExecute("SELECT (SELECT timestamp FROM acid_event ORDER BY timestamp ASC LIMIT 1 ), ".
"(SELECT timestamp FROM acid_event ORDER BY timestamp DESC LIMIT 1)");
 
 View user's profile Send private message  
Reply with quote Back to top
MorpheusOffline
Post subject: RE: Database ERROR:Database ERROR:You have an error in your  PostPosted: Jan 20, 2012 - 01:40 AM
Site Admin


Joined: Sep 04, 2003
East Coast - USA
Posts: 1463
Location: East Coast - USA
Status: Offline
Not sure, but did you use the BASE install from your MSSQL install. There are changes to the BASE code made for MSSQL that won't work for MySQL.

_________________
Best regards,
Morpheus...

WINSNORT.com Management
 
 View user's profile Send private message Visit poster's website MSN Messenger  
Reply with quote Back to top
Display posts from previous:     
Jump to:  
All times are GMT -5 Hours
Post new topic   Reply to topic
View previous topic Printable version Log in to check your private messages View next topic
 WINSNORT.com Forum Index » WinIDS - Windows XP / 2003 »  WinIDS - IIS 5.5 Web Server with MySQL Database Support

Powered by PNphpBB2 © 2003-2009. The PNphpBB2 Team
www.eventloganalyzer.com