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
