Hello Danilo, This problem is already fixed in 9.0.8.
The 9.0.8 packages will be available at the beginning of next week (probably Sunday or Monday). Till that time you can try a patch provided in the following thread: https://sourceforge.net/p/bacula/mailman/message/36318324/ The reported error there is slightly different but the error message for this bug is different depending on the catalog database type. Best regards. Marcin Haba (gani) On 8 June 2018 at 12:36, Danilo Silva de Oliveira <danilo.olive...@synchro.com.br> wrote: > Good morning dear ones, > > After updating baculum to version 90.07 I get the following error after > selecting the file to restore. > > Error 100 - Problem with connection to remote host. cURL error 0: . > > PDOException > > Description > > SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 > column(s) > > Source File > > /usr/share/baculum/htdocs/protected/API/Class/VolumeManager.php (94) > > 0083: $connection = VolumeRecord::finder()->getDbConnection(); > 0084: $connection->setActive(true); > 0085: $sql = sprintf('SELECT first_index, last_index, VolumeName AS > volname, InChanger AS inchanger FROM ( > 0086: SELECT VolumeName, InChanger, MIN(FirstIndex) as first_index, > MAX(LastIndex) as last_index > 0087: FROM JobMedia JOIN Media ON (JobMedia.MediaId = > Media.MediaId) > 0088: WHERE JobId = %d GROUP BY (VolumeName, InChanger) > 0089: ) AS gv, File > 0090: WHERE FileIndex >= first_index > 0091: AND FileIndex <= last_index > 0092: AND File.FileId = %d', $jobid, $fileid); > 0093: $pdo = $connection->getPdoInstance(); > > 0094: $result = $pdo->query($sql); > > 0095: $ret = $result->fetchAll(); > 0096: $pdo = null; > 0097: $volumes = array(); > 0098: if (is_array($ret)) { > 0099: for ($i = 0; $i < count($ret); $i ) { > 0100: $volumes[] = array( > 0101: 'first_index' => $ret[$i]['first_index'], > 0102: 'last_index' => $ret[$i]['last_index'], > 0103: 'volume' => $ret[$i]['volname'], > 0104: 'inchanger' => $ret[$i]['inchanger'] > 0105: ); > 0106: } > > > Anyone have any idea how to solve this? > > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > Bacula-users mailing list > Bacula-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/bacula-users > -- "Greater love hath no man than this, that a man lay down his life for his friends." Jesus Christ "Większej miłości nikt nie ma nad tę, jak gdy kto życie swoje kładzie za przyjaciół swoich." Jezus Chrystus ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
