[MSNoise] [EXTERNAL] Re: "Key 'da_index' doesn't exist in table 'data_availability'"

[Thomas Lecocq]

yes,

for some odd reason, in specific cases, the indexes are not created at 
install time.

thomas


Le 04/05/2018 à 21:48, Flinders, Ashton a écrit :
> even if this is a brand new db?
>
>
> On Fri, May 4, 2018 at 12:47 PM, Thomas Lecocq <Thomas.Lecocq at seismology.be>
> wrote:
>
>> Hi,
>>
>> yep:
>>
>> "msnoise upgrade_db"
>>
>> Thomas
>>
>>
>> Le 04/05/2018 à 21:44, Flinders, Ashton a écrit :
>>
>>> [DEBUG] ERROR: (pymysql.err.InternalError) (1176, "Key 'da_index' doesn't
>>> exist in table 'data_availability'") [SQL: 'SELECT data_availability.ref
>>> AS
>>> data_availability_ref, data_availability.net AS data_availability_net,
>>> data_availability.sta AS data_availability_sta, data_availability.comp AS
>>> data_availability_comp, data_availability.path AS data_availability_path,
>>> data_availability.file AS data_availability_file,
>>> data_availability.starttime AS data_availability_starttime,
>>> data_availability.endtime AS data_availability_endtime,
>>> data_availability.data_duration AS data_availability_data_duration,
>>> data_availability.gaps_duration AS
>>>
>>> Any idea?
>>>
>>>
>>>
>> _______________________________________________
>> MSNoise mailing list
>> MSNoise at mailman-as.oma.be
>> http://mailman-as.oma.be/mailman/listinfo/msnoise
>>
>
>