On 10/19/06, Jason Martens <[EMAIL PROTECTED]
> wrote:
Hey all,
I'm having a problem where I get this error when I log in:
Query failed: Can't find file: 'all_logs' (errno: 2)
And if I try to select or do pretty much any operation on that table, I
get a similar mysql error:
mysql> desc all_logs;
ERROR 1146 (42S02): Table ' syslog.all_logs' doesn't exist
However, my daily logrotate script says this:
/etc/cron.daily/php-syslog-ng:
Starting logrotate
2006-10-19 06:25:49
Log rotate ended successfully.
Now optimizing the old logs.
Getting list of log tables.
Searching for tables to drop.
Dropping logs20060720!
Creating merge table.
2006-10-19 06:25:55
All done!
Any idea why this table would be missing? If so, what's the best way to
go about re-creating it (without wiping my database)?
BTW, I'm using 2.9.2.
Thanks,
Jason Martens
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Php-syslog-ng-support mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
--
=============================
Clayton Dukes
NMS Consulting Engineer, Advanced Services
Cisco Systems, Inc.
Office: 919.392.6122
Fax: : 919.869.1580
Cell: 813.545.7373
Email: [EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
=============================
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Php-syslog-ng-support mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/php-syslog-ng-support
