Here is a sanitized and shortened version of the url when i make the query
(it was very long).
also, here is an interesting twist. i tried to archive today (again, using
move/all on screen) with approx. 700 alerts, and i got the following error:
Database ERROR:Database ERROR:Duplicate entry '2-694079' for key 1
so, now it's two different error messages depending on the mood of the
>From: Axton <axton.grams@...>
>To: "Kevin Forbus" <kforbus@...>
>Subject: Re: [Secureideas-base-user] Archive MySQL Error-BASE 1.3.6
>Date: Sat, 9 Jun 2007 18:53:44 -0400
>I set up an environment that mostly matches yours, but I can not
>reproduce the error. Can you post the url used when you receive the
>The error may originate from the search criteria used.
>On 6/8/07, Kevin Forbus <kforbus@...> wrote:
>>Just upgraded from BASE 1.2.7 to BASE 1.3.6 (louise)
>>I am having a problem archiving TCP alerts. While trying to
>>`archive(move),entire query`, I get the following error:
>>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 ')' at line 1
>>I read in the forums that this was supposed to be fixed in this release of
>>BASE, and strangely enough, it only occurs when trying to archive the TCP
>>alerts. All others archive correctly.
>>In addition, I CAN do `archive(move), all on screen` for the TCP alerts,
>>this can take a while due to the large number of alerts that I deal with.
>>Any help will be greatly appreciated.
>>My setup is:
>>BASE 1.3.6 (louise)- Source Forge Version
>>Fedora Core 6
>>snort 18.104.22.168 (Build 34)
>>Like puzzles? Play free games & earn great prizes. Play Clink now.
>>This SF.net email is sponsored by DB2 Express
>>Download DB2 Express C - the FREE version of DB2 express and take
>>control of your XML. No limits. Just data. Click to get it now.
>>Secureideas-base-user mailing list
Dont miss your chance to WIN $10,000 and other great prizes from Microsoft
Office Live http://clk.atdmt.com/MRT/go/aub0540003042mrt/direct/01/