Error when Running a job
Brought to you by:
tim4dev
Menu
▾
▴
#124 Error when Running a job
Message :
SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "(" LINE 1: ...oolId, j.FileSetId, j.PurgedFiles, j.JobStatus, j.(NOW() - S... ^, query was: SELECT DISTINCT j.JobId, j.Name AS JobName, j.Level, j.ClientId, j.StartTime, j.EndTime, j.VolSessionId, j.VolSessionTime, j.JobFiles, j.JobBytes, j.JobErrors, j.Reviewed, j.PoolId, j.FileSetId, j.PurgedFiles, j.JobStatus, j.(NOW() - StartTime) AS DurationTime, s.JobStatusLong, c.Name AS ClientName, p.Name AS PoolName, sd.* FROM Job AS j LEFT JOIN Status AS s ON j.JobStatus = s.JobStatus LEFT JOIN Client AS c ON j.ClientId = c.ClientId LEFT JOIN Pool AS p ON j.PoolId = p.PoolId LEFT JOIN webacula_jobdesc AS sd ON j.Name = sd.name_job WHERE ((j.EndTime IS NULL) OR (j.JobStatus IN ('C','R','B','e','F','S','m','M','s','j','c','d','t','p','i','a','l','L'))) AND (j.StartTime > ( NOW() - INTERVAL '7 days' )) ORDER BY StartTime ASC, JobId ASC
Trace:
0 /usr/share/php/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
1 /usr/share/php/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
2 /usr/share/php/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
3 /usr/share/php/Zend/Db/Select.php(686): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
4 /var/www/webacula/application/models/Job.php(311): Zend_Db_Select->query()
5 /var/www/webacula/application/controllers/JobController.php(64): Job->getRunningJobs()
6 /usr/share/php/Zend/Controller/Action.php(516): JobController->runningAction()
7 /usr/share/php/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('runningAction')
8 /usr/share/php/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http))
9 /var/www/webacula/html/index.php(258): Zend_Controller_Front->dispatch()
10 {main}
System Information:
DB Bacula : PDO_PGSQL 8.4.20
Version for Bacula Catalog database : 14
Director : PEA-BACKUP-dir Version: 5.2.13 (19 February 2013) x86_64-redhat-linux-gnu redhat Enterprise release
Bconsole : Version: 5.2.13 (19 February 2013) x86_64-redhat-linux-gnu redhat Enterprise release
Webacula version : 7.0.0, build 2014.10.05
Zend Framework : 1.12.9
PHP : 5.3.3
id : uid=48(apache) gid=48(apache) groups=48(apache) context=unconfined_u:system_r:httpd_t:s0
The solution is on bug #127.