On 29.12.2017 at 16:46 wrote George Kontostanos: > On Friday, December 29, 2017 at 4:19:39 PM UTC+2, George Kontostanos wrote: >> Hello list, >> >> I upgraded my Director to Bareos 16.2.7 via source. Now, when trying to >> create the suggested index from the release notes: >> >> CREATE INDEX PathId_JobId_FileNameId_FileIndex ON File(PathId,_JobId, >> _FilenameId,_FileIndex); >> >> I get the following error: >> >> ERROR 1072 (42000): Key column '_JobId' doesn't exist in table >> >> mysql> desc File; >> +------------+----------------------+------+-----+---------+----------------+ >> | Field | Type | Null | Key | Default | Extra | >> +------------+----------------------+------+-----+---------+----------------+ >> | FileId | bigint(20) unsigned | NO | PRI | NULL | auto_increment | >> | FileIndex | int(10) unsigned | YES | | 0 | | >> | JobId | int(10) unsigned | NO | MUL | NULL | | >> | PathId | int(10) unsigned | NO | | NULL | | >> | FilenameId | int(10) unsigned | NO | | NULL | | >> | DeltaSeq | smallint(5) unsigned | YES | | 0 | | >> | MarkId | int(10) unsigned | YES | | 0 | | >> | LStat | tinyblob | NO | | NULL | | >> | MD5 | tinyblob | YES | | NULL | | >> +------------+----------------------+------+-----+---------+----------------+ >> 9 rows in set (0.01 sec) >> >> Any idea what I am doing wrong here? >> >> Thanks >> >> George > > Hmmm, I believe the correct syntax is: > > CREATE INDEX PathId_JobId_FileNameId_FileIndex ON File(PathId, JobId, > FilenameId, FileIndex);
Yes, you are right. Unfortunately the process of creating HTML from a Latex document do have some strange effects/errors, like adding an underscore in same places. -- Jörg Steffens [email protected] Bareos GmbH & Co. KG Phone: +49 221 630693-91 http://www.bareos.com Fax: +49 221 630693-10 Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: S. Dühr, M. Außendorf, Jörg Steffens, P. Storz -- You received this message because you are subscribed to the Google Groups "bareos-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
