View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000346bareos-corewebuipublic2014-10-02 14:002015-01-26 16:20
Reportersuschman Assigned To 
PrioritylowSeveritytweakReproducibilityalways
Status closedResolutionno change required 
PlatformLinuxOSDebianOS Version7
Product Version13.2.3 
Summary0000346: bareos database format 2002 not understood by bareos-webui
DescriptionAfter getting bareos-webui running, it shows following errors.
Since i upgraded to Bareos 13.2.3 before, which changed DB format from 2001 to 2002, i assume its not compatible with it.

Notice: Undefined variable: duration in /usr/share/bareos-webui/module/Job/src/Job/Model/JobTable.php on line 249
Notice: Undefined variable: interval in /usr/share/bareos-webui/module/Job/src/Job/Model/JobTable.php on line 262
Notice: Undefined variable: interval in /usr/share/bareos-webui/module/Job/src/Job/Model/JobTable.php on line 263

With final:
File: /usr/share/php5/Zend/Db/Adapter/Driver/Pdo/Statement.php:245
Message: Statement could not be executed (42000 - 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR EndTime >= ) ORDER BY `Job`.`JobId` DESC' at line 1)

File: /usr/share/php5/Zend/Db/Adapter/Driver/Pdo/Statement.php:240
Message: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR EndTime >= ) ORDER BY `Job`.`JobId` DESC' at line 1
TagsNo tags attached.

Activities

frank

frank

2014-10-22 13:06

developer   ~0001022

I think you have set the driver field in your configuration set to "pdo_mysql", but this value has to be set case-sensitive "Pdo_Mysql".

This was the only way I was able to reproduce the issue you reported. Handling it case-insensitive as well might change in future.

Please let me know if it solves the issue on your site.

Thanks.
frank

frank

2015-01-23 14:20

developer   ~0001211

Last edited: 2015-01-23 14:23

 Improved and simplified the configuration. The dbadapter/dbdriver parameter accepts the case-insensitive values, "mysql" and "postgresql", in future releases, to make things easier.

Issue History

Date Modified Username Field Change
2014-10-02 14:00 suschman New Issue
2014-10-20 17:12 mvwieringen Assigned To => frank
2014-10-20 17:12 mvwieringen Status new => assigned
2014-10-22 13:06 frank Note Added: 0001022
2014-12-04 11:31 frank Priority normal => low
2014-12-04 11:31 frank Severity block => tweak
2014-12-04 13:11 mvwieringen Status assigned => feedback
2015-01-23 13:02 frank Status feedback => closed
2015-01-23 13:02 frank Resolution open => no change required
2015-01-23 14:20 frank Note Added: 0001211
2015-01-23 14:20 frank Status closed => feedback
2015-01-23 14:20 frank Resolution no change required => reopened
2015-01-23 14:20 frank Note Edited: 0001211
2015-01-23 14:23 frank Note Edited: 0001211
2015-01-23 14:25 frank Status feedback => closed
2015-01-23 14:25 frank Resolution reopened => no change required
2015-01-26 16:20 mvwieringen adm Assigned To frank =>