Re: acidlab update broke acidlab mysql installation on sarge

[Rhomboid <rhomboid@globalmegahypernet.com>]

Thanks, I was starting to head that direction anyway. Ironically, I had 
switched to Debian in the first place a couple years ago to reduce 
management overhead and use binary packages and now I'm heading slowly 
back to having to run from source again to keep things up and stable.

cqst wrote:
> I had the same problem and didnt find how to fix it, so i decided to update to BASE : 
> http://secureideas.sourceforge.net/
> its build on ACID, works fine, you can keep your mysql database, just have to config a file and its ok.
>
> On Mon, 14 Nov 2005 15:02:04 -0800
> Rhomboid <rhomboid@globalmegahypernet.com> wrote:
>
>
> > I an update/upgrade this morning and after updating acidlab several 
> > functions are not working.
> >
> > Example - select check boxes not working
> >
> > Home page -> Most frequent 5 Alerts -> select any box to left of 
> > "Signature" column. Results in error: "No alerts were selected or the 
> > DELETE was not successful".
> >
> > Example - drilling down to any column in alert listings results in 
> > database error
> >
> > Home page -> Most recent 15 Unique Alerts -> click on any item in "Total 
> > #" column. Results in 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 '-50, 50' at line 1"
> >
> > Restarted all services, cleared browser cache, rebuilt alert database, 
> > tried 'Repair Tables' option on Maintenance page.