Reportula icon indicating copy to clipboard operation
Reportula copied to clipboard

Getting the below error when running the BaculaStats:collect from the crontab manually

Open metalcated opened this issue 10 years ago • 0 comments

MySQL Server 5.5 It also doesn't matter if the database tables/columns are all lowecase, I have tried both ways and get the same results. But instead of "bacula.job' doesn't exist" it says "bacula.Job' doesn't exist"

[root@gnsyrbac01] /bacula/mounts$ php /var/www/html/reportula/artisan BaculaStats:collect -vvv [Illuminate\Database\QueryException] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bacula.job' doesn't exist (SQL: select (max(starttime) - min(starttime)) AS timediff from job where starttime >= 2015-01-13 18:29 and endtime <= 2015-01-14 18:29)

Exception trace: () at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:625 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581 Illuminate\Database\Connection->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 Illuminate\Database\Connection->select() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1359 Illuminate\Database\Query\Builder->runSelect() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1349 Illuminate\Database\Query\Builder->getFresh() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1336 Illuminate\Database\Query\Builder->get() at /var/www/html/reportula/app/commands/BaculaStatsCommand.php:81 BaculaStatsCommand->fire() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:112 Illuminate\Console\Command->execute() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:252 Symfony\Component\Console\Command\Command->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:100 Illuminate\Console\Command->run() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:889 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:193 Symfony\Component\Console\Application->doRun() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:124 Symfony\Component\Console\Application->run() at /var/www/html/reportula/artisan:59

[PDOException]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'bacula.job' doesn't exist

Exception trace: () at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 PDO->prepare() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 Illuminate\Database\Connection->Illuminate\Database{closure}() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:617 Illuminate\Database\Connection->runQueryCallback() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:581 Illuminate\Database\Connection->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 Illuminate\Database\Connection->select() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1359 Illuminate\Database\Query\Builder->runSelect() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1349 Illuminate\Database\Query\Builder->getFresh() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1336 Illuminate\Database\Query\Builder->get() at /var/www/html/reportula/app/commands/BaculaStatsCommand.php:81 BaculaStatsCommand->fire() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:112 Illuminate\Console\Command->execute() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Command/Command.php:252 Symfony\Component\Console\Command\Command->run() at /var/www/html/reportula/vendor/laravel/framework/src/Illuminate/Console/Command.php:100 Illuminate\Console\Command->run() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:889 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:193 Symfony\Component\Console\Application->doRun() at /var/www/html/reportula/vendor/symfony/console/Symfony/Component/Console/Application.php:124 Symfony\Component\Console\Application->run() at /var/www/html/reportula/artisan:59

BaculaStats:collect

metalcated avatar Jan 15 '15 03:01 metalcated