Erro webacula [RESOLVIDO]

rpfreitas
(usa Linux Mint)

Enviado em 31/08/2014 - 04:18h

Olá pessoal estou enfretendo este erro, sempre quando eu clico no menu job job execultando da o seguinte erro a baixo.
Obs: eu ja troquei versão de php, versão do Zend framework olhei todas as senhas do banco mas não encontrei o motivo do problema, caso alguem possa me dar uma ajuda fico agradecido.
An error occurred
Message :

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION j.TIMEDIFF does not exist, 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.TIMEDIFF(NOW(), StartTime) AS DurationTime, s.JobStatusLong, c.Name AS ClientName, p.Name AS PoolName 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 WHERE ((j.EndTime = 0) OR (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 > '2014-08-24 07:14:57') ORDER BY StartTime ASC, JobId ASC
Trace:

#0 /var/www/webacula/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/webacula/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /var/www/webacula/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Select), Array)
#3 /var/www/webacula/library/Zend/Db/Select.php(686): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
#4 /var/www/webacula/application/models/Job.php(289): Zend_Db_Select->query()
#5 /var/www/webacula/application/controllers/JobController.php(63): Job->getRunningJobs()
#6 /var/www/webacula/library/Zend/Controller/Action.php(516): JobController->runningAction()
#7 /var/www/webacula/library/Zend/Controller/Dispatcher/Standard.php(308): Zend_Controller_Action->dispatch('runningAction')
#8 /var/www/webacula/library/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(249): Zend_Controller_Front->dispatch()
#10 {main}

System Information:

DB Bacula : PDO_MYSQL 5.1.73
Version for Bacula Catalog database : 14
Director : srv-backup-dir Version: 7.0.5 (28 July 2014) x86_64-unknown-linux-gnu redhat
Bconsole : Version: 7.0.5 (28 July 2014) x86_64-unknown-linux-gnu redhat
Webacula version : 5.5.1, build 2011.09.07
Zend Framework : 1.12.8
PHP : 5.4.31
id : uid=48(apache) gid=48(apache) groups=48(apache) context=unconfined_u:system_r:httpd_t:s0

O que fazer em seguida?

Please help me improve the software you use by filing a report at Webacula bugtracker. Useful details include how to reproduce the error, and information (error message, trace) which is shown above, bacula version, etc.

gonzagasombrio
(usa Ubuntu)

Enviado em 01/09/2014 - 22:59h

Amigo com ajuda do autor brasileiro do Livro Bacula Heitor Farias, me disse para tentar instalar o ZEND na versão 1.11.5.. no meu caso resolveu!!!

rpfreitas
(usa Linux Mint)

Enviado em 03/09/2014 - 18:54h

Obrigado por responder mas já tinha conseguido resolver usando esta mesma técnica mas no meu caso tive que usar o 1.12.0 foi o que ficou melhor e mais estável.